Re: Avoid multiple scan of the same table

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Thu, 21 Aug 2008 13:18:24 -0700 (PDT)
Message-ID: <137def04-25a6-4353-a09e-0d084f85973b@p25g2000hsf.googlegroups.com>


On Aug 21, 11:04 am, sybra..._at_hccnet.nl wrote:
> On Thu, 21 Aug 2008 07:58:18 -0700 (PDT), Mark D Powell
>
> <Mark.Pow..._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

Darn. I swear I reread the column list too. Some days.

  • Mark D Powell --
Received on Thu Aug 21 2008 - 15:18:24 CDT

Original text of this message