Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 145975 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 happens when converting big values to numeric data types?
How can I create a new template for import ? : sql server management studio
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
Explain time data type in sal server 2008?
What is normalization? Describe its different types.
What is best institute to Learn DotNET And SQL in chennai?
Tell me what is the significance of null value and why should we avoid permitting null values?
Define views.
What is a field in a table?
What is normalization process?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
What is the query and subquery?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
How to create “dependant” parameter “make, model, year”
What is attribute hierarchy? : sql server analysis services, ssas
