The following limits apply to indexes in Adaptive Server:
You can create only one clustered index per table, since the data for a clustered index is ordered by index key.
You can create a maximum of 249 nonclustered indexes per table.
A key can be made up of as many as 31 columns. The maximum number of bytes per index key is 600.
When you create a clustered index, Adaptive Server requires empty free space to copy the rows in the table and allocate space for the clustered index pages. It also requires space to re-create any nonclustered indexes on the table.
The amount of space required can vary, depending on how full the table’s pages are when you begin and what space management properties are applied to the table and index pages.
See “Determining the space available for maintenance activities” for more information.
The referential integrity constraints unique and primary key create unique indexes to enforce their restrictions on the keys. By default, unique constraints create nonclustered indexes and primary key constraints create clustered indexes.