Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Question about included columns in nonclustered indexes: Where exactly are they stored? RE: Question about included columns in nonclustered indexes: Where exactly are they stored?

  • November 19, 2012 at 4:35 am

    #1560277

    Kristian Ask (11/19/2012)

    If the included columns is not creating a covering index, will the included columns still be read or is it then only using the table?

    yes they will be retrieved with the help of keylook up or RID lookup.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)