Difference between Cluster and Non-cluster index?
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
In what sequence sql statement is processed?
how many type of indexing in database?
What is the difference between inner join and equi join?
Explain Reporting Life Cycle?
1 01 101 01010
Explain what is scheduled job and how to create it?
What are the restrictions applicable while creating views? : SQL Server Architecture
What do you mean by data manipulation language?
What is the difference between a function and a trigger?
How many null values we can have in a unique key field in sql server?
Why use cursor in sql server?
What is left outer join in sql server joins?
What happens to a statement batch if there is a compilation error?
What is catalog views?
Where are SQL server users names and passwords are stored in sql server?