You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@phoenix.apache.org by F21 <f2...@gmail.com> on 2016/10/20 23:36:04 UTC

What are some use-cases for JOINs?

Hey all,

Normally, rather than de-normalizing my data, I prefer to have the data 
duplicated in 2 tables. With transactions, it is quite simple to ensure 
atomic updates to those 2 tables (especially for read-heavy apps). This 
also makes things easier to query and avoids the memory limits of hash 
joins.

Having said that, what are some use-cases of when JOINs should be used?

Cheers,

Francis

Re: What are some use-cases for JOINs?

Posted by F21 <f2...@gmail.com>.

P.S. I meant to say normalizing rather than de-normalizing.

On 21/10/2016 10:36 AM, F21 wrote:
> Hey all,
>
> Normally, rather than de-normalizing my data, I prefer to have the 
> data duplicated in 2 tables. With transactions, it is quite simple to 
> ensure atomic updates to those 2 tables (especially for read-heavy 
> apps). This also makes things easier to query and avoids the memory 
> limits of hash joins.
>
> Having said that, what are some use-cases of when JOINs should be used?
>
> Cheers,
>
> Francis
>