O'Reilly logo

SQL Server MVP Deep Dives by Greg Low, Paul Randal, Kimberly Tripp, Adam Machanic, Kalen Delaney, Paul Nielsen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 40. When is an unused index not an unused index?

Rob Farley

Indexes can help you access your data quickly and effectively, but index overhead can sometimes be costly. Keeping an index updated when data is changing is one cost, but there is also the cost of extra storage space and the increased size of backups. So if an index isn’t being used, you should remove it, right?

In this chapter, I’ll show you ways to find out if an index is used. Then I’ll show you a type of index that may appear to be unused even although it really is used. Hopefully this won’t leave you too disheartened about the idea of researching your indexes but instead convince you of the power of SQL Server.

Overview of indexing

My favorite analogy for indexes is ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required