I understand that only after we reorganise the table then only it will free up the db space.

What are the tables that we need to frequently reorganise to free up disk space or what is the normal things that we need to do to free up the db space ?

KW Foo

Imagine a table:

1 AAA aaaa
2 BBB bbbb
3 CCC cccc
4 DDD dddd

then delete record 3 and add record 5:
In the database it looks like:
1 AAA aaaa
2 BBB bbbb
(3 CCC cccc )marked deleted
4 DDD dddd
5 EEE eeee

After reorganisation (dump - drop - create) it looks like this in the database:
1 AAA aaaa
2 BBB bbbb
4 DDD dddd
5 EEE eeee

I am not sure on what happens when indices are changed, it may look as if the original was deleted and the new inserted rather than the original modified.

So what tables to reorganize regulary? Tables with lots of delete actions (and maybe also key-modifications).

Reorganization methods depend on what database you are using. The next question is: What database do you have?

Thanks for explaning the theory of reorganise table.

The main problem is I do not know which are the tables in Baan IVc4 having a lot of records deletion. Is there anyway to find out number of deleted records in a table ??

We are using Baan IVc4 with Informix 7.31 database.

Regards,
KW Foo

You can use the sessions, count number of records by table - ttaad4220m000 or make you own custom sessions to get a table statistics across companies and then compare the table statistics before and after reorg of tables.