INDEXCACHESIZE

Defines the initial value for the index cache size for any new databases that are created after Analytic Services is restarted. The index cache is a buffer in memory that holds index pages. Analytic Services allocates this memory at startup of the database.

This setting does not apply to aggregate storage databases.

Syntax

INDEXCACHESIZE n

 n
  • An integer expressed in bytes (B), kilobytes (K), megabytes (M), or gigabytes (G)
  • Minimum value: 1 megabyte (1 M)
  • Maximum value: 2 gigabytes (2 G)
  • Default value: 10 megabytes (10 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).

Description

This setting specifies, in bytes, kilobytes, megabytes, or gigabytes, the initial size of the index cache for newly created or migrated databases on the server. The specified value takes effect for all new databases that are created after the server is started. To set or change the index cache size for an individual database, use Administration Services or MaxL. For more information, see the online help or HTML documentation for those components.

Example

INDEXCACHESIZE 100M
sets the index cache size of all subsequently created databases at 100 megabytes.

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com