Home » Oracle » 1z0-117 » Which two types of recommendations can be provided by the SQL Tuning Advisor?
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?
A. Semantic restructuring for each SQL statement
B. Gathering missing or stale statistics at the schema level for the entire workload
C. Creating a materialized view to benefit from query rewrite for the entire workload
D. Gathering missing or stale statistics for objects used by the statements.
E. Creating a partition table to benefit from partition pruning for each statement
Correct Answer: AD
Explanation/Reference:
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.
Note:
*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.
Reference: OracleDatabase Performance Tuning Guide11g,SQL Tuning Advisor
|
Download Printable PDF. VALID exam to help you PASS.
|
 |
