© Jason Strate 2019
Jason StrateExpert Performance Indexing in SQL Server 2019https://doi.org/10.1007/978-1-4842-5464-6_8

8. Indexing Myths and Best Practices

Jason Strate
(1)
Hugo, MN, USA
 
In the past few chapters, we’ve defined indexes and showed how they are structured. In the upcoming chapters, you’ll be looking at strategies to build indexes and ensure that they behave as expected. In this chapter, we’ll dispel some common myths and show how to build the foundation for creating indexes.
Myths result in an unnecessary burden when attempting to build an index. Knowing the myths associated with indexes can prevent you from using indexing strategies that will be counterproductive. The following are the indexing myths discussed in this chapter: ...

Get Expert Performance Indexing in SQL Server 2019: Toward Faster Results and Lower Maintenance now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.