Microsoft
70-451 · Question #102
You review the execution plan for a query that contains a join. The execution plan contains a RID Lookup. You need to reduce the I/O that is generated by the RID Lookup. Which index should you create?
The correct answer is B. clustered. See the full explanation below for the reasoning.
Question
You review the execution plan for a query that contains a join. The execution plan contains a RID Lookup. You need to reduce the I/O that is generated by the RID Lookup. Which index should you create?
Options
- Aunique nonclustered
- Bclustered
- Cnonunique covering
- DFull-Text-Search
How the community answered
(50 responses)- A4% (2)
- B74% (37)
- C14% (7)
- D8% (4)
Community Discussion
No community discussion yet for this question.