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
50 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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
54 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
117 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
• 620 points
21 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
43 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
42 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
31 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
42 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
40 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
35 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
25 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.