Published 20 November 2017
QUERY HINT is used
Use query hints with caution.
Query hints tell the SQL Server query optimizer to use specific behavior for a query. By hinting the query optimizer, SQL Server is unable to optimize a query plan fully. If poor performance is fixed in a future release of SQL Server, the presence of query hints may prevent SQL Server from optimizing a query and getting the best possible performance.
You should regularly review and test all hints in response to changes in the data distribution, on upgrade to a new SQL Server version, or application of a new service pack.
For more information on the dangers of using hints, see SQL Prompt Code Analysis: A Hint is Used (PE004-7).