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
How optimize sql query with multiple joins in sql server?
In which files does sql server actually store data?
What is checkpoint in sql server?
What is reference section?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
What are parameterized reports? What are cascading parameters in ssrs reports?
What is the downside of using udf?
What is 3nf normalization form?
What do you mean by collation recursive stored procedure?
What are the recovery models in sql server 2000?
What is sparse columns of sql server 2008?
How to drop an existing user defined function in ms sql server?
Where are sql server usernames and passwords stored in the sql server?
User wants only to display only pdf as export option in report manager. How to achieve this?
What is temporal data type?