Re: Avoid multiple scan of the same table
Date: Sun, 24 Aug 2008 23:13:48 +0200
On Fri, 22 Aug 2008 14:11:12 -0700 (PDT), maks71_at_gmail.com 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 DBAReceived on Sun Aug 24 2008 - 16:13:48 CDT