Post reply

Getting Back reserved space from a table

  • September 24, 2008 at 6:21 am

    #191406

    I have a table called W_CAMP_HIST_F

    It has 70+ million rows.

    It has 62.8 GB of reserved space

    It has 26.8 GB of data

    It has 35.9 GB for indexes

    and it has 17 MB of unused space

    How can I get the 62.8 GB of mreserved space back or at least minimized?

    Or should I just leave it?

    Thanks

  • September 24, 2008 at 6:48 am

    #876302

    You don't need to do anything... the 62.8 GB of reserved space is the sum of your data (26.8 GB) plus the indexes (35.9 GB) plus the unused space (17mb).

  • September 24, 2008 at 12:48 pm

    #876622

    Simple, straight forward, and to the point.

    But in my opinion it should not be called reserved space. It should be called "Total Space Used Up by table and related objects such as indexes on the table"

    Long name, but mush more intuitive.

    Thank you so much for replying.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply