Neoview Database Administrator's Guide (R2.2)

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:
4. Enter the DDL statements for the materialized view: Select lists the columns to select, From
is the file name to select from, and Group By is a key field. Where is an optional field you
can use to limit the selection. Click Next.
64 Managing Database Objects