Difference between Cluster and Non-cluster index?
- 32 Answers
- 142496 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / kshirsagar sambhaji
The difference is that, Clustered index is unique for any
given table and we can have only one clustered index on a
table. The leaf level of a clustered index is the actual
data and the data is resorted in case of clustered index.
Whereas in case of non-clustered index the leaf level is
actually a pointer to the data in rows so we can have as
many non-clustered indexes as we can on the db.
| Is This Answer Correct ? | 48 Yes | 19 No |
Post New Answer View All Answers
Write an SQL query to obtain the 2nd highest salary.
How can you find out which stored procedures are recompiling?
What is the maximum size per database for sql server express?
How do I open port 1433?
What is difference between equi join and natural join?
How to delete a login name in ms sql server?
What are two difference between sql azure and azure tables?
What is the Main Difference between ACCESS and SQL SERVER?
What do you understand by the analysis services in sql server?
Explain the advantages of merge replication?
How many types of schemas are there?
What is field in algebra?
Why I can not enter 0.001 second in date and time literals in ms sql server?
What is the difference between commit and rollback?
What is Lock table in SQL?
