Magazine article from our research archive:

Discover the Benefits of FILTERED INDEXES & STATISTICS

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 ...

Related newspaper, magazine, and journal articles:

See all results. Or, try our Advanced Search.

Newsweek Harper's Magazine The Washington Post Chicago Tribune Crain's Chicago Business PRNewswire Pediatric News The Nation Advertising Age The Economist (US) A FREE trial gives you access to over 60 million articles! Access over 3,500 publications with a FREE trial!