Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 147092 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
Explain about nested stored procedure?
What is sql server english query?
What are constraints?
What is sql stored procedure?
How can you manage sql azure security?
What are sql server functions?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
What are “unrepeatable reads”?
What are the advantages of paper records?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
Can foreign key be deleted?
What are different types of raid configurations? : SQL Server Architecture
How do I get to sql server configuration manager?
What is difference between createstatement and preparedstatement?
What are the types of stored procedures in an sql server?
