As always it's an engineering decision full of tradeoffs. You should never duplicate your data, except when you need to...etc etc.
> This is why we have indexes in databases, which, if you squint a little, are just another kind of materialized view, at least in their covering form.
darth_avocado•1mo ago