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





No comments:

Post a Comment

Popular Posts