Precomputed Result Sets

Configuring Adaptive Server to Use Precomputed Result Sets
You must configure Adaptive Server to use precomputed result sets.
Viewing Precomputed Result Sets
See a list of all currently configured precomputed result sets.
Creating a Precomputed Result Set
Create precomputed result sets.
Deleting a Precomputed Result Set
Deleting a precomputed result set deletes its data, removes any system table entries, and deletes the precomputed result set.
Altering a Precomputed Result Set
Altering a precomputed result set changes its policies or properties.
Refreshing Precomputed Result Sets
Refresh precomputed result sets to prevent their data from getting stale.
Truncating a Precomputed Result Set
Truncating a precomputed result set removes the data but retains the definition of the precomputed result set in the system table.
Granting Permissions
Grant permission on precomputed result sets for users, groups, and roles.
Revoking Permissions
Revoke permissions on precomputed result sets for users, groups, and roles.
Granting Precomputed Result Set Permissions to a Specific User
Grant permission for precomputed result sets to specific users.
Revoking Precomputed Result Set Permissions from a Specific User
Revoke precomputed result set permission from a specific user.
Displaying Information About Precomputed Result Sets
Display information (such as column IDs, user names, partition names, and so on) associated with precomputed result sets.
Generating DDL for a Precomputed Result Set
Generate object definitions for existing precomputed result sets.

Parent topic: Manage and Monitor the Adaptive Server Environment