Can we retrieving old execution plan for a query
ex: query was executed around 2 am, but i need to find the execution plan at 9 am
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
You can look in the plan cache by querying sys.dm_exec_cached_plans, but it may or may not still be there.
19 People are following this question.
Query Plan Usefulness
Getting Record Count From two Table join.
How does oracle respond to a Query ?
Percentage Calculation with two decimal digit rounded off in mysql