CHAPTER 9
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 ...
Get SQL Server Query Performance Tuning,Fourth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
