0 Replies Latest reply: Oct 7, 2013 9:48 AM by 953679 RSS

    Explain plan differs with execution path 9i

    953679

      Hi All,

       

      I see a strange behavior of execution path changing when ever gathering stats including indexes. I have  created stored out line as well,

      how ever explain plan is showing rite plan and actual execution is picking bad plan. Can any one help here. Version 9i .

       

      Regards,

      Ram.P