Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Explain plan differs with execution path 9i

Raghu.OraOct 7 2013 — edited Feb 17 2015

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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 4 2013
Added on Oct 7 2013
0 comments
767 views