You have an execution plan as shown in the exhibit. (Click the Exhibit button.) The indexes
and keys for the table are as follows: • Unique index on Col1 and CoI2 • Primary key of
table not modifiable • Clustered primary key on Col1 and Col2 You need to recommend
changes to the table to minimize the response time for both queries. What should you do?

A.
change the order of the columns in the existing nonclustered index.

B.
Add a unique nonclustered index to Col1 and Col2.

C.
Include all the columns of the table in the existing nonclustered index.

D.
Remove the nonclustered index.