3 ms·

Would it be possible to simply use a materialized view for table1_join_table2?

• Izkata 3y ago
  The problem there would be how they fall out of date, and updating them is a heavy operation. An alternative I've heard before is using triggers with regular tables, so updating one automatically updates the relevant other ones.
  • r00fus 3y ago
    Materialized views allow insert/update mechanics on many platforms. Alternatively you can refresh them.