Difference between Cluster and Non-cluster index?
- 32 Answers
- 141666 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
How to rebuild all indexes on a single table?
How to create sub reports?
What are acid properties of transaction?
What happens if null values are involved in datetime operations?
Tell me what is de-normalization and what are some of the examples of it?
how to create a scrollable cursor with the scroll option? : Sql server database administration
What are approximate numeric data types in ms sql server?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
What are transactions and its controls?
Using the customer, and order table in northwind database, please write a query to produce xml?
How do you debug a procedure in sql server?
What are the basic functions for master, msdb, model, tempdb databases?
What are the operating modes in which database mirroring runs?
How to list all user names in a database?
What number sorts of privileges are accessible in sql?
