Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 146936 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
List out the different types of locks available in sql server?
What is merge?
Difference between uniqe index and uniqe constraint?
Explain datetime2 data type in sal server 2008?
your distribution database is full what will u do
What is a print index?
How to get nth highest salary from employee table.
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What are the authentication modes in sql server? How can it be changed?
Can you name some of the dml commands in sql?
Which table keeps the locking information?
What is a livelock?
Is resultset an interface?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What is instead of trigger sql server?
