FP_LOOKUP_SIZE_PPM option

Restrict FP lookup storage size in Sybase IQ to this parts-per-million value of main memory.

To control amount of main cache allocated to the creation of Lookup FP indexes for all FP lookup indexes, but particularly for FP(3) indexes.

1 to 1000000

2500

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 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 as specific by the -iqmc server startup parameter.

The following options now support 3-byte indexes:

• FP_LOOKUP_SIZE

• INDEX_ADVISOR

• MINIMIZE_STORAGE