New Performance Features
SQL Server 2008 also introduces some new features and enhancements for monitoring, managing, and improving query performance. Among these new features are filtered indexes and statistics. A filtered index is a nonclustered index defined on a subset of data using a filter predicate to index only a portion of rows in the table. Filtered statistics are statistics defined on a subset of data in the table using a filter predicate. A well-designed filtered index can improve query performance, reduce index maintenance costs, and reduce index storage costs compared with full-table indexes, especially when columns contain a large number of rows with null or a single value that isn’t searched on but can skew the index and statistics. ...
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.
