Converting An Existing View to a Materialized View

To convert an existing view to a materialized view:

1. Open the record in Application Designer.

2. Select the Record Type tab.

3. Select the Materialized View check box.

4. Specify the refresh method, refresh mode, and build option.

   For detailed information about these options, see Defining Materialized Views.

5. Save and build the record.