Re: Avoid multiple scan of the same table

From: <sybrandb_at_hccnet.nl>
Date: Sun, 24 Aug 2008 23:13:48 +0200
Message-ID: <tjj3b41ujbhlm1m7i6esr8a4h2rhd9k54p@4ax.com>

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

>Folks,
>
>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

This message: [ Message body ]
Next message: sybrandb_at_hccnet.nl: "Re: oracle Bug with JDBC ??"
Previous message: DA Morgan: "Re: Help for an Oracle Newbie"
In reply to: maks71_at_gmail.com: "Re: Avoid multiple scan of the same table"
Next in thread: fitzjarrell_at_cox.net: "Re: Avoid multiple scan of the same table"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message