 | Reviewing It |
| 1: | What is an explain plan? |
| 2: | What is the main difference between the cost-based optimizer and the rule-based optimizer? |
| 3: | What is a driving table? |
| 4: | What might a histogram be useful for? What SQL syntax does Oracle require to use a histogram? |
| 5: | What are the three kinds of join conditions? |
| 6: | Is a full-table scan necessarily always bad? |
| 7: | What is clustering factor? |
| 8: | Describe a good use for a Stored Outline. |
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.
