FPL_EXPRESSION_MEMORY_KB option

Controls the use of memory for the optimization of queries involving functional expressions against columns having enumerated storage.

0 – 20000

1024 kilobytes

Can be set temporary for an individual connection or for the PUBLIC group. Takes effect immediately.

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 Sybase IQ memory requirements, such as caches and LOAD_MEMORY_MB. Setting this option to 0 switches off optimization.