Q51. 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 help use better joins orders.
- C. It is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation error.
- D. It is a set of recommendations by the optimizer to restructure a SQL statement to avoid suboptimal execution plans.
- E. It is a set of recommendations by the optimizer to create new indexes.
Answer: C