Difference between Cluster and Non-cluster index?
Answer Posted / bala murugan28
IN SIMPLE WORDS,
CLUTER INDEX IS PHYSICALY STORED ONE.
NONCLUSTER INDEX IS LOGICALLY STORED ONE.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is deploy, process and build? : sql server analysis services, ssas
What is field in algebra?
What is the fastest way to permanently delete a 1 million row table named customers?
What is the report builder?
What is implicit cursors?
Explain forward - only cursors?
How to round a numeric value to a specific precision?
When do you think a developer should use sql server-based cursors?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What is the fillfactor concept in indexes?
How do you identify a foreign key?
What is inner join in sql server joins?
What are transactions and its controls?
what do you understand by change data capture?
How to drop existing indexes in ms sql server?