O'Reilly logo
  • Klaus Nji thinks this is interesting:

The main criterion to remember is that SQL Server does not use an index for the more efficient row locator lookup if at least the first column of the index is not included in a valid search argument (SARG) or join clause. You should keep this point in mind when choosing the column order for composite indexes

From

Cover of Microsoft® SQL Server 2012 Unleashed

Note

Key