2 Replies Latest reply: Nov 14, 2012 3:01 PM by 16654 RSS

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

    424700
      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.