• You're on the right track. But note that, like it's highlighted on the documentation, because the SQL Server query optimizer typically selects the best execution plan for a query, it's recommend that hints be used only as a last resort by experienced developers and database administrators.