Home Forums Article Discussions Article Discussions by Author Discuss content posted by Josef Richberg Covering Index using Included Columns RE: Covering Index using Included Columns
arr.nagaraj
SSCertifiable
Points: 6518
More actions
February 11, 2010 at 12:43 am
#1117409
@Thomas-428301,
Included columns are not present at intermediate levels and are present only at leaf levels. So it saves space. You can verify the same using the DMV
sys.Dm_db_index_physical_stats which provides details at each level of the index.
Regards,Raj