View Materialization

Keeping Up-to-Date

Usually is done with triggers

Two basic strategies:

  • refresh - drop and re-create again
    • simple, but expensive
  • incremental
    • compute positive and negative changes and apply to the view
    • can be very complex


Machine Learning Bookcamp: Learn machine learning by doing projects. Get 40% off with code "grigorevpc".

Share your opinion