se_tablescan_lookahead_kb (integer) ​

Memory adjustment can be done by setting up this configuration parameter. Effective setting for this configuration parameter generally range from 10 to 100 megabytes.

• Recommended setting for cloud environments:

-- Set the additional memory. It will be used during query scan/query skip to improve performance.
SET se_tablescan_lookahead_kb = 128000;

• Recommended setting for appliance platforms:

SET se_tablescan_lookahead_kb = 1;