3 ms·
I’m wondering if indexes and materialized views can be used to do basically the same thing? That is, assuming they contain all the columns you want.
by skybrian 3y ago
I’m wondering if indexes and materialized views can be used to do basically the same thing? That is, assuming they contain all the columns you want.
- latchkey 3y agoThe issue is writes, not reads.
- giantrobot 3y agoThere's always money in the banana sta...materialized views. Materialized views will get you quite a ways on read heavy workloads.
- Izkata 3y agoAs long as you're okay with the reads being a little out of date after writes occur.