
SELECT INDEX_NAME , INDEX_TYPE, BLEVEL , NUM_ROWS,BLEVEL + 1 HEIGHT FROM USER_INDEXES
WHERE TABLE_NAME = 'CUSTOMERS' and INDEX_NAME = 'CUSTOMERS_PK';

ANALYZE INDEX CUSTOMERS_PK VALIDATE STRUCTURE;

SELECT NAME , HEIGHT , BR_BLKS , LF_BLKS FROM INDEX_STATS;

-- OPEN SQLPLUS
SET AUTOTRACE ON;

SELECT COUNT(1) FROM CUSTOMERS WHERE CUST_ID = '49671';

SELECT COUNT(1) FROM CUSTOMERS WHERE CUST_ID = '3228';

SELECT * FROM CUSTOMERS WHERE CUST_ID = '3228';