Specifies the maximum number of lookup pages used in Sybase IQ and controls the amount of cache allocated to the creation of Lookup FP indexes, particularly FP(3) Indexes.
DBA permissions are required to set this option. Can be set temporary for an individual connection or for the PUBLIC group. Takes effect immediately.
FP_LOOKUP_SIZE controls the maximum number of lookup pages.
FP_LOOKUP_SIZE must be set public, so the allowed syntax is:
SET OPTION public.FP_LOOKUP_SIZE = 1
These database 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