Select from following answers:- Filtered indexes increase index maintenance because of their complexity
- Filtered indexes are smaller than full-table indexes
- Filtered indexes provide improved query performance over full-table indexes
- You cannot create a filtered index on a view
- All Above
A filtered index is an optimized non-clustered index especially suited to cover queries that select from a well-defined subset of data. Filtered indexes does NOT increase index maintenance
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator