المدربA query optimiser rewrites a plan into an equivalent cheaper one before executing it: it pushes filters and projections toward the scans (so that fewer rows and columns are read, chapter 3), removes unused columns and operations, reorders joins and aggregations, and chooses algorithms.
