Everything you always wanted to know about compiled and vectorized queries but were afraid to ask

The query engines of most modern database systems are either based on vectorization or data-centric code generation. These two state-of-the-art query processing paradigms are fundamentally differen...