問題文
Only about two percent of the credit application rows have a non-null manual_review_note value, and the review queue query always reads exactly those rows. A full-table nonclustered index on the note column is being maintained today. Which statement best justifies replacing it with a filtered index?
選択肢
- The filter predicate can use LIKE, so the note text itself can be narrowed inside the index definition.
- A filtered index can be defined on a view, so the review queue view can be indexed without changing the base table.
- It indexes only the rows that satisfy its filter predicate, so it is smaller, has filtered statistics, and is maintained only when the rows in the index change.
- The query does not need to match the filter, because the optimizer rewrites any predicate to use the smaller index.