Question: 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
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. First, start your spool file, and SET the following properties: Spool c:\o12c\s2wa.log SET LONG 5000 SET AUTOTRACE TRACE EXPLAIN Then modify this script (also attached above) 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. When finished, submit your log file to the folder inside this assignment.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
