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.