Interview Questions
1. What is Filtered index?
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, reduce
index maintenance costs, and reduce index storage costs compared with full-table indexes.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment