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.
|
Copyright © 2013 CA.
All rights reserved.
|
|