Number of indexes that can be created per table in Various RDBMSs

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

Go back to Advanced DBMS Concepts page