Materialized Query

Use the Materialized Query window to create a new materialized query table or to alter an existing simple table to become a materialized query table.

Materialized query tables provide for precomputed result sets for specified queries, which speed access to the larger source tables against which they run.

To view the SQL used to create a materialized query table, click the Show SQL.

Note that the fields on this dialog change depending on what you are viewing. For example, you will not see the Set as Materialized Query table field unless you are viewing the definition of an existing table and select the Materialized query table tab.

For more information when creating a Materialized query table, see the following:

Set as Materialized Query Table

Full select statement

SQL Assist

Check syntax

Preview results

Populate table with select statement results

Enable for query optimization

Table refresh mode

Maintained by

Last table refresh

Table refresh commit level

Restore deferred