Dear All,

please help me to understand this topic .

after creating index on table --reserved and unused space increase.

create table tmp(id int)

sp_spaceused tmp

name rowtotal reserved data index_size unused

---- -------- -------- ---- ---------- ------

tmp 0 32 KB 4 KB 0 KB 28 KB

Execution time: 0.058 seconds

sp_spaceused tmp

create index tmp_id on tmp(id)

name rowtotal reserved data index_size unused

---- -------- -------- ---- ---------- ------

tmp 0 64 KB 4 KB 4 KB 56 KB

Execution time: 0.029 seconds

@@maxpagesize = 4MB

why reserved and unused space increase ? help let me know

regards

abhishek