FP_LOOKUP_SIZE Option

Specifies the number of lookup pages and cache memory allocated for Lookup FP indexes in SAP Sybase IQ 15. databases.

Allowed Values

1 MB – 4096 MB

Default

16 MB

Scope

Option can be set at the database (PUBLIC) level only.

Requires the SET ANY SYSTEM OPTION system privilege to set this option. Takes effect immediately.

Dependencies

FP_LOOKUP_SIZE applies to databases running where FP_NBIT_IQ15_COMPATIBILITY='ON'. If FP_NBIT_IQ15_COMPATIBILITY='OFF', the database engine ignores this option.

Remarks

If FP_NBIT_IQ15_COMPATIBILITY='ON', 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

Important: The FP_NBIT_IQ15_COMPATIBILITY option provides tokenized FP support similar to that available in SAP Sybase IQ 15, not complete database compatibility. All SAP Sybase IQ 15 runtime behavior is available using the 16.0 interface. Avoid running a 16.0 database with FP_NBIT_IQ15_COMPATIBILITY='ON'.