database denormalization is awkward, but soul-crushing full second queries are brutal. Indexes can't save you. I blame Boyce-Codd.