alter precomputed result set

Alters the properties or policies of a precomputed result set.

Syntax

alter {precomputed result set | materialized view} 
		[owner_name.]prs_name 
	[{immediate | manual } refresh] 
	[enable | disable] 
	[{enable | disable } use in optimization]

Parameters

Examples

Usage

  • Precomputed result sets are automatically refreshed when you change them from a manual to an immediate refresh policy.

  • If the base table or view on which the precomputed result set is based is dropped or altered, the precomputed result set is automatically altered to disable.

Permissions

You must be the precomputed result set owner to execute the alter command.