Jump to content
pravinsarara

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:

http://www.dba-oracle.com/t_swapping_sql_profiles.htm

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

http://www.remote-dba.net/t_op_sql_hinted_query.htm

Have fun!

Share this post


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

×