At 11:48 AM 19/06/2003 +0000, you wrote:

>Hi Helen,
>
>You are right! Thank you The indexes are disabled. Actually all the
>indexes of all tables are inactive. Since I know for sure we did not
>alter indexes to deactivate them. Simply we did not know this feature.
>
>I like to know what else could cause this to happen.
>
>The only thing we have done is dropping foreign key constraints to
>speed up the delete of about 4.000.0000 records.

I haven't used IBAdmin, but maybe it does a global set inactive on all
indexes when it gets a request to drop FK constraints. Weird if it
does. Or maybe you checked a checkbox that you didn't mean to.

Otherwise gremlins. Definitely. They have a known reputation for getting
into servers at night and doing REALLY sneaky things.

heLen