|
|
Posted by rshivaraman on 05/04/07 13:02
exec sp_spaceused TableA
TableA 1 16 KB 8 KB 8 KB 0 KB
exec sp_spaceused Tableb
TableB 1 16 KB 8 KB 8 KB 0 KB
Hi : I created two tables.
TableA has a varchar field of size 18
TableB has a numeric field of size 9(15,0)
I put data of 18 1's in TableA and 15 1's in TableB
Why is there an index_size whey i have not created any pks and ixs.
Looks like they are the same storage size ? Is that strange ?
Right now,there are only one rows in each, so if i had more rows of
same data, will the size differ ?
Navigation:
[Reply to this message]
|