In This Assignment You Will Be Using An Execution Plan To Analyze The Efficient Use 2379425
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:
SET LONG 5000
SET AUTOTRACE TRACE EXPLAIN
Then modify the script to use cust_first_name in the customers table for the OE database:
WHERE UPPER(first_name) = ‘IAN’;
Create a new function-based index for UPPER(cust_first_name) and run the select command again.