"Diego de Lima" <> writes:
> I have some very complex select statements on 4 million rows tables. =
> When using LEFT JOIN ON, some select statements takes about 2 minutes. =
> When I write exactly the same statement but with LEFT JOIN USING, it =
> takes only 1 minute.
Could we see details please? Like the table schemas, the query itself,
and EXPLAIN ANALYZE results for both cases.
regards, tom lane