Answer:

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

Question:

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?