Controls the use of memory for the optimization of queries involving functional expressions against columns having enumerated storage.
0 to 20000
Can be set temporary, for an individual connection, or for the PUBLIC group. Takes effect immediately.
1024 kilobytes
The FPL_EXPRESSION_MEMORY_KB option controls the use of memory for the optimization of queries involving functional expressions against columns having enumerated storage. The option enables the DBA to constrain the memory used by this optimization and balance it with other IQ memory requirements (such as caches and LOAD_MEMORY_MB). Setting this option to 0 switches off the optimization.
