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
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:
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
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