Precomputed Result Sets

Use SAP Control Center to manage precomputed result sets (PRS).

Precomputed result sets are views for which the result is computed, stored, and available for future use. SAP ASE precomputes queries and attempts to use the precomputed result during subsequent iterations.

• Configuring SAP ASE to Use Precomputed Result Sets
  You must configure SAP ASE 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 on Precomputed Result Sets
  Grant permission on precomputed result sets for users, groups, and roles.
• Revoking Permissions on Precomputed Result Sets
  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.