Phoenix Materialized Views: What Actually Exists and How to Get the Same Effect
Phoenix has no CREATE MATERIALIZED VIEW statement — the supported equivalent is a view with a covering index. Here's how the mechanism works, a worked example, and the pitfalls.