September 26, 2008 at 1:16 pm
What Unised in table means? We have
Table NameRowsReserved (KB)Data (KB)Index Size (KB)UnUsed (KB)
Table1107945042066440 KB5511024 KB78776 KB36476640 KB
Table260909534410160 KB4412056 KB90936 KB29907168 KB
Table360909533447480 KB4351776 KB46624 KB29049080 KB
Table474158923550968 KB3467656 KB30192 KB20053120 KB
Table59063768 KB744 KB16 KB8 KB
Table65393576 KB256 KB248 KB72 KB
Table72834576 KB176 KB264 KB136 KB
Table82396512 KB152 KB208 KB152 KB
Table92268424 KB128 KB192 KB104 KB
Table104529408 KB296 KB40 KB72 KB
Table1123916384 KB368 KB16 KB0 KB
Table124060352 KB216 KB48 KB88 KB
Table133198320 KB256 KB16 KB48 KB
Table142742288 KB160 KB48 KB80 KB
Table151474272 KB120 KB160 KB-8 KB
Can some one explain the situation of these tables. Thank you
September 26, 2008 at 1:26 pm
This is the space that the table has reserved for it's self though table growth. Have alot of records been added and then removed from the tables? as this seems like alot of space to have unused. Shrinking the database files if this is not typical for these tables will reclaim the space, but it could leave table and index fragmentation.
September 26, 2008 at 1:41 pm
Thank you
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply