Articles tagged “query-execution”

Dec 29, 2022Databases

Query Execution - Joins

Introduction Joins are used to combine data from multiple tables in a database and retrieve the combined data as a single result set. This allows us to effectively retrieve data that is spread across multiple tables and can be especially useful when …

Read article

Dec 26, 2022query-execution

Query Execution - Aggregations

Introduction Once the query planner has determined the optimal plan for executing a query, it's time to implement that plan. But before we can do that, it's important to understand the algorithms used to execute the various operations in the plan. In…

Read article