SQL with join are running slow

[Susheel Kumar Gadalay <sk...@gmail.com>]

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

Re: SQL with join are running slow

[Josh Elser <el...@apache.org>]

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