Indexing Outside the Bubble

  • Jason Strate


When it comes to indexing, there are many best practices we could adhere to. These practices help define how and when we should build our indexes. They provide a starting point for us, and help guide us through creating the best set of indexes on the tables in our databases. Some popular best practices include the following:
  • Use clustered indexes on primary keys, by default.

  • Index on search columns.

  • Use a database-level fill factor.

  • Use an index-level fill factor.

  • Index on foreign key columns.


Execution Plan Event Session Gument Output Indexing Opportunity Select Count 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Bradley Ball, TJay Belt, Glenn Berry, Jes Borland, Carlos Bossy, Louis Davidson, Jeremy Lowell, Ben DeBow, Grant Fritchey, Wendy Pastrick, Kellyn Pot’vin, Jonathan Gardner, Jesper Johansen, Mladen Prajdić, Herve Roggero, Chris Shaw, Gail Shaw, Jason Strate 2012

Authors and Affiliations

  • Jason Strate

There are no affiliations available

Personalised recommendations