In general, SQL Server will only use an index if the order of the columns in the index matches the order of the columns in the WHERE clause, JOIN condition, ORDER BY clause, or some other part of a ...