FPL_EXPRESSION_MEMORY_KB option

Function

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

Allowed values

0 – 20000

Default

1024 kilobytes

Scope

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

Description

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.