Oracle Database 12c R2: SQL Tuning for Developers Ed 2 Quiz Questions and Answers
Answer :
- Use cursors so that SQL statements are parsed once and executed multiple times.
Explanation :
NULL
Answer :
- A query transformation has taken place.
- The optimizer considered a nested loops join when table p and view v1 are joined even with the GROUP BY clause in the view.
- A join predicate pushdown has become possible, and you are now taking advantage of the index on the SALES table to do a nested loops join instead of a hash join.
Explanation :
NULL
Answer :
- You cannot create your own PLAN_TABLE.
Explanation :
NULL
Answer :
- Limit the number of indexes for each table
Explanation :
NULL