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 Member, Pro, Standard Member, Standard, Pro Member Annual – Fall Sale, Pro Member Monthly – Fall Sale, Standard Member Annual – Fall Sale, and Standard Member Monthly – Fall Sale members only.
Log In Register

Comments are closed.