Index Manager

Index Manager manages the database index and provides a fast way to look up Essbase data blocks. Index Manager determines which portions of the database index to cache in the index cache, and manages the index cache.

Table 150 lists the components that Index Manager controls:

Table 150. Index Manager Components

Component

Description

Index

The method that Essbase uses to locate and retrieve data. The term index also refers to the index file.

Index file

File that Essbase uses to store data retrieval information. It resides on disk and contains index pages. Essbase names index files incrementally on each disk volume, using the naming convention essxxxxx.ind, where xxxxx is a number. The first index file on each disk volume is named ess00001.ind.

Index page

A subdivision of an index file that contains index entries that point to data blocks.

Index entry

A pointer to a data block. An index entry exists for every intersection of sparse dimensions.

Index cache

A buffer in memory that holds index pages.

The term index refers to all index files for a single database. The index can span multiple volumes, and multiple index files can reside on a single volume. Use the disk volumes setting to specify disk spanning parameters. For information on setting the index cache size, see Sizing the Index Cache. For information about allocating storage space with the disk volumes setting, see Specifying Disk Volumes.