Replicating precomputed result sets

These precomputed result set commands are replicated:

Although precomputed result set DDLs can be replicated, precomputed result sets cannot be marked for replication. That is, unlike a regular table, Adaptive Server does not replicate any maintenance changes occurring on data stored in a precomputed result set, regardless of whether the changes are initiated from a precomputed result set DDL (which itself could be replicated), or are part of the base table update transaction (initiated from an immediate refresh policy).

Precomputed result set DDL replication is supported only between two Adaptive Servers that include the precomputed result set functionality.