Progress
Database Administration
Guide and Reference
Table and Index Limits
You cannot split a table or an index across storage areas. Each table and each index can be assigned to only one storage area. Therefore, the size of a table or index is limited to the size of the storage area in which it resides (see Table 3–2).
Regardless of block size, the maximum number of tables supported is 32,767.
Regardless of block size, the maximum number of indexes supported is 32,767.
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 characters.
NOTE: Because the 200 character limit includes storage overhead, the actual index key is limited to approximately 188 characters.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |