dotnetspider.com
Login Login    Register      

TutorialsForumCareer DevelopmentResourcesReviewsJobsInterviewCommunitiesProjectsTraining
     Silverlight Games  |  Bookmarks  |  New Members FAQ  |  Mentor  |  Code Converter  |  IT Companies  |  Peer Appraisal  |  Members  |  Revenue Sharing  |  Computer Jokes  |  New Posts  |  Social  |  

Subscribe to Subscribers
Talk to Webmaster
Tony John

Facebook
Google+
Twitter
LinkedIn
Online Membersurpalshu
More...
Join our online Google+ community for Bloggers, Content Writers and Webmasters




Resources » Definitions » General

Definition of Clustered and Non-Clustered Index.


Posted Date:     Category: General    
Author: Member Level: Gold    Points: 1


 


In SQL server there are two kinds of indexes, one is clustered and other is non-clustered indexes.

Clustered Index = 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.

Non–Clustered Index = 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...

Feedbacks      

Post Comment:


  • 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.
    •
    Name:   Sign In to fill automatically.
    Email: (Will not be published, but required to validate comment)



    Type the numbers and letters shown on the left.


    Next Resource: What is difference between # and ## SQL server?
    Previous Resource: Features of SQL Server 2000.
    Return to Resources
    Post New Resource
    Category: General


    Post resources and earn money!     		 
    More Resources
    Popular Tags   Tag posting guidelines   Search Tags  
    Clustered index  .  Non-clustered index  .  Sql server  .  



    Follow us on Twitter: https://twitter.com/dotnetspider

    Active Members
    TodayLast 7 Daysmore...

    Awards & Gifts
    Email subscription
  • .NET Jobs
  • .NET Articles
  • .NET Forums
    • Articles Rss Feeds
    Forum Rss Feeds

    About Us    Contact Us    Copyright    Privacy Policy    Terms Of Use    Revenue Sharing sites   Advertise   Talk to Tony John
    Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India
    2005 - 2012 All Rights Reserved.
    .NET and other trademarks mentioned in this site belong to Microsoft and other respective trademark owners.
    Articles, tutorials and all other content offered here is for educational purpose only.
    We are not associated with Microsoft or its partners.