What is the basic difference between clustered and a
non-clustered index?
- 9 Answers
- 36459 Views
- Infogain, I also Faced
- E-Mail Answers
Answer Posted / meera
Clustered index is unique for a table and 249 non-clustered
can be created.The leaf contains data and in non-clustered
the keaf node contains reference to the data.
| Is This Answer Correct ? | 9 Yes | 5 No |
Post New Answer View All Answers
How to create new databases with "create database" statements?
Explain what is the difference between a local and a global temporary table?
Tell me what is normalization? Explain different forms of normalization?
Explain what is the main purpose of having conversation group?
Explain Capacity planning to create a database? and how to monitor it?
How do you size a resultset?
Find nth lowest salary or get nth lowest salary?
which backup strategy you are following at ur company
What are constraints in microsoft sql server?
What types of replication are supported in sql server?
what's the information that can be stored inside a bit column? : Sql server database administration
What is the difference between delete and truncate statements?
Can you explain various data region available in ssrs with their use?
What is sql server locking?
How do I run a trace in sql server?
