Difference between Cluster and Non-cluster index?
- 32 Answers
- 138535 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / upma
when u create primary key in a table than cluster index are automatically created...becoz there can b only one primary key on a table,so cluster index is one in a table.cluster index reorder the way records in a table are physically stored...
Non cluster index,when u create unique automatically generated... 249 non cluster index in a table,because we can apply more than one unique key in a table..
logically order, does not match with physical order..
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the advantages of using stored procedures in sql server?
What is a bit datatype?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
How can change procedure in sql server?
Can an entity have two primary keys?
What is save transaction and save point?
What are the purposes of floor and sign functions?
Explain what is the main purpose of having conversation group?
What do you mean by recursive stored procedure?
What is standby servers? Explain types of standby servers.
whats the maximum size of view state??
What are the advantages of sql stored procedure?
What is spatial and temporal data?
Explain sql server authentication modes?
What is a heap?
