|
|
Discover the Benefits of FILTERED INDEXES & STATISTICS
- Article from:
-
SQL Server Magazine
- Article date:
-
September 1, 2008
- Author:
-
|
Copyright informationCopyright Penton Media, Inc. Sep 2008. Provided by ProQuest LLC. (Hide copyright information)
|
Enhance your queries and obtain more useful data
(ProQuest: ... denotes formulae omitted.)
SQL Server 2008 introduces a very cool new feature-filtered indexes and statistics. This new feature lets you improve the performance of your queries without wasting disk space; offers more detailed and more accurate distribution statistics, which provide better selectivity estimates from the optimizer; and provides an alternative to the commonly requested unique constraint with multiple NULLs. I'll use several examples to introduce you to the concept of filtered indexes and statistics and to demonstrate their use.
Filtered Indexes and Statistics
In SQL Server 2008, you can define nonclustered indexes ...