Set the refresh threshold

If you have administration privilege, you can use the SET command to set a refresh threshold, which refreshes all the materialized views that are associated with a base table. The threshold specifies the percentage of unsorted data in the materialized view.

You can set the threshold from 1 to 99. The default is 20.

To set the materialization refresh threshold, enter:

   MYDB.SCHEMA(USER)=> SET SYSTEM DEFAULT MATERIALIZE THRESHOLD TO 
<number>;

When you use the ALTER VIEWS ON MATERIALIZE REFRESH command, the system refreshes all suspended views, and all non-suspended views whose unsorted data exceeds the refresh threshold.

To change the properties of all SPM views associated with a base table, enter:

   MYDB.SCHEMA(USER)=> ALTER VIEWS ON customers MATERIALIZE REFRESH;