phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Josh Elser <els...@apache.org>
Subject Re: SQL with join are running slow
Date Thu, 07 Jun 2018 17:26:35 GMT
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

Mime
View raw message