Can Somebody tell me the difference between Clustered & Non-
Clustered Index??

Answer Posted / ramesh.p

The difference between a clustered index and a non-
clustered index is that when you use a clustered index, the
section of the table that comprises the index has its data
pages linked differently from those data pages comprising a
non-clustered index.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to get the definition of a view out of the sql server?

700


Explain about analysis services?

754


How to create a dynamic cursor with the dynamic option?

713


What is the difference between clustered index and primary key?

675


What are the types of processing and explain each? : sql server analysis services, ssas

897






Explain external key management in sql server 2008

674


What are the encryption mechanisms in sql server?

730


What is sql injection and why is it a problem? : sql server security

730


Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

129


Will count(column) include columns with null values in its count?

837


What is “asynchronous” communication in sql server service broker?

709


What is the recommended total size of your memory optimized tables?

700


how to trace the traffic hitting a sql server? : Sql server database administration

1413


What do you understand by mirroring?

740


What is the difference between SQL notification and SQL invalidation?

780