CrazyEngineers
  • Why does Oracle flip plans?

    Neeraj Sharma

    Member

    Updated: Oct 25, 2024
    Views: 1.1K
    As most of us will be aware, every SQL query has an explain plan that lists out the steps that Oracle is going to take in order to execute the query and it helps us a lot in tuning the query too. But at times, the plan that executed well for a query today gets flipped and generates another bad plan tomorrow thereby making the query run longer.

    What do you think might be the reason for these flips? Does it mean we can't trust Oracle's explain plan generating capability or are there any other circumstances on which this behavior hinges?
    0
    Replies
Howdy guest!
Dear guest, you must be logged-in to participate on CrazyEngineers. We would love to have you as a member of our community. Consider creating an account or login.
Home Channels Search Login Register