5 ms·

But when do you refresh the materialized views?

• smitty1e 4y ago
  Presumably when underlying data are updated.
• yCombLinks 4y ago
  Lots of strategies are possible. I may only need to refresh the data in it once a day. I may need to refresh it on every write. It depends on the applications needs.
  • canada2020 4y ago
    I see. Given it’s so flexible, is this pretty much like a caching layer?
    • deleted 4y ago
      [deleted]
• quickthrower2 4y ago
  In SQL Server it is part of the transaction that affected the underlying data. So you don’t worry about that. Instead you worry about lock escalations!
• dineshgowda24 4y ago
  For us, real-time refreshes weren't necessary. So we ended up refreshing it every 12 hours through application crons.