What is the basic difference between clustered and a
non-clustered index?

Answer Posted / s.purushothaman

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 ?    3 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to get the definition of a trigger back?

728


What is self contained multi valued query?

741


How much is a sql server license?

690


Detail about the hardware which is supported by SQL server?

755


What can be used instead of trigger?

797






What are the different types of cursor?

813


What is a heap?

783


What are the requirements for sql server 2016?

685


Can we use trigger new in before insert?

680


What is sql server profiler?

742


What is transaction server isolation?

748


What is the size of transaction log file?

657


how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

736


What are ddl (data definition language) statements for tables in ms sql server?

749


Explain stored procedure?

785