Difference between Cluster and Non-cluster index?
- 32 Answers
- 141732 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 named query? : sql server analysis services, ssas
If a table does not have a unique index, can a cursor be opened on it?
What is the difference between nvl and nvl2?
Why the trigger fires multiple times in single login?
What is the maximum rows in sql server table?
What is instead of trigger sql server?
What is the sql profiler?
What are the difference between clustered and a non-clustered index?
Can two different columns be merged into single column? Show practically?
How do I find the sql server database version?
What methods do you follow to protect from sql injection attack?
What is data source in connection string?
Ways to improve the performance of a SQL Azure Database?
What is a ddl statement?
How to drop an existing table?
