Databases Reference
In-Depth Information
5.
Execute the TEST CASE.
6.
In the following screenshot, we can see the relevant part of the TEST CASE results
after the index
IX1_CUSTOMERS
is in place:
7.
Create the index
IX2_CUSTOMERS
:
CREATE INDEX IX2_CUSTOMERS ON
CUSTOMERS (UPPER(CUST_LAST_NAME), UPPER(CUST_FIRST_NAME));
8.
Execute the TEST CASE.