When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this? ()(Choose two.) A. It produces less accurate results of the comparison analysis.B. It automatically calls the SQL Tuning Advisor for recommendations.C. It shortens the time of execution and reduces the impact on system resources.D. Only the changes in the execution plan, and not performance regression, are detected.
When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this? ()(Choose two.)
A. It produces less accurate results of the comparison analysis.
B. It automatically calls the SQL Tuning Advisor for recommendations.
C. It shortens the time of execution and reduces the impact on system resources.
D. Only the changes in the execution plan, and not performance regression, are detected.
相关考题：
A general _______ is held in the United States every four years. A、selectionB、choiceC、electionD、choose
WhichofthefollowingareassociatedwiththeapplicationlayeroftheOSImodel?(two.)() A.pingB.TelnetC.FTPD.TCPE.IP
The underlined word“penalty”is closest in meaning to__________．A.punishmentB.trialC.accusationD.execution
为choose表添加外键约束，约束名为choose_student_fk，外键为student_no，参照 student表的st_no字段，以下SQL语句片段正确的是（）。A．constraint choose_student_fk FOREIGN KEY (student_no);B．constraint choose_student_fk FOREIGN KEY (student_no) REFERENCES student(st_no);C．constraint choose_student_fk FOREIGN KEY (st_no) REFERENCES student(student_no);D．constraint choose_student_fk REFERENCES student(st_no);
【单选题】以下有关MyBatis动态SQL中的主要元素说法错误的是。A．＜if＞用于单条件分支判断。B．＜choose＞（＜when＞、＜otherwise＞）用于多条件分支判断。C．＜foreach＞循环语句，常用于in语句等列举条件中D．＜bind＞从OGNL表达式中创建一个变量，并将其绑定到上下文，只于模糊查询的sql中
【单选题】当有多个选择的情况是，值需要从多个选项中选择一个去执行时，可以使用的动态SQL元素是。A．＜if＞B．＜choose＞、＜when＞、＜otherwise＞C．＜when＞D．＜set＞
以下哪个标签实现了switch功能（）。A．＜c:if＞B．＜c:switch＞C．＜c:choose＞与＜c:when＞D．＜c:case＞