题目内容

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

查看答案
更多问题

下列不属于研究性教学的基本模式的是()。

A. 问题解决模式
B. 自主研究模式
C. 探究模式
D. 课题参与模式

没有写过《忏悔录》的作家是哪一位?()

A. 卢梭
B. 托尔斯泰
C. 奥古斯丁
D. 孟德斯鸠

复吹转炉炼钢热的来源是指元素氧化放出的热。

A. 正确
B. 错误

答案查题题库