Re: Avoid multiple scan of the same table

From: <>
Date: Sun, 24 Aug 2008 23:13:48 +0200
Message-ID: <>

On Fri, 22 Aug 2008 14:11:12 -0700 (PDT), wrote:

>I'm still not avoiding multiple scan of the table.. With "With
>Clause" , I believe Oracle creates the temp table and then use that
>table later in the query..

*believe* has no place in this thread.
Did you obtain the plan for this query, using dbms_xplan.display? If you didn't please do obtain the plan. But don't make up fairy tales.

Sybrand Bakker
Senior Oracle DBA
Received on Sun Aug 24 2008 - 16:13:48 CDT

Original text of this message