At 07:16 PM 11/19/2002 +0000, mikeevteev wrote:

>Hi All!
>
>I have strange problem.
>My application inserts a lot of records in database as follow:
>
>1. Start wait consistency transaction
>2. Disable constraints and indexes on table
>3. execute delete from table
>4. execute select (*) from table
>5. commit that transaction
>
>It should effectively clear table and collect garbage.

No, it won't. You need to add a commit between the delete
and the select *


Regards,

Ann
www.ibphoenix.com
We have answers.