Difference between Cluster and Non-cluster index?
- 32 Answers
- 138319 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / seema
Clustered Index :-
1.There can be only one Clustered index for a table
2.usually made on the primary key
3.the logical order of the index matches the physical stored
order of the rows on disk
Non-Clustered Index
1.There can be only 249 Clustered index for a table
2.usually made on the any key
3.the logical order of the index does not match the physical
stored order of the rows on disk
| Is This Answer Correct ? | 85 Yes | 11 No |
Post New Answer View All Answers
What are sp_configure commands and set commands?
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
What is transact-sql language?
You want to implement the one-to-one relationship while designing tables. How would you do it?
Is null in sql server?
How does the report manager work in SSRS?
What is a subquery in a select query statement in ms sql server?
What is field in algebra?
What is a virtual table in sql?
What is ms sql server triggers?
What is difference between views and tables?
How to rebuild all indexes on a single table?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
What is acid db?
How to create hyperlink from returned sql query ?
