Restricts FP lookup storage size in Sybase IQ to this parts-per-million value of main memory.
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_PPM controls the amount of main cache allocated to the creation of Lookup FP indexes for all FP lookup indexes, but particularly for FP(3) indexes.
This option controls the maximum number of lookup pages and restricts this number to a parts-per-million value of main memory, that is, the value of FP_LOOKUP_SIZE_PPM * size of main memory / 1,000,000, where the size of main memory is specified by the -iqmc server startup parameter.
These options support 3-byte indexes:
FP_LOOKUP_SIZE
INDEX_ADVISOR
MINIMIZE_STORAGE