On 7/16/19 11:56 AM, David G. Johnston wrote:
Out of curiosity, since there's CREATE TEMP VIEW, any particular reason there's no CREATE TEMP MATERIALIZED VIEW?
Seems like it could be similar to a temp table.
Probably a lack (absence) of use cases resulted in people deciding (or defaulting) to not spend any effort in that area. Incremental maintenance and refresh seem considerably less useful when only the current session can see the table. Temp views and temp tables seem to provide sufficient options in the session lifetime space.
How different is a "
temp materialized view" from a regular view?
--
Angular momentum makes the world go 'round.