Query Execution: The phase where the compiled machine code is run on the database to retrieve or manipulate data. Query Optimiser: A software component that determines the most efficient strategy ...