Thursday, November 24, 2016

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





1 comment:


  1. Your style is very unique compared to other folks I've read stuff from. Thanks for posting when you have the opportunity, Guess I'll just book mark this site. facebook.com login

    ReplyDelete

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents

data recovery