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