You are the administrator of a SQL Server 2000 computer. The server contains a database na
The database contains more than 1 million rows. Users report that the database responds slowly when they search for customers by using the application. Users search for customers by scrolling through an alphabetical list of customer names.
You use SQL profiles to capture information about how the application uses the database.
You receive results as shown in the following screen shot.
You need to improve the application’s performance. What should you do?
A.Create additional nonclustered indexes on the CustomerInformation table.
B.Rewrite the application so that it uses a user-defined function to return the customer list.
C.Rewrite the application so that it uses a query with a WHERE clause to search for customer names.
D.Rewrite the application so that is uses a stored procedure to return the customer list.