Re: Subqueries or Joins? Problems with multiple table query

On 23 February 2010 13:43, Stefan Schwarzer
<stefan.schwarzer@grid.unep.ch> wrote:
>>>> Select countries.name, basel.year, basel.value, cites.year, cites.value
>>>> From countries
>>>> Left Join basel on basel.id_country = countries.id_country and
>>>> basel.value=1
>>>> Left Join cites on cites.id_country = countries.id_country and
>>>> cites.value=1
>>>
>>> I would have thought so, but the query turns forever.
>>
>> How many rows in each of your tables, and what indexes do you have?
>
> around 5000 rows
>

It takes a long time for just 5000 rows?  Could you provide the
execution plan for it by putting EXPLAIN ANALYZE at the front of your
query and post the result here?

Thom