Precomputed Result Sets

Adaptive Server versions 15.7 ESD #2 and later allow you to create precomputed result sets.

A precomputed result set is a view for which the result is computed, stored, and available for future use. Once configured for precomputed result sets, Adaptive Server precomputes a query and attempts to use the precomputed result to answer the actual query. Precomputed result sets are also called materialized views.

Conceptually, a precomputed result set is both a view (because it includes query definition stored in the system tables) and a table (because it includes persistent data). You can run many of the same operations that you perform on tables on precomputed result sets as well, including creating indexes and running update statistics.

Use the create, alter, and refresh commands on precomputed result sets.