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