4 ms·
> if I do a group by over all rows in a table that they may not perform better Computing aggregates against contiguous values in memory or disk for a single co
by tomnipotent 5y ago
> if I do a group by over all rows in a table that they may not perform better
Computing aggregates against contiguous values in memory or disk for a single column will always be faster than reading records with differing value offsets/alignments. These operations can benefit from SIMD and other hardware optimizations you don't get with row-aligned data.