|
Hi, I’m using postgres 7.4. I have two queries: (1) SELECT a,b FROM table1 WHERE a=99 (2) SELECT a,b,sum (o) as sum_o FROM table2 GROUP BY a,b Both Runs very fast. But when I try to make (2) as a subquery
of (1): SELECT a,b,sum_o FROM table1 LEFT JOIN ( SELECT a,b,sum (o) as sum_o FROM
table2 GROUP BY a,b ) sub_query USING (a,b) WHERE a=99 It runs 100 times slower. I guess it has to do with the postgres unable
to pass the a=99 inside the subquery Any ideas ? ishay |
