1Z0-117 · Question #109
You are administering a database supporting an OLTP workload. A new module was added to one of the applications recently in which you notice that the SQL statements are highly resource intensive in…
The correct answer is C. Syntactic and semantic restructuring of SQL statements F. Creating composite indexes for the workload. 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 , creation of new indexes (F), restructuring of the…
Question
You are administering a database supporting an OLTP workload. A new module was added to one of the applications recently in which you notice that the SQL statements are highly resource intensive in terms of CPU, I/O and temporary space. You created a SQL Tuning Set (STS) containing all resource-intensive SQL statements. You want to analyze the entire workload captured in the STS. You plan to run the STS through the SQL Advisor. Which two recommendations can you get?
Options
- ACombing similar indexes into a single index
- BImplementing SQL profiles for the statements
- CSyntactic and semantic restructuring of SQL statements
- DDropping unused or invalid index.
- ECreating invisible indexes for the workload
- FCreating composite indexes for the workload
How the community answered
(23 responses)- A13% (3)
- B4% (1)
- C70% (16)
- D9% (2)
- E4% (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 , creation of new indexes (F), restructuring of the SQL statement (C), or creation of a SQL profile. You can choose to accept the recommendation to complete the tuning of the SQL statements.
Topics
Community Discussion
No community discussion yet for this question.