Optimizing Storage Structures - Oracle Database 11gR2 Performance Tuning - page 110

9. In the following screenshot, we can see the relevant part of the TEST CASE results

after the index IX2_CUSTOMERS is in place:

10. Create the index IX3_CUSTOMERS :
CREATE INDEX IX3_CUSTOMERS ON
CUSTOMERS (CUST_LAST_NAME, CUST_YEAR_OF_BIRTH DESC);

11. Execute the following query to test the index just created:
SELECT CUST_LAST_NAME, CUST_YEAR_OF_BIRTH FROM CUSTOMERS
WHERE CUST_LAST_NAME = ‹Wade›
ORDER BY CUST_LAST_NAME, CUST_YEAR_OF_BIRTH DESC;