Difference between Cluster and Non-cluster index?
Answer Posted / indranil
The clustered index is SORTED, and the nonclustered index is
UNSORTED.
For example, we have a pile of birth certificates in City
Hall, and we're going to make an index by birthday (birth
date, to be more exact.)
With a nonclustered index, it's like you have a bunch of
paper lists, each paper with a date, and the people born
under that date. You can quickly determine all people who
were born on August 4, 1986. However the papers themselves
are not sorted, so if you wanted to know all people born in
1986, or August 1986, you'll have to go through all the papers.
With a clustered index, the birth certificates themselves
are sorted by birth date, so searching for people born in
1986, or August 1986, January-June 1981, or any date range
is much faster. Also, it is easier to sort all the people by
birth date (since the data is already sorted).
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the filtered index?
What do we need queues in sql service broker?
Explain can you implement data mining in ssrs?
When you use @@error and try-catch?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
What is a DBMS, query, SQL?
How do I find the port number for sql server?
How to find the login name linked to a given user name?
can we have a nested transaction? : Sql server database administration
Explain left outer join and right outer join?
What are the limitations/drawbacks or ssrs 2008 r2?
What is a db view?
What is normalization? Explain its different types?
Can we perform backup restore operation on tempdb? : sql server database administration
What are the 7 disadvantages to a manual system?