Re: connect by 10.2.0.2/3 - any workaround?
- From: Grant Allen <gxallen@xxxxxxxxx>
- To: gkatteri@xxxxxxxxxxx
- Date: Thu, 02 Aug 2007 11:12:10 +1000
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/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
