Physical Modeling › New r8 SQL Server 2008 Support in CA ERwin Data Modeler › Filtered Indexes

Previous Topic: Version Compatibility

Next Topic: Sparse Columns

Filtered Indexes

A filtered index is an optimized non-clustered index that is best used by queries that run against a well-defined subset of data in a table. It uses a WHERE clause to index a portion of rows in a table. This means that the index contains only the rows referenced by the queries. Filtered indexes improve query performance while reducing maintenance and storage.