What is the basic difference between clustered and a
non-clustered index?
- 9 Answers
- 36456 Views
- Infogain, I also Faced
- E-Mail Answers
Answer Posted / guest
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 ? | 89 Yes | 9 No |
Post New Answer View All Answers
What is auditing in sql server?
Explain the categories of stored procedure?
How do I start sql server 2017?
How to get a list of columns in a view using the "sp_help" stored procedure?
Please illustrate physical database architecture? : SQL Server Architecture
Explain difference between cross join and full outer join?
How do you test your database? : sql server database administration
List the advantages of using stored procedures?
What is report rendering ?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
Explain the dirty pages?
How do I start sql server 2016?
Explain the disadvantages/limitation of the cursor?
What is a field in a table?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
