Question: Question 2 : Use the same Inventory Database described above ( in Question 1 ) and answer the following questions: After executing the following SQL

Question 2: Use the same Inventory Database described above (in Question 1) and answer the
following questions:
After executing the following SQL statement using SQL Server 2019, the following execution
plan is displayed. In this plan, the Select statement is executed with a Clustered Index Scan.
Briefly describe the process executed by the index scan and suggest how to improve the query
execution efficiency.
SELECT cust_name, city, grade FROM Customers WHERE city='London'
 Question 2: Use the same Inventory Database described above (in Question

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!