When the number of distinct values exceeds 16777216, no lookup table is created. Each FP entry contains an actual column cell value.
If MINIMIZE_STORAGE is on, you can avoid the overhead of converting lookup FP entries into flat style. When the distinct row count for a particular field increases beyond 16777216, then an FP(3) index is automatically converted to a flat style FP index. Specify the IQ UNIQUE value to be greater than 16777216 at table creation time to create flat style FP.
When you create a table with the DATE data
type, a 2-byte FP index is created on the DATE field,
which is independent of the settings in database option MINIMIZE_STORAGE.
If you want to create a 3-byte FP or flat style FP index on the DATE field, use the following IQ UNIQUE values when creating the table:
For a 3-byte FP index— IQ UNIQUE should be between 65537 and 16777216.
For a flat style FP index— IQ UNIQUE should be higher than 16777216.
