This statement is used to enable large index database keys of up to 2,000 bytes.

Syntax

ALTER DATABASE SET PRO_ENABLE_LARGE_KEYS 'Y'

Notes

  • You must have SQL DBA privileges to enable large keys.
  • Large index keys are supported for databases with 4,000 and 8,000 byte block sizes and are enabled by default.
  • Large index key sizes are enabled by default. However, in Releases 10.1A and earlier, this statement must be used to enable large keys.
  • If large keys are already enabled, an error message indicating such will be returned when you use the statement.