A filtered index is an optimized non-clustered index

Options
- False
- True

CORRECT ANSWER : True

Discussion Board
Filtered Index

The above statement is true. A filtered index is an optimized non-clustered 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 as well as reduce index maintenance and storage costs compared with full-table indexes.

Prajakta Pandit 03-7-2017 11:21 PM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲