Jump to content

How to Force the Optimizer to choose Old Plan.please share the Steps

Recommended Posts

Hi again,

To get an old plan, user the techniques above to get the plan, and then make a SQL profile for it.

Then, swap the current plan with the older plan:


You can also do this with Optimizer plan stability (stored outlines):


Have fun!

Share this post

Link to post
Share on other sites
This topic is now closed to further replies.