Specifies the number of lookup pages and cache memory allocated for Lookup FP indexes in SAP IQ 15. databases.
1 MB – 4096 MB
16 MB
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.
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.
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
The FP_NBIT_IQ15_COMPATIBILITY option provides tokenized FP support similar to that available in SAP IQ 15, not complete database compatibility. All SAP IQ 15 runtime behavior is available using the 16.0 interface. Avoid running a 16.0 database with FP_NBIT_IQ15_COMPATIBILITY='ON'.