Limits On Indexes

Limits on Indexes

Certain limits apply to indexes.

The maximum length of a key in an index is limited to a quarter of the page size.

Maximum Indexes per Table

The number of indexes that can be accommodated for each table is limited.The actual maximum for a specific table depends on the page size and the number of columns in the indexes.

Table 1. Maximum Indexes per Table
Page Size	Number of Indexes Depending on Column Count
Page Size	Single	2-Column	3-Column
4096	203	145	113
8192	408	291	227
16384	818	584	454
32768	1637	1169	909