Home Forums SQL Server 2008 SQL Server 2008 Administration Index Design RE: Index Design

  • August 24, 2012 at 4:32 am

    #1529644

    GilaMonster (8/24/2012)

    No, what would it need to go to the base table for?

    The only column you're referencing in your query in Col3, and that's in the index row at the leaf of the nonclustered index.

    Please read the articles I referenced.

    Thanks

    I think I'm getting lost in the jargon with this topic

    Clustered Index Leaf level - Contains data rows

    NonClustered Index Leaf level - Contains Index rows

    I'm struggling to understand the difference between the Data Rows and Index Row

    Thanks