Re: Delete with Huge table

delete performance can be tuned in a very similar manner to select performance.

look at your WHERE clause... and maybe don't drop all the indexes, keep the
appropriate ones.

randy

Eric DUCHET wrote:
>
> Hi,
>
> I want to know if Oracle works fine for deleting part of huge table (about
> 50 000 000 rows).
> My system is AIX 4.2
> Oracle v7.3.4
> No archive log.
>
> My performance on my system for deleting 1 000 000 rows is very bad.
> How can I improve that ?
>
> (I already have dropped all my indexes)
>
> Can I lauch a parallel query ?
>
> Thanx a lot.
Received on Tue Nov 30 1999 - 13:03:39 CST