Views vs. Relations
Logical distinctions:
- Updates not always possible to a view
Physical distinctions:
- Relations must be physically stored somewhere
- Views are either:
- Computed on-demand (not indexable)
- Stored physically (materialized) to enhance performance, and the DBA (or system) must manage the replication.