Re: Avoid multiple scan of the same table
Date: Thu, 21 Aug 2008 17:04:25 +0200
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.
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 DBAReceived on Thu Aug 21 2008 - 10:04:25 CDT