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

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"