Question: Question 2 : Use the same Inventory Database described above ( in Question 1 ) and answer the following questions: After executing the following SQL
Question : Use the same Inventory Database described above in Question and answer the
following questions:
After executing the following SQL statement using SQL Server 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 custname, city, grade FROM Customers WHERE city'London'
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
