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?

A.
unique nonclustered

B.
clustered

C.
nonunique covering

D.
Full-Text-Search

Explanation: