Published 20 November 2017
TABLE HINT is used
It is not recommended to use table hints.
It is not a good idea to use any of the rich variety of table hints. The SQL Server query optimizer usually selects the best index for a join, so these should be used only as a last resort by experienced developers and database administrators.