Re: Chunk Delete

On Thu, Nov 15, 2007 at 03:33:04PM +0200, Abraham, Danny wrote:
>
> Based on a condition,  2,000,000 records should be deleted daily.

Why not use that condition (which I presume is indexed) as the criterion for
your delete?  I mean, how else are you getting those row numbers in Oracle.
They have to be sorted somehow, unless you're just deleting 2million random
records.

A

--
Andrew Sullivan
Old sigs will return after re-constitution of blue smoke