Hi,

> >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.

Must be - this isn't allowed:

alter index rdb$foreign80 inactive


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com