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