O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

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

Designing a filtered indexes and statistics feature

Scalability and performance are the common buzzwords whenever we are dealing with large data sets, and to help further, indexes and statistics play an important role in query performance. A Database Administrator or Developer needs a good understanding of the indexing methods, which can result in efficient practices to return the required subset of data based upon the index key columns and their values.

Inside the database, the data is inserted, deleted, and updated frequently; to return subsequent results efficiently, indexes are helpful. However, NULL values are present in the data, and if it is likely that null values are stored in the data on a larger scale, the indexes will need efficient ...

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