Re: [PERFORM] Poor SQL performance

Place 'and date(r.site_timestamp) = h.first_order_date' after WHERE Best regards, Alexander Kirpa ---(end of broadcast)--- TIP 6: explain analyze is your friend

[PERFORM] Poor SQL performance

Hey there folks. I'm at a loss as to how to increase the speed of this query. It's something I need to run each day, but can't at the rate this runs. Tables are updated 1/day and is vacuum analyzed after each load. select ddw_tran_key, r.price_type_id, t.price_type_id from