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.
KeywordsExecution Plan Event Session Gument Output Indexing Opportunity Select Count
Unable to display preview. Download preview PDF.
© 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