Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 146988 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
Where are sql server user names and passwords stored in sql server?
Explain the truncate command? : SQL Server Architecture
What is the purpose of optimization?
How can we remove orphan records from a table?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
Can you explain powershell included in sql server 2008?
What are the different types of backups avaialabe in sql server 2005?
What are sql server functions?
What is b tree index?
What is replace and stuff function in sql server?
What is a field in a table?
Can we use where and having clause together?
What is the Difference Between Primary and Foreign Key?
Can truncate be rolled back?
What is indexed view?
