how data will be feched from data pages using index ?

• ravi@sql

  SSCrazy

  Points: 2121

  More actions

  November 14, 2011 at 9:10 pm

  #251896

  Hi All,

  Can you please tell me , how data will be fetched from data pages using index ?

  How many jumps exactly it need to get the specific data using clustered index and

  Non clustered index ?. from root paage to leaf node .

  How exactly index page will get used to fecth data ? In detail i need .

  Please suggest me any site or link to get these .

  Thanks with Best Regards,

  Ravi.

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  November 14, 2011 at 9:18 pm

  #1407610

  Here is a good place to start:

  http://www.simple-talk.com/sql/learn-sql-server/sql-server-index-basics/

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]

• ravi@sql

  SSCrazy

  Points: 2121

  More actions

  November 14, 2011 at 9:41 pm

  #1407611

  Thank you . But i have read it already , i need indetail exactly in index page and data page how many jumps it requires and more in detail .

• Ramasankar Molleti

  Ten Centuries

  Points: 1044

  More actions

  November 14, 2011 at 11:16 pm

  #1407624

  Please find the below link.

  http://www.sqlskills.com/BLOGS/KIMBERLY/post/Companion-content-for-Chapter-6-%28Index-Internals%29-of-SQL-Server-2008-Internals.aspx

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  November 15, 2011 at 1:24 am

  #1407658

  Have you read this series? http://www.sqlservercentral.com/articles/Indexing/68439/

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass