O'Reilly logo

SQL Server Query Performance Tuning,Fourth Edition by Grant Fritchey

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 9

image

Index Analysis

In the previous chapter I introduced the concepts surrounding indexes. This chapter takes that information and adds more functionality. There’s a lot of interesting interaction between indexes that you can take advantage of. There are also a number of settings that affect the behavior of indexes that I didn’t address in the preceding chapter. I’ll show you methods to squeeze even more performance out of your system.

In this chapter, I cover the following topics:

  • Advanced indexing techniques
  • Special index types
  • Additional characteristics of indexes

Advanced Indexing Techniques

Here are a few of the more advanced indexing ...

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