Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 146985 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
You want to implement the one-to-one relationship while designing tables. How would you do it?
Explain the difference between clustered and non-clustered index?
What are the different types of normalization?
What is full outer join in sql server joins?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
How do I setup a sql server database?
What is explicit mode in sql server?
What are the rendering extensions of ssrs?
Which is better statement or preparedstatement?
What is spatial and temporal data?
How do I view a stored procedure in sql server query?
Explain what is the difference between a local and a global temporary table?
What is inner join in sql server joins?
What is an index. What are the types?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
