QUESTION NO: 307
Which of these appropriately describes the results of a manual SQL Tuning Advisor task?
A. A list of SQL statements and recommendations for tuning
B. A list of SQL statements that have been tuned by the Advisor, with before and after metrics
C. Graphs showing the actual performance improvement made by the Advisor after it implemented the
recommended changes
D. All of the above
Answer: A
Option B is incorrect because the manual SQL Tuning Advisor task does not tune the SQL statements. C
is incorrect for the same reason.
哪些恰当地描述一个手动SQL调整顾问任务的结果?
A.一个用于调优的SQL语句和建议列表
B.已经由顾问调整的SQL语句的顾问列表,带有前后的度量。
C.顾问做出的图表显示实际的性能改善,在该顾问实施所建议的改变之后。
D.所有
Answer: A
选项B是不正确的,因为手动的SQL Tuning Advisor任务不调整SQL语
句。出于同样的原因C是不正确的。