O'Reilly logo

Microsoft SQL Server 2012 Performance Tuning Cookbook by Bihag Thaker, Ritesh Shah

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

Effect of statistics on a filtered index

The filtered column index is one of the enhancements for non-clustered indexes, provided in Microsoft SQL Server 2008, and it is available in SQL Server 2012. We can consider a simple, non-clustered index with the WHERE clause as a filtered index. A well-defined, filtered index reduces maintenance costs, reduces index storage, and improves query performance. Since this chapter is about statistics, we are not going to see how a filtered index works, in this recipe. Look at the Increasing performance by filtered index recipe in Chapter 9, Implementing Indexes, to learn more about filtered indexes.

Getting ready

There is a table named WorkOrder in the Production schema in database AdventureWorks2012, and this ...

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