Parsing and translation → query optimization → query evaluation

File sorting → hashing → SQL compilation

Query optimization → parsing and translation → query evaluation

Query evaluation → parsing and translation → query optimization