Chapter 5

image

Index Myths and Best Practices

In the past few chapters, we’ve defined indexes and looked at how they are structured. In the upcoming chapters, we’ll be looking at strategies to build indexes and ensure that they behave as expected. In this chapter we’ll be dispelling some common myths and building the foundation for how to create 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 indexing myths discussed in this chapter include:
  •  Databases don’t need indexes.
  •  Primary keys are always ...

Get Expert Performance Indexing for SQL Server 2012 now with O’Reilly online learning.

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