Abstract
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.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2012 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
About this chapter
Cite this chapter
Strate, J. (2012). Indexing Outside the Bubble. In: Pro SQL Server 2012 Practices. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-4771-5_7
Download citation
DOI: https://doi.org/10.1007/978-1-4302-4771-5_7
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-4770-8
Online ISBN: 978-1-4302-4771-5
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books