You have a table named Rooms that contains three columns.
You execute the following query:
You discover the execution plan shown in the exhibit. (Click the Exhibit button.)
You need to recommend a solution to reduce the amount of time it takes to execute the query.
What should you do?
More than one answer choice may achieve the goal. Select the BEST answer.
![PrepAway - Latest Free Exam Questions & Answers](https://www.briefmenow.org/img/pa5.jpg)
A.
Include the RoomName column and the Position column in the Room_IX index.
B.
Create a nonclustered index for RoomName, Id, and Position.
C.
Create a clustered index for Id.
D.
Use the WITH (INDEX(Room_IX),NOLOCK) query hint.
Correct
1
0