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

Posted to user@phoenix.apache.org by Cheyenne Forbes <ch...@gmail.com> on 2017/05/25 15:12:30 UTC

Requests in for loop vs joins

Which is more efficient in heavy usage platform?

   1. Join 8 tables with billions of rows
   2. Select the "primary row" from a table then run multiple select
   queries on the other tables using each primary key returned from the first
   table in a for loop on the client side


Regards,

Cheyenne O. Forbes