Difference between Cluster and Non-cluster index?
- 32 Answers
- 141546 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
Explain error and transaction handling in sql server?
Explain can SSRS reports Cache results?
What is the difference between ‘having’ clause and a ‘where’ clause?
What method is used by the Command classes to execute SQL statements that return single values?
Give the query of getting last two records from the table in SQL SERVER?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
What is the full form of dql?
What is the purpose of a table?
How check triggers in sql server?
What is a result set object returned by mssql_query()?
How to turn on the mssql api module in php?
What are partitioned views?
How raid can influence database performance?
How to encrypt Strored Procedure in SQL SERVER?
What are the different types of collation sensitivity in sql server?
