|Subject||RE: [firebird-support] Optimizer request|
> Still no changes. This looks to me as a riddle.Do you have an index on partners.country?
> select orders.*
> (select partid from partners where partners.country = ‘Spain’) T
> JOIN orders ON orders.partid = T.partid
If not, how do you expect the system to optimize the search?
The engine would need to perform a scan of the partners table...