You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005.You work as a database administrator for your company. You find a problem that when the following query is executed, a SQL Server 2005 application will perform slowly. SELECT * FROM Orders WHERE OrderStatus = ’InProgress’ This query is executed by the application as an ad hoc query. In most occasions, this query performs much more quickly. The company has the OrderStatus column indexed. The value InProgress is included by only a small number of the rows. Nevertheless, the OrderStatus column index which is the most ideal for this query is not being utilized. The performance of this query should be enhanced. However, the application that executes the query should not be changed. In addition, the effect on end users should be cut to the least. Which action should be performed to finish the task?()
- A、To finish the task, the index should be built by utilizing a FILLFACTOR of 10 percent.
- B、To finish the task, the index should be recreated to have all of the columns in the table included.
- C、To finish the task, an indexed view of the Orders table should be viewed.
- D、To finish the task, the statistics should be updated on the index.
微信扫一扫手机做题