Re: DELETE and WHERE

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 05 Jan 2000 20:48:31 +0800
Message-ID: <38733D9F.28BD@yahoo.com>

GERNEZ wrote:
>
> Hello,
>
> Does anyone know, it is possible to optimize a delete in a big table
> ????
> (the table is NOLOGGING option and i have a condition in this delete)
>
> Thanks

If you're deleting just a small portion of rows, then its a case of tuning your SQL.

If you're deleting a large portion then some options are:

1. parallelise the delete
2. copy the ones you want to retain to a temp table, truncate, reinsert

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Jan 05 2000 - 06:48:31 CST