Difference between Cluster and Non-cluster index?
- 32 Answers
- 138689 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / sangram nayak
clustered index: if there is any primary key then then its clustered index.only one clustered index can be possible.
Non clusterd index: whenever you are creating any index on any column then that is non clustered index.multile non clusted index is possible.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Explain difference between cross join and full outer join?
What are data driven subscriptions?
What is a non equi join?
Do you know what are acid properties of transaction?
What are different type of Collation Sensitivity?
Can you move the resources after pausing the node? : sql server database administration
Explain time data type in sal server 2008?
What is SQL Azure Fabric?
System variable and temporary variables
Can group by and orderby be used together?
How many database files are there in sql server 2000?what are they?
What are types of subqueries?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
What are the differences between stored procedure and view in sql server?
How do I create a partition table in sql server?
