Answers to Chapter 14
Reviewing It |
1: | What is an explain plan? |
A1: | The explain plan illustrates the execution plan for any SQL statement. It shows the tables and indexes Oracle will use when processing a SQL statement, as well as the order in which the tables and indexes will be used |
2: | What is the main difference between the cost-based optimizer and the rule-based optimizer? |
A2: | The Cost-based optimizer makes its decisions based on pre-collected statistics where the rule-based uses a set of 19 rules |
3: | What is a driving table? |
A3: | The driving table is the table that is accessed first and then used to look up information in the other tables in the ... |
Get Oracle9i™ Development by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.