Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 146264 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
How to set the current database in ms sql server?
What is the difference between join and inner join?
What is the maximum length of an alert name?
How much does sql server 2016 cost?
What is the purpose of sql profiler in sql server?
What are different types of database indexes?
How can we delete Duplicate row in table?
What are the characteristics of modern DBMS?
What is a join in sql?
Can you please differentiate between a primary key and a unique key?
How do I view views in sql server?
What is sql server transaction log file?
Explain the difference between delete,drop and truncate in SQL Server?
Explain the steps to create and execute a user-defined function in the sql server?
What is a trace frag?
