FP_LOOKUP_SIZE option

The maximum number of lookup pages used in Sybase IQ.

Function

To control amount of cache allocated to the creation of Lookup FP indexes, particularly FP(3) Indexes.

Allowed values

1 MB – 4096 MB

Default

16 MB

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. For further details, see “The Fast Projection (FP) default index type” in Chapter 6, “Using Sybase IQ Indexes” in System Administration Guide: Volume 1.

The FP_LOOKUP_SIZE option must be set public, so the allowed syntax is:

SET OPTION public.FP_LOOKUP_SIZE = 1

Other options

The following options now support 3-byte indexes:

Stored procedures

The following stored procedures now support 3-byte indexes:

See also

“FP_LOOKUP_SIZE_PPM option”

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

“MINIMIZE_STORAGE option”