| Subject | [firebird-support] Re: Firebird 2.1.x runs very slow on first query execution (very low CPU usage) |
|---|---|
| Author | Svein Erling Tysvaer |
| Post date | 2009-04-19T19:59:47Z |
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:
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.