one query is performed and joined it to a table
Paul Clapham wrote:I would do the two queries and combine them with "UNION" to produce the result you're looking for.
Ricardo Coto wrote:union isn't the path to take, it scan the table twice
Ricardo Coto wrote:a union isn't the path to take
Ricardo Coto wrote:but it's not sql server, is postgres
Ricardo Coto wrote:Actually the time it took is pretty good, it took a lot of time presenting me de results because i'm using the shell of psql
Ricardo Coto wrote:Query you put before, get me empty categories and takes a lot of time
Ricardo Coto wrote:if you notice, below there are some filters in the where clause with the column extracted from the inner queries in the left joins...
Ricardo Coto wrote:Brian:
Adjustment in Funding removing the order by gave one ms of optimization
Adjustment in paid removing last_payment gave me a little bit of time (less tan a ms)
Can't remove the ids you mentioned because they are use to link the joins...
Thanks, i'll go with the next tips...
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koophttps://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton