Skip to main content
2 of 3
Capitalisation.
Michael Green
  • 25.1k
  • 13
  • 53
  • 98

Keep Execution Plan in Cache - SQL Server 2012

How can I keep a query execution plan in SQL Server's cache and use it several times?

When I execute a query for the first time it takes 7 seconds. After that it takes only 1 second. This query is running once on daily basis.

Is there any way I can keep the execution plan and use it every day?

Thanks, V

Virul Patel
  • 171
  • 1
  • 3
  • 8