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
Database Application Development
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Oct 9, 2012 4:23 AM by
strange behavior of explain plan
Oct 9, 2012 4: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
This content has been marked as final.
Show 1 reply
Re: strange behavior of explain plan
Oct 9, 2012 4:23 AM
in response to
HI i found the correct category