Hi,
I have a join query with is not distinct from criteria (select *
from table1 join table2 on a is not distinct from b). on examining, it was
the nested loop join that makes the query slow. For join with ' is not
distinct from ' qual can't the planner choose hash-join
Hi ,
Recently I came across a case where the planner choose larger table on
hash side. I am not sure whether it is an intended behavior or we are missing
something.
I have two tables (a and b) each with single column in it. One table 'a'
is large with around 30 million
tab2) are distinct.
what may be the exact reason and can we fix this ?
P.s I have also attached a sql file to reproduce this
On Tue, 13 Mar 2018 12:42:12 +0530 Ashutosh Bapat
<ashutosh.ba...@enterprisedb.com> wrote
On Mon, Mar 12, 2018 at 10:02 PM, Narendra Prad
specially avoiding larger table on hash side) or any work around available ?
Thanks,
Pradeep
On Thu, 15 Mar 2018 00:40:27 +0530 Jeff Janes <jeff.ja...@gmail.com>
wrote
On Tue, Mar 13, 2018 at 4:02 AM, Narendra Pradeep U U
<narendra.prad...@zohocorp.com> wrote: