ded@... wrote:

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

Sorry, mine question was not right - more appropriate one will be -
I have maked them and compared with and without them the performance info
(from IBExpert)
but do not see any difference. I have tryed with one typical select
statement involving 6-7 joins and stored procedures (this complexity are the
most of queries in my application)

Should I see difference and if yes - what I make wrong?

--
Bojidar Alexanrov
Kodar Ltd.
http://www.Kodar.net