You have a table named Rooms that contains three columns. You run the following Transact-SQL statement: You discover th
Posted: Mon Oct 17, 2022 4:49 pm
You have a table named Rooms that contains three columns.
You run the following Transact-SQL statement:
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.
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.
You run the following Transact-SQL statement:
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.
- You Have A Tabl 1 (26.58 KiB) Viewed 83 times
- You Have A Tabl 2 (29.83 KiB) Viewed 83 times
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.