053-406

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

　　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 优化指导：分析各个 SQL 语句, 并建议 SQL 概要文件, 统计信息, 索引和重构的 SQL 以改善 SQL性能