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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!