Which three functions can be performed by the SQL Tuning Advisor? (Choose three.)
Which three functions can be performed by the SQL Tuning Advisor? (Choose three.)
The SQL Tuning Advisor helps in improving the performance of SQL statements. Specifically, it can recommend the creation of indexes based on the SQL workload (A), suggest restructuring of SQL statements that have suboptimal plans (B), and generate SQL profiles (E) to optimize execution plans. Checking schema objects for missing and state statistics (C) is not typically a function of SQL Tuning Advisor, as this is generally handled by statistics gathering mechanisms. Recommending optimization of materialized views (D) is not a core function of the SQL Tuning Advisor.
Use SQL Tuning Advisor to obtain recommendations for improving performance of high-load SQL statements, and prevent regressions by only executing optimal plans. SQL Tuning Advisor is SQL diagnostic software in the Oracle Database Tuning Pack. You can submit one or more SQL statements as input to the advisor and receive advice or recommendations for how to tune the statements, along with a rationale and expected benefit. Tuning recommendations include: -Collection of object statistics -Creation of indexes -Rewriting SQL statements -Creation of SQL profiles -Creation of SQL plan baselines
i think a is not correct
a is not correct this for sql access , c is correct Statistics Analysis: Checks each query object for missing or stale statistics, and makes recommendations to gather relevant statistics.