This discussion is archived
1 Reply Latest reply: Oct 9, 2012 2:23 AM by 888695 RSS

strange behavior of explain plan

888695 Newbie
Currently Being Moderated
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


  • Correct Answers - 10 points
  • Helpful Answers - 5 points