>
> index IDX1 for RDB$INDICES RDB$FOREIGN_KEY;
> index IDX2 for RDB$RELATION_CONSTRAINTS
> RDB$RELATION_NAME, RDB$CONSTRAINT_TYPE;
>
> Note this indices don't survive backup/restore, you should create

them

> manually each time you restore database. In FB1.5 they are real

system

> indices RDB$INDEX_42 and RDB$INDEX_43.
>
> Best regards, Alexander V.Nevsky.

Ded, you have more than 800 tables -
I have a database with about 120.
In
RDB$INDICES ~ 400 records
RDB$RELATION_CONSTRAINTS ~ 700 records

Do you think that this will speed up queries - there are some very
complex.