It's the Memory Latency, Stupid
A database engineer explains why a CPU showing 100% utilization can still be stalled waiting on memory, since a single RAM access may cost hundreds of instructions. Rewriting a GROUP BY aggregation with radix partitioning shrank the working hash tables, cutting memory stalls and runtime.