Drew Wilson escribió:
> =# explain SELECT s.source_id, s.value AS sourceValue, t.value AS
> translationValue
> FROM
> source s,
> translation_pair tp,
> translation t,
> language l
> WHERE
> s.source_id = tp.source_id
> AND tp.translation_id = t.translation_id
> AND t.language_id = l.language_id
> AND l.name = 'French' ;
Please provide an EXPLAIN ANALYZE of the query.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.