Specifies the amount of memory to use for a load into a LF index.
1 to 8
DBA permissions are not required to set this option. Can be set temporary, for an individual connection, or for the PUBLIC group. Takes effect immediately.
4
This option defines the amount of heap memory (in KB) per distinct value used during a load into a LF index. The default allots 4 KB. If the sum of the distinct counts for all LF indexes on a particular table is relatively high (greater than 10,000), then heap memory use may increase to the point of impacting load performance due to system page faulting. If this is the case, you should reduce this option value.
The following formula shows how to calculate the heap memory used (in bytes) by a particular LF index during a load:
Heap-memory-used = (lf_bitmap_cache_kb * 1024) * lf-distinct-count-for-column
Using the default of 4 KB, a LF index with 1000 distinct values can use up to 4 MB of heap memory during a load.
