Difference between Cluster and Non-cluster index?
- 32 Answers
- 138541 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
Explain encryption of entire databases without the need for application changes in sql server 2008?
Can two tables have the same primary key?
How to create a dynamic cursor with the dynamic option?
What are the steps to insert a table?
What are commit and rollback in sql?
Do you know the different ddl commands in sql?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
How to find Duplicate Records In table?
What is change data capture (cdc) feature?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
What is transaction server auto commit?
Give me a SQL Query to find out the second largest company?
Explain insert into select statement?
Explain “row_number()” in sql server with an example?
What are the advantages of the mirroring?
