On Thu, Nov 15, 2007 at 09:43:52AM -0500, Andrew Sullivan wrote:
> 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.
Yup, that's what I'm confused about as well.
> They have to be sorted somehow, unless you're just deleting 2million random
> records.
To be fair; they're not random, just rather arbitrarily chosen.
Sam
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
