Different Types Of Index

0 votes
Hi!!

Can someone list the different types of index?

Thanks!
Oct 11, 2018 in Database by darklord
• 6,140 points
44 views

1 answer to this question.

0 votes

There are three types of index namely:

Unique Index:

This index does not allow the field to have duplicate values if the column is unique indexed. If a primary key is defined, a unique index can be applied automatically.

Clustered Index:

This index reorders the physical order of the table and searches based on the basis of key values. Each table can only have one clustered index.

Non-Clustered Index:

Non-Clustered Index does not alter the physical order of the table and maintains a logical order of the data. Each table can have many nonclustered indexes.

answered Oct 11, 2018 by DataKing99
• 8,100 points

Related Questions In Database

0 votes
1 answer

What are the different types of index?

There are three types of index namely: Unique ...READ MORE

answered Oct 17, 2018 in Database by darklord
• 6,140 points
67 views
0 votes
1 answer

What are the different types of keys used in the database?

There are mainly 5 types of Keys, ...READ MORE

answered Nov 19, 2018 in Database by darklord
• 6,140 points
53 views
0 votes
1 answer

What are the different types of join in SQL?

Hi Suraj, You have a doubt regarding inner join ...READ MORE

answered May 28 in Database by Sampriti
• 860 points
45 views
0 votes
2 answers

Types of relationships in Database

There are 3 types of relationships in ...READ MORE

answered Aug 16, 2018 in Database by zombie
• 3,690 points
25 views
0 votes
1 answer

How to connect Java program to the MySQL database?

You can connect your Java code with ...READ MORE

answered May 11, 2018 in Java by parth295
• 4,600 points
125 views
0 votes
1 answer

Ways to improve query performance using Index hunting

Index hunting help in improving query performance ...READ MORE

answered Aug 29, 2018 in Database by CodingByHeart77
• 3,680 points
45 views
0 votes
1 answer

Is SELECT * harmful in Database?

There are really three major reasons: Inefficiency in ...READ MORE

answered Sep 7, 2018 in Database by DataKing99
• 8,100 points
26 views
0 votes
1 answer

Difference between single and double quotes in SQL

Single quotes are used to indicate the ...READ MORE

answered Sep 11, 2018 in Database by CodingByHeart77
• 3,680 points
62 views
0 votes
1 answer

Different types of SQL Joins

The 4 main kinds of Joins present ...READ MORE

answered Sep 7, 2018 in Database by DataKing99
• 8,100 points
91 views
0 votes
1 answer

Different types of a subquery

There are two types of subquery namely, ...READ MORE

answered Oct 18, 2018 in Database by DataKing99
• 8,100 points
47 views