Product Information > JADE Initialization File Reference > Chapter 1 - JADE Initialization File > SortMemory

SortMemory

Integer

Default Value of the ServerResultsSetBufferSize parameter

Purpose

The SortMemory parameter specifies the size of memory to be allocated when sorting the result set. This value is used when result sets that overflow the result set buffer size must be sorted (for the ORDER BY or DISTINCT clause).

Multiple allocations of the specified SortMemory size can occur, depending on the result set size.

Parameter is read when …

A result set which was written to an extract file is sorted.