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-tenant database.

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.
    Note: 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.