Query Compiler

NVME SSD can supply data much faster than a query interpreter can process it. Queries might only be run once, so it's only worth spending time on optimization at compile-time if doing so will save even more time at runtime.

The missing tier for query compilers

Database query engines used to be able to assume that disk latency was so high that the overhead of interpreting the query plan didn't matter. Unfortunately these days a cheap nvme ssd can supply data much faster than a query interpreter can process it.

https://www.scattered-thoughts.net/writing/the-missing-tier-for-query-compilers/

Query Compiler

Recommendations