How Index page and data page are related

• ishwarjindal

  SSC Journeyman

  Points: 97

  More actions

  November 3, 2003 at 8:01 am

  #107368

  For clustered index it is said that the leaf node contains data.

  It means if you are pointing to a particular index node in the B-Tree of clustered index then you are actually (indirectly) accessing the data.

  This is the major benefit of clustered index over non-clustered index because non-clustered stores a pointer due to which accessing data takes one more step.

  Now my question is how SQL server implements these data structures and how these things actually work.?

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  November 3, 2003 at 8:22 am

  #480662

  Can you get hands on Inside SQL Server 2000 ?

  Explains this all in depth.

  Frank

  http://www.insidesql.de

  http://www.familienzirkus.de

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• mngong

  SSCertifiable

  Points: 6167

  More actions

  November 4, 2003 at 5:36 am

  #480757

  Sql server 2000 Performance Tuning

  By Whalen Garcia Deluca Thompson Helped me out on that

  Mike