Yes. It is the index which Firebird creates automatically for the foreign keys. I didn't add any additional indexes.

But I have a trigger in a table, which recalculate the selectivity of the indexes on every 1000 inserts = two or three days work.

--- In firebird-support@yahoogroups.com, Svein Erling Tysvaer <svein.erling.tysvaer@...> wrote:
>
> Just to check:
>
> You mean that the field is a foreign key and as such is indexed, and not
> that you have a separate index on the field in addition to the foreign key?
>
> Set
>
> mdjorov wrote:
> > --- In firebird-support@yahoogroups.com, "zlatko.ivankovic" wrote:
> >> Do you have index on field opr.sklad_id ?
> >>
> >>
> >> regards,
> >> Zlatko
> >>
> > Yes. OPR.SKLAD_ID is a foreign key and it has an index.
>