--- In ib-support@yahoogroups.com, "bojo_alex <bojo_alex@y...>"
<bojo_alex@y...> wrote:

> > index IDX1 for RDB$INDICES RDB$FOREIGN_KEY;
> > index IDX2 for RDB$RELATION_CONSTRAINTS
> > RDB$RELATION_NAME, RDB$CONSTRAINT_TYPE;
> Ded, you have more than 800 tables -
> I have a database with about 120.
> In
> RDB$INDICES ~ 400 records
> RDB$RELATION_CONSTRAINTS ~ 700 records

Bojidar, how many times you could try it youself while waiting for
answer? :))) I really don't know, I have only one FB database in
production. On my 2368 indices and 4209 constraints this pair of
indices speeds up first statement ~20 times and common performance
~2-4 times on FB1 Classic. I'm interested in effect on your database
too, if you'll try it, let me know please.

Best regards, Alexander V.Nevsky.