39.View the Exhibit to examine the Automatic SQL Tuning result details. Which action would you suggest
for the selected SQL statement in the Exhibit?
![](https://img.laitimes.com/img/__Qf2AjLwojIjJCLyojI0JCLiQ3chVEa0V3bT9CX5RXa2Fmcn9CXwczLcVmds92czlGZvwVP9EUTDZ0aRJkSwk0LcxGbpZ2LcBDM08CXlpXazRnbvZ2LcRlMMVDT2EWNvwFdu9mZvwVPFdFZvhXbjZXUYpVd1kmYr50MZV3YyI2cKJDT29GRjBjUIF2LcRHelR3LcJzLctmch1mclRXY39jN5IzNwYTMxETOyATMzEDMy8CX0Vmbu4GZzNmLn9Gbi1yZtl2Lc9CX6MHc0RHaiojIsJye.jpg)
A. Accept the recommended SQL profile.
B. Collect statistics for the related objects.
C. Run the Access Advisor for the SQL statement.
D. Run the Segment Advisor for recommendations.
Answer: C
答案解析:
參考:http://blog.csdn.net/rlhua/article/details/13021985
SQL 優化指導會分别考察指導任務中包括的每個 SQL 語句。建立一個新索引可能會對查詢有幫助,但也可能增加DML 的響應時間。是以,應使用 SQL 通路指導檢查建議的索引或其它對象對工作量(一組 SQL 語句)的影響,以确定性能是否有淨提高。