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
Do you know what guidelines should be followed to help minimize deadlocks?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
Which are the important points to note when multilanguage data is stored in a table?
Define Joins?
Why use stored procedures in sql server?
what's the maximum size of a row? : Sql server database administration
What is lookup override?
What are the types of dml?
Define clusters?
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?
Explain magic tables in sql server?
Where do we use trace frag?
List the advantages of using stored procedures?
How do you delete duplicate records in sql server?
Explain boyce and codd normal form(bcnf)?