Re: Avoid multiple scan of the same table

On Thu, 21 Aug 2008 07:58:18 -0700 (PDT), Mark D Powell <Mark.Powell_at_eds.com> wrote:

>I do not think that you constructed your example correctly since you
>are selecting the exact same columns from the same table but you apply
>a where clause only to the second query but all the rows fetched by
>the second query where fetched by the first query yet you are going to
>discard the duplicates.

Mark,
If you read *very* closely, you'll see the last column is different. I almost made the same comment, I didn't see it either.

Regards,

-- 
Sybrand Bakker
Senior Oracle DBA