Advanced Querying
Shakil Akhtar, Ravi Magham · Apress eBooks · 2016
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. 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.