Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Please enter a title.
You can not post a blank message. Please type your message and try again.
Database Application Development
This discussion is archived
on Oct 9, 2012 9:23 AM by 888695
strange behavior of explain plan
Oct 9, 2012 9:09 AM
Hello i don't know if this is the correct category for posting my issue.
I ma facing a strange behavior of the explain plan. What i mean!
I have a query which runs very fast and it is well optimized. the explain plan shows very good results in cost and execution time.
when i am running the query for a second or a third time is appearing a different explain plan with not such a good cost and execution time.
Could you please guide me what it might be wrong???
thanks a lot
I have the same question
Show 0 Likes
This content has been marked as final.
Show 1 reply
Re: strange behavior of explain plan
Oct 9, 2012 9:23 AM
in response to
HI i found the correct category