Question
When is a filtered index most useful?
Select an option. Your answer will be checked instantly.
Correct Answer: B. When queries repeatedly target a small, well-defined subset of rows
Explanation:
A filtered index stores only rows matching a condition such as Active = 1.
It can be smaller and cheaper to maintain than a full-table index.
Leave a Reply