Advanced Database Management System - Tutorials and Notes: Number of indexes that can be created per table in Various RDBMSs
Please visit, subscribe and share 10 Minutes Lectures in Computer Science

Thursday, 24 November 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

Indexes →
Clustered indexes
Non-clustered indexes / Indexes / Secondary indexes
-          DB2 for Linux and Windows 10.0
32767 or storage
MS Access
-          MS Access 2010
1 (Primary key)
-          MySQL 5.7
1 (synonymous with Primary key)
-          Oracle 11g
No clustered index concept.
(Instead, uses a concept called “Index-Organized Table (IOT)”
-          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.
SQL Server
-          SQL Server 2016

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. login


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