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