3 ms·

you mean you want the materialized view to refresh automatically? or what does "incremental" mean in this context? (sorry I'm no DB-person)

• Godel_unicode 10y ago
  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.