🎴 Flashcard Mode

Materialized views are pre-computed and stored physically on disk, unlike regular views which are only stored queries. The materialized view occupies actual storage space to hold the computed result set, which is why they need to be refreshed when base data changes.