This discussion is archived
2 Replies Latest reply: Nov 14, 2012 1:01 PM by 16654 RSS

Oracle SQL performance issue 10g vs 11g  Connect by prior

424700 Newbie
Currently Being Moderated
HI All,
I am facing query performance issue in 11g. it takes long time to run or couldn't run.

Same script able to run in 10g faster.

Database were upgraded 10g to 11g.

Those script using "connect by" hit the issue.


Please help.


Scenario.

select col1 from tableA
where col2 in (select col2
from tableB
start with col3 IN (select col3 from tableC where col4=22222)
connect by prior node = parent_node
)


They were many script same like this scenario , it is difficult to change the script.



Thanks.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points