Difference between clustered and non clustered index in SQL

0 votes
Hi!!

Can someone tell me the difference between clustered and non-clustered index in SQL?
Sep 28, 2018 in Database by DataKing99
• 8,100 points
56 views

1 answer to this question.

0 votes

The differences between the clustered and non clustered index in SQL are :

  1. A clustered index is used for easy retrieval of data from the database and its faster whereas reading from non clustered index is relatively slower.
  2. Clustered index alters the way records are stored in a database as it sorts out rows by the column which is set to be clustered index whereas in a non clustered index, it does not alter the way it was stored but it creates a separate object within a table which points back to the original table rows after searching.
  3. One table can only have one clustered index whereas it can have many non clustered index.

answered Sep 28, 2018 by darklord
• 6,140 points

Related Questions In Database

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

Difference between SQL and PL/SQL

SQL is a query language that allows ...READ MORE

answered Oct 15, 2018 in Database by DataKing99
• 8,100 points
128 views
0 votes
1 answer

Can you please explain the difference between inner join and outer join in database?

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

answered May 28 in Database by Sampriti
• 860 points
31 views
0 votes
1 answer

STUFF and REPLACE function in SQL

STUFF Function: This function is used to ...READ MORE

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

Indexes in Database

The index is a data structure that ...READ MORE

answered Aug 20, 2018 in Database by DataKing99
• 8,100 points
44 views
0 votes
1 answer

Secondary index in Cassandra

Secondary indexes are indexes built over column ...READ MORE

answered Aug 21, 2018 in Database by kurt_cobain
• 9,240 points
35 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
44 views
0 votes
1 answer

Different Types Of Index

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

answered Oct 11, 2018 in Database by DataKing99
• 8,100 points
43 views
0 votes
1 answer

What are the different authentication modes in SQL Server? How can it be changed?

Windows mode and Mixed Mode – SQL ...READ MORE

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

What do ‘Record’, ‘Field’ and ‘Table’ mean in terms of a database?

You can refer to the following definitions ...READ MORE

answered Nov 12, 2018 in Database by darklord
• 6,140 points
31 views