Re: Avoid multiple scan of the same table

From: <>
Date: Thu, 21 Aug 2008 17:04:25 +0200
Message-ID: <>

On Thu, 21 Aug 2008 07:58:18 -0700 (PDT), Mark D Powell <> 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.

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.


Sybrand Bakker
Senior Oracle DBA
Received on Thu Aug 21 2008 - 10:04:25 CDT

Original text of this message