VIEWs, derived tables, materialized tables and temporary tables are ways of putting a query into a named schema object. By that, I mean they hold the query, rather than the results of the query. The ...