Re: connect by 10.2.0.2/3 - any workaround?

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://www.freelists.org/webpage/oracle-l