Applying It |
Independent Exercise 1:
- Install the explain plan table.
- Start SQL*Plus and run the query in Listing 14.4.
- Examine the output.
Independent Exercise 2:
- Add a hint to use the rule-based optimizer.
- Re-run the query in Listing 14.4 and compare the results with those from Exercise 1.
Independent Exercise 3:
- Alter the query in Listing 14.4 to invalid the use of an index.
- For both the cost-based optimizer (use a hint) and the rule-based optimizer (add 0 to a numeric field).
- Re-run the query using the explain table and check the result table.
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.