New Members FAQ
Definition of Clustered and Non-Clustered Index.
Posted Date: 21-Nov-2009
In SQL server there are two kinds of indexes, one is clustered and other is non-clustered indexes.
= Clustered index reorders the records in other way from which they are physically stored. It can have only one clustered index. The leaf node of clustered index contains the data pages.
= A non-clustered index stores the logical order of the records which doesn’t match the physical stored orders of the rows. The leaf nodes of a non-clustered index do not consist of data pages but it contains the index of rows. Each index row contains non-clustered key value and one or more row locators points to the data rows having key value.
Did you like this resource? Share it with your friends and show your love!
Responses to "Definition of Clustered and Non-Clustered Index."
No responses found. Be the first to respond...
Notify me by email when others post comments to this article.
Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
No HTML formatting and links to other web sites are allowed.
This is a strictly moderated site. Absolutely no spam allowed.
to fill automatically.
(Will not be published, but
to validate comment)
Type the numbers and letters shown on the left.
What is difference between # and ## SQL server?
Features of SQL Server 2000.
Return to Resources
Post New Resource
Post resources and
CAML Definition in SharePoint
Basic Functionality of MASTER, MSDB, MODEL and TEMPDB database.
ClickOnce Deployment Architecture
Smart Client Software Factory – Default Project Creation
Brief details about Smart Client EndPoint Catalog Application Block
Tag posting guidelines
Asheej T K
Last 7 Days
Asheej T K
Awards & Gifts
Articles Rss Feeds
Forum Rss Feeds
Talk to Webmaster Tony John
Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India