Skip to main content
Database Administrators

Return to Question

Tweeted twitter.com/StackDBAs/status/896293480112291840
deleted 13 characters in body; edited tags; edited title
Source Link
Paul White ♦
Paul White ♦
  • 90.3k
  • 30
  • 424
  • 663

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

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

Keep Execution Plan in Cache

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?

Capitalisation.
Source Link
Michael Green
Michael Green
  • 25.1k
  • 13
  • 53
  • 98

How I can Keep Query ExecutionI keep a query execution plan in SQL SErverServer's cache and use it several time.times?

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

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

Thanks, V

How I can Keep Query Execution plan in SQL SErver and use several time.

When execute Query first time it takes 7 seconds, but after that it takes only 1 second. Query is running once on daily basis.

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

Thanks, V

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

Source Link
Virul Patel
Virul Patel
  • 171
  • 1
  • 3
  • 8

Keep Execution Plan in Cache - SQL Server 2012

How I can Keep Query Execution plan in SQL SErver and use several time.

When execute Query first time it takes 7 seconds, but after that it takes only 1 second. Query is running once on daily basis.

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

Thanks, V