That sounds like the implementation of a HashJoin. You would want to
make sure your smaller relation is serialized for this HashJoin, not the
larger one.
Phoenix also supports a sort-merge join which may be more better
performing when you read a large percentage of data for both relations.
On 6/7/18 2:35 AM, Susheel Kumar Gadalay wrote:
Hi,
We have observed the SQL statements with table inner join are running
very slow.
From the explain plan we have noticed the first table filtered data is
sent to client and the subsequent table joins are run from client each
joined table data. Is it the way Phoenix execute SQL join statements?
Thanks
Susheel Kumar