15.1. Noteworthy Index-Related Features in SQL Server
This section first highlights the index-related features new in SQL Server 2008, and then reviews the many indexing features that were first added in SQL Server 2005 and continue to shine in SQL Server 2008.
15.1.1. What's New for Indexes in SQL Server 2008
SQL Server 2008 offers several new index-related features:
Filtered indexes and statistics: In SQL Server 2008, you can use a predicate to create filtered indexes and statistics on a subset of rows in the table. Prior to SQL Server 2008, indexes and statistics were created on all of the rows in the table. Now you have a WHERE predicate in the index or statistics you create to limit the number of rows when you create a index or stats. Filtered indexes and statistics are especially suitable for queries that select from well-defined subsets of data; columns with heterogeneous categories of values; and columns with distinct ranges of values.
Compressed storage of tables and indexes: SQL Server 2008 supports on-disk storage compression in both row and page format for tables, indexes, and indexed views. Compression of partitioned tables and indexes can be configured independently for each partition. Chapter 12 covers this topic in detail.
Spatial indexes: SQL Server 2008 introduces support for spatial data and spatial indexes. Spatial data in this context represents geometric objects or physical location. SQL Server supports two spatial data types: geography and geometry. A spatial ...
With Safari, you learn the way you learn best. Get unlimited access to videos, live online training,
learning paths, books, interactive tutorials, and more.