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.
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!