Posted by hallpa1@yahoo.com on 04/12/06 19:13

Ok, I think I understand your point about not shrinking the db. Does
this mean that new records will be written to the space that was freed
up by the deletes? I thought that the space would not be reused until
you did a shrink to release it.
However, my purge will be removing about 200 million records and the db
only grows at about 10 million per month. So it would take a long time
to fill up the space freed by the purge.

As for the DBREINDEX and the INDEXDEFRAG, do they produce similar
results? The DBAs that I am doing this for seem to believe that a
reindex will give a bigger performance boost than the defrag.

thanks

• Next in forum: insert into temp table based on if condition
• Prev in forum: Re: Retrieving autonum / IDENTIFIER value from SQL table using DAO.
• Thread view: Re: Time to shrink a database

[Reply to this message]