What is the difference between Clustered and Non-Clustered Index?
- 1 Answers
- 1146 Views
- I also Faced
- E-Mail Answers
Answer Posted / Rakesh Ray
"A clustered index sorts data in the table itself, while a non-clustered index stores the indexed columns as a separate structure."
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What are the properties of the transaction?
Where can you add custom error messages to sql server?
Can you index views?
Why we use the openxml clause?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How do I find query history in sql server?
What are different types of constraints?
What are the different subsets of sql?
How to remove duplicate rows from table except one?
What are the kinds of subquery?
Why and when do stored procedure recompile?
What is an indexed view?
