4 ms·
I'm using them. Without them, I'd have to periodically load my main table and, in the same process, insert data derived from main table to summary tables. Now I
by paperwork 13y ago
I'm using them. Without them, I'd have to periodically load my main table and, in the same process, insert data derived from main table to summary tables. Now I can just setup materialized views and after I'm done loading data into the main table, just 'refresh' and expect all materialized views will to be synced. Somehow, it feels like a much lighter cognitive load on my brain.