Post reply

How is free space in a database re-used after deleting data?

  • August 2, 2013 at 7:48 am

    #296455

    Hi All,

    I have 80gb of free space in a database after unused tables/index and old table data was deleted. I am hoping the data file size does not increase anymore and will use this available free space. Is that safe to assume, if any new data is added to existing tables, the database will use this available free space first?

    Thanks for the input.

  • August 2, 2013 at 7:51 am

    #1638177

    azenon (8/2/2013)

    Hi All,

    I have 80gb of free space in a database after unused tables/index and old table data was deleted. I am hoping the data file size does not increase anymore and will use this available free space. Is that safe to assume, if any new data is added to existing tables, the database will use this available free space first?

    you are correct; the freespace inside the db is used first, and only whent hat is used up would the database size increase.

    i like to think of a database's allotted space as a big cardboard box...i can add stuff and remove stuff from the box (tables, data inside the tables,etc) and the box'es size doesn't change. only when the box is full do i need to resize the box (get a bigger box)

    Thanks for the input.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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