Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Non clustered Index taking up more space than data RE: Non clustered Index taking up more space than data
george sibbald
SSC Guru
Points: 104210
More actions
May 27, 2014 at 7:13 am
#1716676
whats the fill factor on the index?
remember the non-clustered index will also contain either an 8byte RID or the clustered index per row at the leaf level.
---------------------------------------------------------------------