Indexing Strategies

  • Ramesh Gummadi

    SSC Enthusiast

    Points: 196

    Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rgummadi/indexingstrategies.asp


    Ramesh Gummadi

  • cppwiz

    Hall of Fame

    Points: 3926

    Excellent article - well done !!!

  • bozo7

    Ten Centuries

    Points: 1278

    Well done. Very informative.

    Ross

  • pxdanie

    SSC Enthusiast

    Points: 111

    It's good, but somewhat inaccurate.  In the first section about filtering on member_number, it says that the leaf level of the non-clusterd index has the row ID.  This is true only if the table is a heap table (has no clusterd index on it).  If the table does have a clustered index, the leaf level of the non-clustered index on member_nember constains the clustered key value, which is then used to do a clustered index seek to get to the actual data.

  • samm2425

    SSC Veteran

    Points: 209

    great article

    very informative

  • Davidk

    SSC Enthusiast

    Points: 130

    I concur, very good article! Now all you need is an animated graphics design to walk through the process using the examples in b-tree format for visualization.

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply