Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 147099 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / moin khan
Clustered Index
1. Only one per table
2. Faster to read than non clustered as data is
physically stored in index order
Non Clustered Index
1. Can be used many times per table
2.Quicker for insert and update operations than a
clustered index
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between a primary key and a unique key? Are they the same?
what is sql server? : Sql server database administration
Explain the use of containers in ssis and also their types?
What do you understand by the denormalisation?
Please explain what is “asynchronous” communication in sql server service broker?
How to resolve the orphan use problem? : sql server security
What are the differences between stored procedure and the dynamic sql?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
What is the benefit of normalization?
What is difference between createstatement and preparedstatement?
What are the filtered indexes?
What are different backups available in sql server?
What is indexed view?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
What is sql injection? How to protect against sql injection attack?
