At 09:57 AM 3/25/2002 +0100, Henner Kollmann wrote:

>Maybe you have an idea: I need something like the truncate command in
>Oracle.
>1. Have a table with 2.500.000 records.
>2. Remove all records from this table.
>3. Insert 4.500.000 records again.

Unless you've got dependencies on the table, you can drop and
recreate the table itself. That frees the space immediately.
If you do have views, triggers, or procedures that reference
the table, add these steps:

>1. Have a table with 2.500.000 records.
>2. Remove all records from this table.

Commit
Drop indexes
Commit
Count records in table
Commit
Recreate indexes
Commit

>3. Insert 4.500.000 records again.

That should limit the growth.




Regards,

Ann
www.ibphoenix.com
We have answers.