Try OpenEdge Now
skip to main content
Database Administration
Database Basics : OpenEdge RDBMS Limits : Table and index limits
 

Table and index limits

You cannot split a table or an index across storage areas, unless your database is enabled for multi-tenancy.
*In a database without multi-tenancy, each table and each index can be assigned to only one storage area.
*In a multi-tenant database, each table partition and each index partition can be assigned to one storage area. For more information on a multi-tenant database, see Multi-tenantdatabase.
The size of a table or index (partition) is limited to the size of the storage area in which it resides.
The following limits exist:
*The maximum number of table definitions supported is 32,767, regardless of block size.
*Tables have a maximum number of field definitions: SQL supports 500, ABL supports 1000.
*The maximum number of indexes supported is 32,767, regardless of block size.
*Index entries have a maximum of 16 fields per index.
*Index size has the following constraints:
*New databases with 4K and 8K block sizes, total variable-length storage requirements of all fields in an index entry must be less than 2000 characters.
Because the 2000 character limit includes storage overhead, the actual index key is limited to approximately 1970 characters.
*Databases with 1K and 2K block sizes the maximum index entry size is approximately 200 characters.