SQL Server Performance

INCLUDE Clause

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by Paully13x, Dec 6, 2005.

  1. Paully13x New Member

    Im trying to decide if I should or shouldnt use the INCLUDE clause on indexes in SQL 2005.. Or if I should continue creating standard covering indexes. I care mostly about the performance differences.. If anyone could share a definitive answer I would really appreciate it..

    Thanks,

    Paul

    Paully13x, Dec 6, 2005
    #2

  2. joechang New Member

    if you would have created a covering index in 2000, consider moving the large non-search columns to the include portion in 2005
    joechang, Dec 6, 2005
    #2

  3. mulhall New Member

    You're indexes will be smaller if you use INCLUDE instead of a covering index.
    mulhall, Dec 9, 2005
    #2

Share This Page