Skip to Content
0
Former Member
Feb 22, 2015 at 08:29 AM

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

29 Views

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