Difference between Cluster and Non-cluster index?
- 32 Answers
- 138287 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
How do you rebuild an identity column?
What is the simplest way to create a new database in ms sql server?
how can you check the level of fragmentation on a table? : Sql server administration
Explain intellisense for query editing
How can we rewrite sub-queries into simple select statements or with joins?
What new changes are being made in SQL Server?
How to populate a table in sql server?
What are the advantages dts has over bcp?
How to include date and time values in sql statements?
How do you implement session management in SQL Server mode?
What are the source of constraints?
What is ssrs?
Explain the properties of a relational table?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
How do I partition a table in sql server?
