题目内容

TestKing.com uses SQL Server 2005. Users report that report execution is slow. You investigate and discover that some queries do not use optimal execution plans. You also notice that some optimizer statistics are missing and others are out of date. You need to correct the problem so that reports execute more quickly. Which two Transact-SQL statements should you use?()

A. DBCC CHECKTABLE
B. ALTER INDEX REORGANIZE
C. UPDATE STATISTICS
D. CREATE STATISTICS
E. DBCC SHOW STATISTICS
F. DBCC UPDATEUSAGE

查看答案
更多问题

外币欧元定期储蓄开户的起存金额为()

A. 10元
B. 50元
C. 100元
D. 500元

DXC4/4设备仅在()级上进行交叉连接。

A. VC-12
B. VC-2
C. VC-3
D. VC-4

锅炉的给水,调节阀作用方式应选用()。

A. 气开式调节阀
B. 气关式调节阀

邻近或交叉220kV带电电力线作业的安全距离为()m。

A. 3
B. 4
C. 5
D. 6

答案查题题库