Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 147136 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
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
Explain triggers in sql?
What is read uncmmited?
How to filter out duplications in the returning rows in ms sql server?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
What do you understand by triggers?
Indexes are updated automatically is the full-text index also updated automatically?
Which are the olap features?
What is dirty read?
How do I start and stop sql server?
what data regions are and what are the different data regions?
What are the advantages of using stored procedures?
What is Transparent Data Encryption?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
How to write an inner join with the where clause in ms sql server?
What is ms sql server service broker?
