on 12-12-2008 6:12 PM
Hi
I am deleting data from table DBTABLOG which is occupying 100GB of space, due to the scheduled job I expect 96GB of data to be deleted from this table.
Will this 96GB be available as free space, the index table occupies about 40gb of data, do I need to regenerate the index for this table to get the space for use
please guide me
in theory, an index rebuild is not necessary. But in your case, I highly recommend building your indexes for this table. you will gain 96GB of data and about 38GB of index space.
do not forget to recalc DB stats after reorg.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Eric
Is a re-org necessary every time to get back the unallocated space after I delete records from a table. If yes, please let me know what is the time estimated to do an online re-org, i know that it is dependent on hardware but can you please tell me the approximate time it generally takes for performing re-organization of say 100GB.
Hello Grame,
> Is a re-org necessary every time to get back the unallocated space after I delete records from a table
Yes, if you want to use this space by another database object (for example another index or table).
No, if you want to use this space again by the same object.
As you already said it really depends a lot on the hardware and the way you rebuild the index (ONLINE / OFFLINE / PARALLEL). You can check the metalink note #278600.1 for more information about the access pathes by an index rebuild.
I have rebuilt some indexes ONLINE with round about 100 GB on a good server with SAN disks. It takes round about 4 - 4.5 hours.
Regards
Stefan
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.