Neoview Database Administrator's Guide (R2.4)

Creating a Materialized Aggregate View
1. Start DB Admin and log on using any user ID that is authorized to access the table for which
you want to create a materialized view.
2. Click the Database tab, then select the schema in which you want to create a materialized
view. Right-click the Materialized Views folder and then select Create materialized view
to start the Create Materialized View Wizard. You can also click Create a materialized view
in the right pane.
Select Aggregate View or Join View. Enter a name for the materialized view and click Next:
3. DB Admin prompts you to specify the attributes for the materialized view: Initialization
Type specifies whether the materialized view should be initialized at creation or refresh
time, Refresh Type specifies when it should be refreshed, and Refresh Commit Each specifies
the number of rows that the refresh operation processes before committing a transaction
and processing more rows.
Enter a value and click Next:
Materialized Views 75