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