Difference between Cluster and Non-cluster index?
- 32 Answers
- 138504 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
What are the differences between left join and inner join in sql server?
Which Model uses the SET concept
Difference between Inner vs outer joins?
Can You Use Data Mining Models In Ssrs?
What is Federation Root Database?
explain databases and sql server databases architecture? : Sql server database administration
How many types of schemas are there?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
How do I clean up sql server transaction log?
How do you create a data source?
What is a non clustered primary key?
What are sql server functions?
What is the contrast amongst drop and truncate?
How to enter date and time literals in ms sql server?
what is nonclustered index
