Good post but given my lack of experience, I could only follow about half of it.

What would be a good place for me to understand how Query Processing Engines excute and optimise in general? I want to see and understand actual system calls behind them.