Difference between Cluster and Non-cluster index?

Answer Posted / palpantian

A clustered index is a special type of index that reorders
the way records in the table are physically stored.
Therefore table can have only one clustered index. The leaf
nodes of a clustered index contain the data pages.

A nonclustered index is a special type of index in which
the logical order of the index does not match the physical
stored order of the rows on disk. The leaf node of a
nonclustered index does not consist of the data pages.
Instead, the leaf nodes contain index rows.

Is This Answer Correct ?    339 Yes 33 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do you know what guidelines should be followed to help minimize deadlocks?

752


Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

778


Which are the important points to note when multilanguage data is stored in a table?

717


Define Joins?

809


Why use stored procedures in sql server?

751


what's the maximum size of a row? : Sql server database administration

782


What is lookup override?

797


What are the types of dml?

759


Define clusters?

836


what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

768


Explain magic tables in sql server?

759


Where do we use trace frag?

761


List the advantages of using stored procedures?

775


How do you delete duplicate records in sql server?

767


Explain boyce and codd normal form(bcnf)?

736