INDEXCACHESIZE

Defines the value for the index cache size for Essbase databases. The index cache is a buffer in memory that holds index pages. Essbase allocates this memory at startup of the database.

The value of the index cache size can be expressed in bytes, kilobytes, megabytes, or gigabytes. Terabytes must be expressed in gigabytes.

This setting does not apply to aggregate storage databases.

Syntax

INDEXCACHESIZE n

n—An integer value expressed in bytes (B), kilobytes (K), megabytes (M), or gigabytes (G):

• Minimum value: 1 megabytes (1 M)

• Maximum value: 256 TB

  Default value for buffered I/O: 1 megabyte (1 M)

If a value is given without a B, K, M, or G qualifier, it is assumed the value is in bytes.

The qualifier can be in upper or lowercase and can be entered adjacent to the value (10M) or separated by a space (10 M).

Example

INDEXCACHESIZE 100M

Sets the index cache size of databases to 100 megabytes.