3 ms·

I'm not OP, but I assume that phrase is in reference to the Oracle capability to not need to completely re-run the underlying query in order to refresh a materi

I'm not OP, but I assume that phrase is in reference to the Oracle capability to not need to completely re-run the underlying query in order to refresh a materialized view. Here's the Oracle article about materialized view refresh, there are further details about the different schemes for incremental refresh within. Briefly, it's a method for refreshing by looking at the deltas since last refresh. https://docs.oracle.com/database/121/DWHSG/refresh.htm#DWHSG03003 https://docs.oracle.com/database/121/DWHSG/refresh.htm#DWHSG...

crudbug 10y ago
Yes, view refresh with only delta changes.
- merb 10y ago
  at least we can use 'CONCURRENTLY' since 9.4 or so, which is already a bonus. and if the data gets to big it's better to use elasticsearch, where you push single objects to it. sadly it requires way more work inside a application and of course more ops work.