Re: WHERE ... NOT NULL ... OR ... (SELECT...) - Mailing list pgsql-sql

From Dickson S. Guedes
Subject Re: WHERE ... NOT NULL ... OR ... (SELECT...)
Date
Msg-id CAHHcreqvPiTG_GkfHeLBUbjxcRiL0mxEnCrZ=J_n3+kbDVfzeA@mail.gmail.com
Whole thread Raw
In response to WHERE ... NOT NULL ... OR ... (SELECT...)  (Mario Splivalo <mario@splivalo.hr>)
Responses Re: WHERE ... NOT NULL ... OR ... (SELECT...)
List pgsql-sql
2015-08-23 18:01 GMT-03:00 Mario Splivalo <mario@splivalo.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@guedesoft.net - skype: guediz
http://github.com/guedes - http://guedesoft.net
http://www.postgresql.org.br



pgsql-sql by date:

Previous
From: Mario Splivalo
Date:
Subject: WHERE ... NOT NULL ... OR ... (SELECT...)
Next
From: Mario Splivalo
Date:
Subject: Re: WHERE ... NOT NULL ... OR ... (SELECT...)