Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 145952 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 what is public role in sql server?
Can we call stored procedure in trigger?
Difference between 2NF &3NF ?
Explain the commands in sql server?
Explain unique key in sql server?
What do you understand by a view? What does the with check option clause for a view do?
What is sql server profiler?
How do you rename a table in sql server?
What is policy management?
How do you delete a data source?
what is raid? : Sql server database administration
What is user-defined scalar function?
How you can change a cross join into an inner join?
How do you start single user mode in clustered installations?
How adventureworkslt tables are related?
