Difference between Cluster and Non-cluster index?
- 32 Answers
- 138280 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / ajay kumar gupta
CLUSTERED INDEX:
Clustered index will be created by default when u
create primary key on a column. So we can create one
clustered index per table. clustered index is stored in
serial passion.
NON CLUSTERED INDEX:
Non clustered index will be created automatically when u
create unique key on a column. A table can have no.of
unique keys, so we can create no.of non clustered indexes
per table.
| Is This Answer Correct ? | 141 Yes | 37 No |
Post New Answer View All Answers
What does it mean to be in union?
Define indexes?
What is single-user mode?
What are the new features are introduced in sql server 2012 reporting services?
How can sql injection be stopped? : sql server security
What are the commands used in DCL?
Explain steps of normalization?
Is null in sql server?
How column data types are determined in a view?
What is a non clustered primary key?
Can we delete data from a view?
Should you normalize audio?
How do you rename a table in sql server?
What is sub-query in sql server? Explain its properties.
What do you mean by SQL injection attack?
