This subsection lists and describes the formulas used to calculate the buffer size for sorting.

n: Number of data items to be processed

• For pdload: Sum of existing data in the table and additional data to be loaded
• For pdrorg: Number of data items to be unloaded
• For pdrbal: Number of data items to be rebalanced

For a repetition column, the number of data items is the number of elements, not the number of rows.

k: Key length (maximum value). For details about the formula for obtaining the key length, see 16.1.3(3) Examples of calculating the number of index storage pages.

x: If all key component columns are fixed length, the value is 10. If they include a variable length column, the value is 12.

c: Number of index component columns

y: Linux edition: 2, otherwise: 1

z: For a variable-length multicolumn index: c 4, otherwise: 0

K: For a variable-length multicolumn index: k + c + 8, otherwise: k + 12

N: For a variable-length multicolumn index: (c 2) + y, otherwise: 3 + y

R: k + x + z

A: 32-bit mode HiRDB: R + (K + 8) + 28, 64-bit mode HiRDB: R + (K + 8) + 56

B: 32-bit mode HiRDB: R + (K + 8) + 56, 64-bit mode HiRDB: R + (K + 8) + 104

C: 32-bit mode HiRDB: 2,092 + (N 32) + (K + 8), 64-bit mode HiRDB: 2,112 + (N 32) + (K + 8)