Pro Members, SQL Server, Standard Members

Tips for using query hints in SQL Server 2017

Tips for using query hints in SQL Server 2017 You can use the KEEP PLAN query hint if you want to reduce the estimated recompile threshold for a query. For example, using this hint reduces the number of recompiles when multiple table updates occur. This example shows how you can use the KEEP PLAN hint: SELECT * FROM authors OPTION…

This content is for Pro, Pro Member, Pro Member Annual – Valentine’s, Pro Member Monthly – Valentine’s, Standard, Standard Member, Standard Member Annual – Valentine’s and Standard Member Monthly – Valentine’s members only.
Log In Register
Facebooktwittergoogle_plusredditpinterestlinkedinmail

Comments are closed.