Part Three: Phases of Planning @2024 OpenPie. All rights reserved. OpenPie Confidential • Preprocessing ØSimplify the query if possible; collect information • Scan/join planning ØDecide how to implement Simplify scalar expressions • Expand simple SQL functions in-line • Simplify join tree Early Preprocessing @2024 OpenPie. All rights reserved. OpenPie Confidential • Simplify function calls ØThe function expressions • Gather information about join ordering restrictions • Remove useless joins • … Later Preprocessing @2024 OpenPie. All rights reserved. OpenPie Confidential • A qual clause can be enforced at