Re: query taking too much time to execute

Mark C. Stock wrote:
> totally different logic
>
> OP's deletes all but one regord for each ASSORTM2
>
> this suggestion selects all but one record
>
> either way, lots of undo is generated -- depending on how many ASSORTM2
> groups there are.
>
> bottom line, the execution plan needs to be reviewed
>
> ++ mcs

Mark,

You're right, of course. Totaly mis-read the OP :-) Received on Wed Apr 26 2006 - 11:08:52 CDT