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.
O
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?
