The SQL parameters (SQLStmtCache, SQLTempBuff, SQLTempDisk, SQLTempPgSize) are for problem solving, and not for improving performance.
These parameters exist basically to reconfigure SQL temp tables so that various limits can be lifted. The only guideline is to change these parameters only when a SQL failure occurs during temp tables use (sorting), and the failure was due to a limit being reached. For example,when the size of the data being sorted (the sort record size) is larger than the temp table page size. Then, making -SQLTempPgSize larger is effective. |