Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 146202 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
What are unicode character string data types in ms sql server?
How do users use Report Builder with SQL Server data sources?
Can we install sql server 2016 on windows 7?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
What is an etl file?
Where are sql server user names and passwords stored in sql server?
What are the differences between union, intersect, and minus operators?
What are the new security features added in sql server 2012? : sql server security
What is star, snowflake and star flake schema? : sql server analysis services, ssas
How do indexes help, types?
Explain datetimeoffset data type in sal server 2008?
How to find the source of a table in sql server?
How to download and install sql server 2005 books online?
How to rebuild the master database?
How to delete all rows with truncate table statement in ms sql server?
