Materialized Views
Page | Description |
---|---|
Incremental materialized view | Allow users to shift the cost of computation from query time to insert time, resulting in faster SELECT queries. |
Refreshable materialized view | Conceptually similar to incremental materialized views but require the periodic execution of the query over the full dataset - the results of which are stored in a target table for querying. |