Difference between Cluster and Non-cluster index?
- 32 Answers
- 138463 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / palpantian
A clustered index is a special type of index that reorders
the way records in the table are physically stored.
Therefore table can have only one clustered index. The leaf
nodes of a clustered index contain the data pages.
A nonclustered index is a special type of index in which
the logical order of the index does not match the physical
stored order of the rows on disk. The leaf node of a
nonclustered index does not consist of the data pages.
Instead, the leaf nodes contain index rows.
| Is This Answer Correct ? | 339 Yes | 33 No |
Post New Answer View All Answers
How to count rows with the count(*) function in ms sql server?
How to store and query spatial data?
Is INSTEAD OF trigger directly applicable to Table ?
How raid can influence database performance?
what happens on checkpoint? : Sql server database administration
Can we linked SharePoint to a SQL database?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
Explain how to send email from sql database?
What is the need for group functions in sql?
What are examples of triggers?
What is sleeping status in sql server?
What is the syntax for encrypting a column in SQL Server?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
How to count duplicated values in a column in ms sql server?
What is the fastest way to permanently delete a 1 million row table named customers?
