ERR-311E0 The estimated size of the index key exceeds the maximum limit

Version

6.1.1 or below

This error message is not output for 6.3.1 or above.

This error occurs when an ORDER BY, GROUP BY or JOIN is used for disk tables.

The following error description can be viewed with the AltiErr utility:

$ altierr 0x311E0
0x311E0 ( 201184) qpERR_ABORT_QDX_MAXIMUM_KEY_SIZE_EXCEED The estimated size of the index key exceeds the maximum limit.

# *Cause:

#- The estimated size of the index key exceeds the maximum limit.

# *Action:

# - Please reduce the number of key columns.

The temporary tablespace is used when an ORDER BY, GROUP BY or JOIN is executed on a disk table.

The temporary tablespace is a disk tablespace and has the fixed page size of 8K.

However, this error occurs when a record that is bigger than 8K was created while using the temporary tablespace.

Note: If the size of a single page (8K) of the disk tablespace is exceeded, the data length is approximately greater than or equal to 3000 bytes.

# Example

Icon

# Example(6.3.1)

1. You can use the hint ‘TEMP_TBS_MEMORY’ to avoid the size limit (8K) of disk temporary tablespaces.

When this hint is used, the temporary area is used in memory instead of disk. Thus, query performance is also improved.

2. Upgrade to 6.3.1 or above. This error does not occur in 6.3.1 or above.