Re:Do We Still Have to Denormalize? Have Your Schema and Sea...
by onedognight on Monday November 16, 2026 @10:47AM
(#50518879)
They compare to UNION ALL in passing:
> Getting that original, natural SQL query down to 100 ms on a single core (12x-50x faster than the 84-line UNION ALL rewrite, and within range of a fully denormalized dataset) required rethinking how joins and search indexes interact
> Getting that original, natural SQL query down to 100 ms on a single core (12x-50x faster than the 84-line UNION ALL rewrite, and within range of a fully denormalized dataset) required rethinking how joins and search indexes interact