Difference between Cluster and Non-cluster index?
- 32 Answers
- 138450 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
Explain raiserror in sql server?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
Do you know exporting and importing utility?
How you can find out if an index is useful to the optimizer?
How sql server enhances scalability of the database system?
What is the default Port No on which SQL Server listens?
How many types of subqueries are there in sql server?
What are sql server functions?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
What are the different kinds of ssrs reports?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
What is a field in a table?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
How to create a simple stored procedure in ms sql server?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
