Databases Reference
In-Depth Information
9.
Inspect statistics on the index:
SELECT HEIGHT, BLOCKS, BTREE_SPACE, USED_SPACE,
OPT_CMPR_COUNT, OPT_CMPR_PCTSAVE FROM INDEX_STATS
WHERE NAME = ‹IX1_BIG_CUSTOMERS›;
10. Drop the table and the index:
DROP TABLE BIG_CUSTOMERS;
How it works...
We have created a table with more than five million records and an index on it, based on the
fields
CUST_LAST_NAME
and
CUST_FIRST_NAME
(which is not unique).
After creating the index, we have analyzed it to gather statistical information, using the data
dictionary view
INDEX_STATS
.
We have seen the space occupied by the index expressed in database blocks (
BLOCKS
field)
and in bytes (
BTREE_SPACE
and
USED_SPACE
).