Re: WHERE ... NOT NULL ... OR ... (SELECT...)

2015-08-23 18:01 GMT-03:00 Mario Splivalo <mario(at)splivalo(dot)hr>:
[...]
> Now, I did 'circumvent' the waiting with using UNION:
>
> valipile=# explain select * from account_analytic_line where move_id in
> (select id from account_move_line) union select * from
> account_analytic_line where move_id is null;

[...]

> Unique (cost=193891.55..212017.84 rows=329569 width=162)
> -> Sort (cost=193891.55..194715.47 rows=329569 width=162)

I'm not answering your original question, but since the queries in your UNION
will be mutually exclusive, you could replace your UNION by UNION ALL to rip off
the Sort+Unique Node.

[]s
--
Dickson S. Guedes
mail/xmpp: guedes(at)guedesoft(dot)net - skype: guediz
http://github.com/guedes - http://guedesoft.net
http://www.postgresql.org.br