题目内容

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.

查看答案
更多问题

著有《爬山虎的脚》、也是第一位开拓“童话园地”的作家是()?

国家电网公司智能电网标准体系的第二层是()。

A. 1个体系
B. 8个专业分支
C. 26个技术领域
D. 92个标准/系列标准

对中暑较重或呕吐者,还要提供(),以防脱水虚脱,并及时的送医务部门治疗。

A. 热开水
B. 淡盐水
C. 蒸馏水
D. 冷开水

答案查题题库