On 05/18/2016 09:03 AM, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
Hi,
as mentioned by other - this is because of outer join
look at: http://tracker.firebirdsql.org/browse/CORE-4823
regards,
Karol Bieniaszewski
W dniu 2016-05-17 12:20:42 użytkownik agharta
On 05/17/2016 09:52 PM, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 17.05.2016 12:20, agharta aghart...@gmail.com [firebird-support] wrote:
>> Any ideas about why fb take too long time to execute the query (and
>> scans so mutch rows)?
> PG can do hash full outer join,
On 05/17/2016 10:51 PM, setysvar setys...@gmail.com [firebird-support]
wrote:
Den 17.05.2016 12:20, skrev agharta aghart...@gmail.com
[firebird-support]:
> Hi all, this is my first post and my english is bad, please be
patient :-)
>
> I've a problem with a full outer join, let me explain.
>
Hi,
as mentioned by other - this is because of outer join
look at: http://tracker.firebirdsql.org/browse/CORE-4823
regards,
Karol Bieniaszewski
W dniu 2016-05-17 12:20:42 użytkownik agharta aghart...@gmail.com
[firebird-support] napisał:
Hi all, this is
17.05.2016 12:20, agharta aghart...@gmail.com [firebird-support] wrote:
> Any ideas about why fb take too long time to execute the query (and
> scans so mutch rows)?
PG can do hash full outer join, FB cannot. That's all.
--
WBR, SD.
Hi all, this is my first post and my english is bad, please be patient :-)
I've a problem with a full outer join, let me explain.
2 tables (10 rows each), 2 cte, 2 full outer joins, 100 rows output.
No indexes. Execution took about 40s. in postgres (i've do a equal
test