Terms to Know

• bitmap index

• branch blocks

• b-tree index

• buffer cache advisory

• cardinality

• cost-based optimizer

• Explain Plan tool

• function-based index

• hint

• index-organized table (IOT)

• leaf blocks

• materialized view

• Oracle’s Tuning Methodology

• partitioned table

• PFILE

• reverse key index

• ROWID

• rule-based optimizer

• SPFILE

• statistics

• Top SQL tool

• unique index