Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: connect by 10.2.0.2/3 - any workaround?

Re: connect by 10.2.0.2/3 - any workaround?

From: Grant Allen <gxallen_at_gmail.com>
Date: Thu, 02 Aug 2007 11:12:10 +1000
Message-ID: <46B12F6A.2040603@gmail.com>


GovindanK wrote:
> Hello All
>
> One of our queries using CONNECT BY & START WITH and it runs very slow.
> Was not the case with 9.2.0.6; I took a
> look at the following Metalink Notes:
>
> [...snip things tried...]
>
> Any workarounds would be appreciated.
>

Can you rewrite the SQL? As you're on 10.2.0.2/3 now, have you thought about using a common table expression ("with ...") to model the hierarchy from your connect by instead, without using connect by, and see what happens?

Just a thought.

Ciao
Fuzzy
:-)



http://fuzzydata.wordpress.com/
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 01 2007 - 20:12:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US