Recently I have faced one issue.
One query is taking very long time which executed 1 week back well. client told that there was difference in the execution plan for the same query 1 week back and now.
He asked me to force the previous execution plan. my question is how to find the current running query execution plan with out generating execution plan because it will not follow always the plan which generates the explain plan.
How to find the previous execution plan and how to force the execution plan.
Kindly share your views, Thanks in advance.