--- In ib-support@y..., Phil Shrimpton <phil@s...> wrote:

> Hi,
>
> Something that I have noticed in all versions of IB/FB on all

platforms, with

> all access methods and 'tools' I have tried, is that the first

'query' after

> connecting to the database takes forever and after that all
> 'queries' run like s**t off a shoval.

Hi, Phil. If there are many indexes and referential constraints in
your database, I can recommend add

CREATE INDEX RDB$INDICES_IDX1 ON
RDB$INDICES (RDB$FOREIGN_KEY)

But don`t forget to re-create user-created indexes on system tables
after buckup/restore.

Best regards.