range_optimizer_max_mem_size

range_optimizer_max_mem_size specifies the maximum memory space available for the Query Range module.

This parameter limits the memory usage of the Query Range module. When the memory used by the Query Range module reaches the specified value, the system no longer extracts a query range. For example, if a complex predicate hits an index and the memory used to extract the query range for the predicate reaches the specified value, the system does not select the index and tries to access the primary table.

Example

ALTER SYSTEM SET range_optimizer_max_mem_size = '128M';