Greetings,

In IBConsole I execute this SQL statement:

select RDB$INDEX_NAME from RDB$INDICES
where (RDB$RELATION_NAME = 'ACCOUNT')
and ((RDB$INDEX_INACTIVE=0) or (RDB$INDEX_INACTIVE is null))
and (RDB$SYSTEM_FLAG = 0 or RDB$SYSTEM_FLAG IS NULL)
and (RDB$FOREIGN_KEY is null)

Which returns one index called: RDB$PRIMARY1 for the Account table.

When I try to set the index to InActive with this statement...
ALTER INDEX RDB$PRIMARY1 INACTIVE

I receive the following error:
Unsuccessful metatupdate MODIFY RDB$INDICESS failed action cancelled by
trigger (2) to preserve data integrity. Cannot deactivate index used by an
Integrity Constraint.

Looks like I have several table that reference this table.

So am I to assume that there is no way to disable this index to speed up the
data import process?

Welcome any tips.

Thanks

Mike