Advanced Querying

  • Shakil Akhtar
  • Ravi Magham


In general querying, we saw how to work with single table. Now let’s explore how to work with multiple tables. When we want to retrieve data from more than one tables from database, joins are used to collect required columns data in a single query. Joins are heavy and slower than plain queries but phoenix supports many configurations and hints to fine tune your join query performance for faster results. We will discuss them in this chapter while explaining join optimizations section.


Global Memory Region Server Query Performance Page Size Configuration Property 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Shakil Akhtar and Ravi Magham 2017

Authors and Affiliations

  • Shakil Akhtar
    • 1
  • Ravi Magham
    • 2
  1. 1.BangaloreIndia
  2. 2.Santa ClaraUSA

Personalised recommendations