Specifies the maximum number of lookup pages used in Sybase IQ. Controls the amount of cache allocated to the creation of Lookup FP indexes, particularly FP(3) Indexes.
1 MB – 4096 MB
16 MB
DBA permissions are required to set this option. Can be set temporary for an individual connection or for the PUBLIC group. Takes effect immediately.
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
These options support 3-byte indexes:
INDEX_ADVISOR
MINIMIZE_STORAGE
FP_LOOKUP_SIZE_PPM
These stored procedures support 3-byte indexes:
sp_iqcheckdb
sp_iqcolumn
sp_iqindexadvice
sp_iqindexmetadata
sp_iqindexsize
sp_iqindex
sp_iqindexfragmentation
sp_iqrebuildindex
sp_iqrowdensity
Chapter 6, “Using Sybase IQ Indexes” in System Administration Guide: Volume 1
