Difference between Cluster and Non-cluster index?
- 32 Answers
- 138483 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / yashpal
Clustered index will be created by default when u
create primary key on a column. only one clustered index is
created per table
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 ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is sql server management studio? : sql server management studio
What is the difference between dropping a database and taking a database offline?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
Why does sql studio use a single registered database repository? : sql server management studio
Tell me what is log shipping?
how to take backup bcp out for a column in table in sql server?
What is buffer cash and log cache in sql server?
Mention the differences between having and where clause.
What are the steps to follow to configure SQL*Net?
How do you delete duplicate records in sql server?
Do you know what is xpath?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
How can delete duplicate records in cte in sql server?
What are the methods used to protect against sql injection attack?
