Oracle High Performance Tuning for 9i and 10g

B

Bitmap indexes, 210–19

composite indexes, 213–15

defined, 210

faster than BTree indexes, 211–13

and overflow, 217–19

BTree indexes, 206–9, 220–36

compressed,

composite indexes, 224–28

indexes and DML activity, 228–30

function-based indexes, 230–33

lost index space, 222–23

NULLS and indexes, 233–35

in Oracle database, 207

overflow and rebuilding, 221–22

reverse key indexes, 223–24

summary of indexing, 235–36