Difference between Cluster and Non-cluster index?
- 32 Answers
- 140172 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / seema
Clustered Index :-
1.There can be only one Clustered index for a table
2.usually made on the primary key
3.the logical order of the index matches the physical stored
order of the rows on disk
Non-Clustered Index
1.There can be only 249 Clustered index for a table
2.usually made on the any key
3.the logical order of the index does not match the physical
stored order of the rows on disk
| Is This Answer Correct ? | 85 Yes | 11 No |
Post New Answer View All Answers
What are different types of database indexes?
Explain optimistic and pessimistic concurrency?
What are the reporting services components?
What are the restrictions applicable while creating views? : SQL Server Architecture
Can a cursor be updated? If yes, how you can protect which columns are updated?
Describe in brief databases and sql server databases architecture.
Do you know what are the properties of the relational tables?
What is proper subset of candidate key?
Can a database be shrunk with users active?
What are “lost updates”?
how many layers of tcp/ip protocol combined of? : Sql server database administration
Does table partitioning improve performance?
What is BCNF? How is it better than 2NF & 3NF?
How to add more data to the testing table in ms sql server?
What is the maximum rows in sql server table?
