问题:
You work with a database named DB1, which is located on a SQL Server 2005 computer. You discover that a table scan on Table1 in DB1 causes a slow query. Table1 is a very large table that is used frequently. You ascertain that the query contains the following statement. SELECT col1, col2 FROM table1 WHERE col3 =
What should you do?()
A . Update all statistics on Table1 in DB1.
B . Use the CREATE STATISTICS statement in DB1 to create missing statistics on col3of Table1.
C . Set the priority boost server option to 1.
D . Execute the following statement.USE DB1GOCREATE INDEX index1 ON table1(col3)INCLUDE(col1, col2) WITH (ONLINE = ON)GO
You work with a database named DB1, which is located on a SQL Server 2005 computer. You discover that a table scan on Table1 in DB1 causes a slow query. Table1 is a very large table that is used frequently. You ascertain that the query contains the following statement. SELECT col1, col2 FROM table1 WHERE col3 =
What should you do?()
● 参考解析
本题暂无解析
相关内容
相关标签