Salesforce

What are the index limits in OpenEdge?

« Go Back

Information

 
TitleWhat are the index limits in OpenEdge?
URL NameP113284
Article Number000151857
EnvironmentProduct: OpenEdge
Version 10.x, 11.x
Product: Progress
Version: 9.x
OS: All supported platforms
Question/Problem Description
What are the index limits in OpenEdge?
What are the maximum fields per index?
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution
In all Releases prior to OE10.1B, the index limits are as follows:
- Regardless of block size, the maximum number of indexes supported per database is 32,767, in OpenEdge.
- Index entries have a maximum of 16 fields per index. 
- Total variable-length storage requirements of all fields in an index entry must be less than 200 bytes.
Note: Because the 200 bytes limit includes storage overhead, the actual index key is limited to approximately 188 bytes.

In Release OE10.1B and forward, the index size has been increased:
- Total variable-length storage requirements of all fields in an index entry must be less than 2000 bytes.
- The maximum number of indexes per database remains at 32767.
Note: Because the 2000 bytes limit includes storage overhead, the actual index key is limited to approximately 1970 bytes.
 
Workaround
Notes

Databases with 1K and 2K block sizes adhere to the previous index entry size of approximately 200 characters.
Databases migrated to Release 10.1C adhere to the previous index entry size of approximately 200 characters unless explicitly enabled to accept larger index entries with PROUTIL ENABLELARGEKEYS.

References to Written Documentation:

OpenEdge Data Management: Database Administration, Chapter 2 "OpenEdge RDBMS Limits": "Table and index limits".

 

Keyword Phrase
Last Modified Date4/10/2019 7:56 PM

Powered by