SQL Server Performance Forum – Threads Archive
INCLUDE ClauseIm 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
if you would have created a covering index in 2000, consider moving the large non-search columns to the include portion in 2005
You’re indexes will be smaller if you use INCLUDE instead of a covering index.