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