Browse oracle-l: This Month's Archive • Main Archive Page • Related posts • Previous by Date • Next by Date

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 thoughtabout using a common table expression ("with ...") to model thehierarchy from your connect by instead, without using connect by, andsee what happens?


Just a thought.

Ciao
Fuzzy
:-)
---------------------------------------
http://fuzzydata.wordpress.com/


--
http://www.freelists.org/webpage/oracle-l

References:

Re: RMAN: restoring autobackup spfile and controlfile
From: Alex Gorbachev

RE: RMAN: restoring autobackup spfile and controlfile
From: Allen, Brandon

Re: RMAN: restoring autobackup spfile and controlfile
From: Alex Gorbachev

connect by 10.2.0.2/3 - any workaround?
From: GovindanK