Which is the correct description of SQL profiling while using SQL Tuning Advisor?

Which is the correct description of SQL profiling while using SQL Tuning Advisor?

Which is the correct description of SQL profiling while using SQL Tuning Advisor?

A.
It is a set of recommendations by the optimizer to create new indexes.

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 refresh stale statistics to avoid bad execution
plan.

D.
It is a set of recommendations by the optimizer to restructure a SQL statement to avoid bad
execution plan.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


L. Zhu

L. Zhu

SQL profile is additional info (auxiliary info) collected by optimizer to eliminate estimation error

So B is correct