Difference between Cluster and Non-cluster index?
- 32 Answers
- 141550 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 ? | 86 Yes | 11 No |
Post New Answer View All Answers
What is function of CUBE ?
Does server sql treat char as a variable-length or fixed-length column?
How many types of functions are there in sql server?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
What are the methods used to protect against sql injection attack?
1 01 101 01010
How to fetch the next row from a cursor with a "fetch" statement?
What is a data source file?
List the different index configurations possible for a table?
Describe the functionalities that views support.
How many types of built in functions are there in sql server 2012?
How to provide values to user defined function parameters?
Why is replication required on the sql server?
Differentiate between a local and a global temporary table?
Explain what is the use of custom fields in report?
