Query transformation is a key process in the PostgreSQL Cost-Based Optimizer (CBO) that allows the optimizer to modify a user’s SQL query in order to generate a more efficient query plan. In this process, the … Continue reading Looking under the hood of query transformation (done by CBO) in PostgreSQL with a simple real-life example