Maximum number of clustered and non-clustered indexes per table / Maximum number of indexes per table in Oracle, IBM DB2, MySQL etc. / Maximum number of clustered indexes that can be created per table in various RDBMSs
Number of indexes per table
RDBMSs
↓
|
Indexes →
|
Clustered
indexes
|
Non-clustered
indexes / Indexes / Secondary indexes
|
IBM
-
DB2 for Linux and Windows 10.0
-
|
1
|
32767
or storage
|
|
MS
Access
-
MS Access 2010
|
1 (Primary key)
|
32
|
|
MySQL
-
MySQL 5.7
|
1 (synonymous
with Primary key)
|
64
|
|
Oracle
-
Oracle 11g
|
No clustered
index concept.
(Instead, uses a concept called
“Index-Organized Table (IOT)”
|
Unlimited
|
|
PostgreSQL
-
PostgreSQL 9.6
|
No
clustering index concept. But you can create an index and cluster the table
with the index so that data can be arranged according to the order of the
index.
|
Unlimited
|
|
SQL
Server
-
SQL Server 2016
|
1
|
999
|
|
Go to Maximum number of columns (attributes) per table, index, and keys