Question
You have a table containing employee information that your users query frequently. They spe- cifically use this query most often: SELECT FirstName, LastName, Address, Phone
SELECT FirstName, LastName, Address, Phone
FROM Employees WHERE SSN = ssn
You have a clustered index on this table on the SSN column, but your users are complaining that the query is still too slow. What can you do to speed it up?
A. Modify the index to include the FirstName, LastName, Address, and Phone columns as nonkey columns.
B. Create a new nonclustered index on the FirstName, LastName, Address, and Phone columns.
C. Create a new clustered index on the FirstName, LastName, Address, and Phone columns.
D. You cant do anything to speed up this query.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started