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).

Didn't find what you were looking for?