Re:Do We Still Have to Denormalize? Have Your Schema and Sea...
by radiospiel on Monday November 16, 2026 @02:20AM
(#50514969)
Indeed. The query should maybe be a UNION ALL over individual search results instead.
[ Parent
| on HN ]
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