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

  • August 24, 2012 at 4:19 am

    #1529635

    GilaMonster (8/24/2012)

    If the index satisfies the query completely, why would SQL need to go to the base table?

    Please read the articles I referenced.

    I'm confused about your first reply

    Also, indexes (nonclustered) don't contain data rows, they contain index rows. Only the clustered index has data pages as the leaf level

    If the index satisfies the query completely and a NonClustered index doesn't contain the data rows at its leaf level. Surely then it must go to the base table?

    Thanks