13.2 Tuning to shorten SQL statement execution time by re-examining the buffers

This section explains how to improve processing performance by re-examining the values specified for the following buffer-related operands:

• adbbuff operand in the server definition

• adb_dbbuff_wrktbl_glb_blk_num operand in the server definition

• adb_dbbuff_wrktbl_clt_blk_num operand in the client definition

When you modify the values specified for these operands, be sure to re-estimate the memory requirements.

Organization of this section

• 13.2.1 Points to be checked before performing tuning

• 13.2.2 Reducing the SQL statement execution time

• 13.2.3 Reducing the execution time of an SQL statement that creates a global work table

• 13.2.4 Reducing the execution time of an SQL statement that creates a local work table

• 13.2.5 Reducing the execution time of SQL statements that perform table scans

To Page Top