> psql12.3 + jdbc_fdw(oracle18.x), tried:
[got bad query results]
> How about giving oracle_fdw a try?
I will try oracle_fdw then.
Thank you very much for everyone's help!
On Thu, 2020-05-28 at 11:39 -0400, em...@encs.concordia.ca wrote:
> psql12.3 + jdbc_fdw(oracle18.x), tried:
[got bad query results]
How about giving oracle_fdw a try?
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
Hello,
Please find the info for both SQLs (removed yr)
For Q1:
QUERY PLAN
---
Aggregate (cost=5.40..5.41
On 5/28/20 9:59 AM, Ying Lu wrote:
Hello,
would help to see the EXPLAIN ANALYZE for the queries above.
And the EXPLAIN ANALYZE for the first query?
Also please include the entire query, for example:
EXPLAIN ANALYZE select count(*) from oracle_t1 as a inner join local_t1
as b on (a.c1 =
On 5/28/20 8:39 AM, em...@encs.concordia.ca wrote:
Hello,
psql12.3 + jdbc_fdw(oracle18.x), tried:
[1]
select count(*)
from oracle_t1 as a
inner join local_t1 as b
on (a.c1 = b.c1);
return 100 records
[2]
select count(*)
from oracle_t1 as a
inner join local_t1 as b
on (a.c1 = b.c1
OR