Post reply

Table Space Not Reclaimed

  • July 22, 2004 at 3:32 am

    #109249

    Dear All,

    I have a table with indexes. I did housekeeping by deleting around 45% of the content (rows). Logically, the table spaces should be reduce around (more or less) 40%.

    Surprisingly, I found out that the table size only reduce less than 5%



    Regards,
    kokyan

  • July 22, 2004 at 3:58 am

    #515625

    Did you shrink the database afterwards. You will probably find that the space will not be reclaimed until you do so.

    ------------------------------
    The Users are always right - when I'm not wrong!

  • July 22, 2004 at 4:47 am

    #515632

    I had shrunk the database after the delete but take no effect. As long as I know, shrink database only can be done when the the free spaces more than 25% for the whole database.



    Regards,
    kokyan

  • July 22, 2004 at 5:00 am

    #515636

    I think it depends on how you have the db configured. For example, I have growth at 10%. I imagine that when the db needs more space it will take the space left from the delete eventually.

    I do not know a way of manually shrinking the file to zero other than by setting the db to grow by say 5mb.

    ------------------------------
    The Users are always right - when I'm not wrong!

Viewing 4 posts - 1 through 4 (of 4 total)

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