FP_LOOKUP_SIZE_PPM option

Restrict FP lookup storage size in Sybase IQ to this parts-per-million value of main memory.

Function

To control amount of main cache allocated to the creation of Lookup FP indexes for all FP lookup indexes, but particularly for FP(3) indexes.

Allowed values

1 to 1000000

Default

2500

Scope

DBA permissions are required to set this option. Can be set temporary for an individual connection or for the PUBLIC group. Takes effect immediately.

Description

Controls the maximum number of lookup pages and restricts this number to a parts-per-million value of main memory, that is, the value of FP_LOOKUP_SIZE_PPM * size of main memory / 1,000,000, where the size of main memory is as specific by the -iqmc server startup parameter.

For further details, see “The Fast Projection (FP) default index type” in Chapter 6, “Using Sybase IQ Indexes” in System Administration Guide: Volume 1.

Other options

The following options now support 3-byte indexes:

See also

“FP_LOOKUP_SIZE option”

Chapter 6, “Using Sybase IQ Indexes” in System Administration Guide: Volume 1

“MINIMIZE_STORAGE option”