多做题,通过考试没问题!

微软认证考试

睦霖题库>其他计算机考试>微软认证考试

Your company 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
正确答案:C,D
答案解析:
进入题库查看解析

微信扫一扫手机做题