What’s New for Data Structures, Indexes, and Performance
SQL Server 2008 provides a number of new features related to data structures, indexes, and performance.
Among these new features are filtered indexes and statistics. Filtered indexes utilize a WHERE clause that filters or limits the number of rows included in the index. The smaller filtered index allows queries run against rows containing data values in the index to run faster. These filtered indexes can also save on the disk space used by the index. A well-designed filtered index can improve query performance, reduce index maintenance costs, and reduce index storage costs compared with full-table indexes.
Also new to SQL Server 2008 is the capability to compress data in indexes and tables ...
Get Microsoft® SQL Server 2008 R2 Unleashed 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.
