Re: [PERFORM] Massive delete of rows, how to proceed?

I don't believe DROP is necessary; use TRUNCATE instead. No need to re-create dependent objects. "Peter Childs" <[EMAIL PROTECTED]> wrote .. > On 24/11/06, Arnau <[EMAIL PROTECTED]> wrote: > > Hi all, > > > >I have a table with statistics with more than 15 million rows. I'd > > like to delete

[PERFORM] Massive delete of rows, how to proceed?

On 24/11/06, Arnau <[EMAIL PROTECTED]> wrote: Hi all, I have a table with statistics with more than 15 million rows. I'd like to delete the oldest statistics and this can be about 7 million rows. Which method would you recommend me to do this? I'd be also interested in calculate some kind of