Interested to Buy Any Domain ? << Click Here >> for more details...
diffrence between Cluster Index and non Cluster Index
- 3 Answers
- 6174 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / indraneelandhavarapu
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 ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the difference in accessing db between sql server vs sql azure?
Why and when do stored procedure recompile?
Why should you use or avoid select * statements?
Do you know what is user defined datatypes and when you should go for them?
What are the new scripting capabilities of ssms? : sql server management studio
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
What do you mean by cardinality?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
How to disable stored procedure sql server?
What is b tree index?
How to select an exiting database using mssql_select_db()?
List out some of the requirements to set up a sql server failover cluster?
What are the differences between union, intersect, and minus operators?
What is the stuff?
explain different types of constraints? : Sql server database administration
