Specify a restore action for the materialized query table. During a restore, a materialized query table fails if the underlying tables have not yet been resolved. If the materialized query table restore action is deferred, the materialized query table is created at restore, but is not usable until after a Restore Deferred Objects (RSTDFROBJ) command is run.
Possible values are:
Yes
The MQT is deferred until after its based-on files and their members are available.No
The MQT is not deferred.
Note: If the underlying tables have been resolved when the materialized query table is restored, then the materialized query table is not deferred, even if the defer action is specified.