Sp_spaceused Question !

name
rows
reserved
data
index_size
unused

Table1
2553136
294424 KB
293176 KB
1072 KB
176 KB





When I run sp_spaceused on a table called Table1, I get numbers as shown above.



I have a clustered Index on a datetime column AND that is the only index on the table.



So according to my calculations Index Size should be 2553136 (No. Of Rows) X (8 (DataType of DateTime) + 4 (Uniquifier) )



So the number I should be seeing in the Index Size column = 2553136 * 12 = 30637 KB, why am I only seeing 1072 KB ?



Where am I going wrong in my calculations.



To be more specific -- how do I calculate the Size Occupied by Indexes on a Particular Table ??



Thanks