Controls the use of memory for the optimization of queries involving functional expressions against columns having enumerated storage.
Can be set temporary for an individual connection or for the PUBLIC group. Takes effect immediately.
FPL_EXPRESSION_MEMORY_KB 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 Sybase IQ memory requirements, such as caches. Setting this option to 0 switches off optimization.