Previous Topic: Step 3: Calculating the Number of Pages in the AreaNext Topic: Index Structure


Allocating Space for Indexes

When a database area contains an index, you must provide space in the area for storage of the index. To determine the amount of space needed, you perform some simple calculations. Before you allocate space for an index, you need to consider both the volume of data entities to be indexed and the type of internal structures that CA IDMS/DB will generate to allow access to these entities.

Following a discussion of the structure of an index, procedures for calculating the size of an index are presented below.