November 7, 2003 at 10:11 am
I have a table that contains 6 columns and 13 rows of data. (It's a lookup table). The Primary Key is indexed.
SQL 2000 has auto created 2 indexes (WA_SYS) for this table. I understand that these indexes are really statistics for the table.
What's really puzzling me is that the index/statistic is consuming 936,217,440K of disk. The data in the table is trivial with the largest column being a varchar(255).
Has anyone ever seen this before? Why are the statistics for a 20K table consuming almost a Gb of space?
Any suggestions?
November 7, 2003 at 1:08 pm
Where did you get the size from? If you're not using sp_spaceused, try that. The number you wrote is actually close to a terabyte; do you have that much space alocated to the db? I think I'd run DBCC UPDATEUSAGE and then check the size agin.
--Jonathan
--Jonathan
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply