Difference between Cluster and Non-cluster index?
- 32 Answers
- 138445 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
What is the difference between having clause and where clause in sql server?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
How to create median function?
Explain few examples of RDBMS?
Tell me the difference between clustered and non-clustered index?
Explain about system database?
What stored by the model?
What is SubQuery in SQL Server 2008
What is read committed?
What is the use of sql profiler in sql server 2012?
What is the difference between char and varchar2 datatype in sql?
what are acid properties? : Sql server database administration
What is data block and how to define data block size?
Mention the differences between substr and charindex in sql server.
What are different types of collation sensitivity?
