Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 148108 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
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
How to update muliple row in single query?
Explain differences between web edition and business edition?
How to use wildcard characters in like operations in ms sql server?
Describe in brief authentication modes in sql server.
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
What are information schema views?
What is self join in sql server joins?
How many triggers are possible per table?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
Explain about integration services of Microsoft SQL server?
What do you mean by stored techniques? How would we use it?
Does index slows down insert statements?
What happens when converting big values to integers?
Can you force a query to use a specific index?
Explain ms sql server reporting services vs crystal reports?
