Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?

Question

Options

• AIt is a set of recommendations by the optimizer to create new indexes.
• BIt is a set of recommendations by the optimizer to restructure a SQL statement to avoid
• CIt is auxiliary information collected by the optimizer for a SQL statement to help use better joins
• DIt is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation
• EIt is a set of recommendations by the optimizer to change the access methods used.

• A
  10% (5)
• B
  82% (40)
• C
  4% (2)
• D
  2% (1)
• E
  2% (1)

Explanation

SQL Tuning Advisor is a mechanism for resolving problems related to suboptimally performing https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/sql-tuning- advisor.html#GUID-8E1A39CB-A491-4254-8B31-9B1DF7B52AA1

No community discussion yet for this question.