On 7/16/19 11:56 AM, David G. Johnston wrote:
On Tue, Jul 16, 2019 at 9:29 AM Ivan Voras <ivo...@gmail.com
<mailto:ivo...@gmail.com>> 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.
