1 Reply Latest reply: Oct 9, 2012 4:23 AM by 888695 RSS

    strange behavior of explain plan

      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