Materialized view

Also written: materialized views

A view that stores its result for speed and is refreshed on request. PostgreSQL has them; SQLite doesn't.