default index size - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

default index size

Author

Topic

khageshcode89
Starting Member

2 Posts

Posted - 2011-09-08 : 02:57:14

i have created a table

create table A(b varchar(10))

after using command

sp_spaceused A

result is


name rows reserved data index_size unused
A    0    0KB      0KB  0KB        0KB

then i inserted a row

insert into A values('abc')

now again using command

sp_spaceused A

result is


name rows reserved data index_size unused
A    1    16KB     8KB  8KB        0KB

So,My question is why index_size is 8KB when i did not created any index.

khagesh gupta

edit: moved to proper forum

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-09-08 : 03:43:21

Because there is always at least one IAM (Index Allocation Map) page. It's an allocation page that says where the pages comprising the index or heap are.

--
Gail Shaw
SQL Server MVP

khageshcode89
Starting Member

2 Posts

Posted - 2011-09-09 : 08:09:18

If so then why index_size increase when i create index on column b but reserved and unused doesn't

khagesh gupta

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources