为自己加油

Choose the best answer. Which statement correctly describes the SQL

Profiling performed by the SQL Tuning Advisor?

A.
It is a set of recommendations by the optimizer to change the access methods
Used.
B.
It is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation error.
C.
It is a set of recommendations by the optimizer to restructure a SQL statement to avoid suboptimal execution plans.
D.
It is auxiliary information collected by the optimizer for a SQL statement to
Help use better joins orders.
E.It is a set of recommendations by the optimizer to create new indexes.