Richard Neill wrote:
> SELECT ( core.demand.qty - viwcs.wave_end_demand.qty_remaining )
> FROM
> core.demand,
> viwcs.previous_wave
> LEFT OUTER JOIN viwcs.wave_end_demand USING ( wid )
> WHERE core.demand.id = viwcs.wave_end_demand.demand_id;
For comparison, how does this do?:
SELECT (core.demand.qty - viwcs.wave_end_demand.qty_remaining)
FROM core.demand,
JOIN viwcs.previous_wave
ON (core.demand.id = viwcs.wave_end_demand.demand_id)
LEFT OUTER JOIN viwcs.wave_end_demand USING (wid);
-Kevin
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
