Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031)

Changing Storage Parameters for Indexes

Parameters that can be modified deal with block utilization. These parameters can be changed with the ALTER INDEX command and include the INITRANS, MAXTRANS, and MAXEXTENTS parameters. These parameters are often altered to allow a higher level of concurrency on any given index block.

Furthermore, much the same as you can manually add an extent to a table, you can manually add extents to indexes.

The following example alters the storage parameters associated with the address_last_name_idx index:

					ALTER INDEX
					addresses_last_name_idx
					ALLOCATE EXTENT (SIZE 250K DATAFILE
					'd:\mydatabases
\mydb1\addresses_idx.dbf') ...