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 - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here