You created a SQL Tuning Set (STS) containing resource-intensive SQL statements. You plan to run the SQL Tuning Advisor. Which two types of recommendations can be provided by the SQL Tuning Advisor?

Question

Options

• ASemantic restructuring for each SQL statement
• BGathering missing or stale statistics at the schema level for the entire workload
• CCreating a materialized view to benefit from query rewrite for the entire workload
• DGathering missing or stale statistics for objects used by the statements.
• ECreating a partition table to benefit from partition pruning for each statement

• A
  78% (18)
• B
  4% (1)
• C
  13% (3)
• E
  4% (1)

Explanation

The output of the SQL Tuning Advisor is in the form of an advice or recommendations, along with a rationale for each recommendation and its expected benefit. The recommendation relates to collection of statistics on objects ( D), creation of new indexes, restructuring of the SQL statement (A), or creation of a SQL profile. You can choose to accept the recommendation to complete the tuning of the SQL statements. * A SQL Tuning Set can be used as input to the SQL Tuning Advisor, which performs automatic tuning of the SQL statements based on other input parameters specified by the user. * A SQL Tuning Set (STS) is a database object that includes one or more SQL statements along with their execution statistics and execution context, and could include a user priority ranking. The SQL statements can be loaded into a SQL Tuning Set from different SQL sources, such as the Automatic Workload Repository, the cursor cache, or custom SQL provided by the user.

No community discussion yet for this question.