Re: help!! how to suspends index work

Jorge

If you want to delete them all, use the TRUNCATE command. If you want to save only a few, do a CREATE TABLE AS SELECT of the few rows you want to keep, TRUNCATE the old table, then INSERT using a SELECT from the table you created with CTAS.

For real performance, both the CTAS and the INSERT can be parallelized.

HTH. Pete

Jorge wrote:

> Hello
> I need to delete many rows of a table but It have aboute 10 indexes and
> I need to do it quickly, How do I?

Received on Thu Sep 30 1999 - 11:29:27 CDT