In this assignment, you will be using an execution plan to analyze the efficient use of a function based index. This is loosely based on the SELECT statement shown in script 2_8 on page 76. You can start with the script attached above (2_8.sql).
First, start your spool file, and SET the following properties:
Spool c:cs4650m2wa.log
SET LONG 5000
SET AUTOTRACE TRACE EXPLAIN
Then modify the script to use cust_first_name in the customers table for the OE database:
SELECT first_name
FROM cust
WHERE UPPER(first_name) = ‘IAN’;
Create a new function-based index for UPPER(cust_first_name) and run the select command again.
Attachments:
2-8.sql