> Heiko, on prepare of the first statement metadata casheing is
> performed. To speed up it on FB1/IB6 and databases with complex
> structure you can create additional indices on system tables, I

long

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

Thanks, Alexander.
I gave it a try but it doesn't seem to be the problem in this case.
Bad performance didn't change!

--Heiko