Overview of Materialized Views
A materialized view is a read-only table that maintains a summary of data selected from one or more regular TimesTen tables. The TimesTen tables queried to make up the result set for the materialized view are called detail tables.
Note:
Materialized views are not supported on cache tables.
Figure 8-1 shows a materialized view created from detail tables. An application updates the detail tables and can select data from the materialized view.
The synchronous materialized view, updates the result set data from the detail tables at the time of the detail table transaction. Every time data is updated in the detail tables, the result set is updated. Thus, the materialized view is never out of sync with the detail tables. However, this can affect your performance. A single transaction, the user transaction, runs the updates for both the detail table and any materialized views.