Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 145928 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / vikram kumar
The biggest difference between a clustered index and a non-
clustered index is that when you use a clustered index, the
section of the table that comprises the index has its data
pages linked differently from those data pages comprising a
non-clustered index.
In SQL Server 2005 you'll probably hear the term "heap or B-
Tree."
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the types of database recovery models?
What is replication with database mirroring? : sql server database administration
How to transfer a table from one schema to another?
What is @@rowcount in sql?
How can you control the amount of free space in your index pages?
How can I add Reporting Services reports to my application?
How real and float literal values are rounded?
What is store procedure? When do you use?
What's new in sql management studio for sql server? : sql server management studio
What is a unique key constraint?
What are the types of indexes?
What is the difference between clustered and a non-clustered index?
What is table level trigger?
What are SSL and TSL protocols?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
