Question 730
An expensive point lookup on CustomerId scans millions of activity rows because no useful index exists. Which implementation step most directly addresses this requirement?
Explanation
Correct Answer
A selective index on frequently filtered columns can reduce logical reads. Add a measured index aligned with the predicate and projected columns. The plan seeks efficiently and meets query latency targets.
Incorrect Answers
A useful index must align with the real lookup predicate; verify seek behavior and measured logical reads.
Index benefits must be benchmarked against realistic cardinality and read/write workload tradeoffs.
Projected columns and access paths affect lookup work; benchmark covering choices without excessive width. The appropriate case-specific action is: Add a measured index aligned with the predicate and projected columns.