Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 147169 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
Is sql server free?
What are three major types of constraints?
Why we need to use secondry database file? though, we can do same work using primary database file also.
Explain the types of indexes.
Can an automatic recovery be initiated by a user?
What are the dis_advantages of stored procedures, triggers, indexes?
Difference between Logical Page and Physical Page in SSRS.
How to backup SQL Server Reporting Services ?
What is Lock table in SQL?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
What is user-defined multi-statement table-valued function?
what happens on checkpoint? : Sql server database administration
what is unique and xaml nonclustered index
Can a function call a stored procedure in sql server?
What is bookmark link in ssrs?
