Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
A filtered index is an optimized nonclustered index, especially suited to cover queries that select
from a well-defined subset of data. It uses a filter predicate to index a portion of rows in the table.
A well-designed filtered index can improve query performance, reduce index maintenance costs,
and reduce index storage costs compared with full-table indexes.
Filtered indexes can provide the following advantages over full-table indexes:
Improved query performance and plan quality
Reduced index maintenance costs
Reduced index storage costs
No comments:
Post a Comment