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


Sources