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

  • August 24, 2012 at 4:18 am

    #1529634

    SQLSACT (8/24/2012)

    Would my select statement still have an interaction with the base table even though the nonclustered index satisfies the query completely?

    No. Such indexes are called Covering Indexes.