Tips for using SQL Server 2012 Join Hints If you want to set any join hints, do not remember to test the query with hint and without the hint and compare results. Because SQL Server 2012 query optimizer usually proposes the best execution plan, you should test the query with join hint and use this hint only when it provides...