Creating a Precomputed Result Set

Create precomputed result sets.

  1. In the Administration Console view, select ASE Servers > Compiled Objects > Precomputed Result Sets.
  2. Click the drop-down arrow and select New.
  3. On the Introduction page, indicate the:
    • Server on which you are creating the precomputed result set
    • Database in which the precomputed result set resides
    • Owner of the precomputed result set
  4. Click Next.
  5. Enter the name of the precomputed result set.
  6. Click Next.
  7. On the Options page, specify:
    • The refresh policy for the precomputed result set:
      • Immediate – the precomputed result set is updated with the same transaction that updates the base tables (requires a unique key).
      • Manual – the precomputed result set is updated with an explicit refresh command.
    • Whether the precomputed result set is populated with data when it is created.
    • The locking scheme.
    • Whether the precomputed result set is enabled when it is created.
    • Whether to include the precomputed result set for query rewrite during optimization, or whether to allow queries to use the precomputed result set with stale data.
  8. Click Next.
  9. On the top panel of the Query Expression page, view your selections for creating the precomputed result set . In the bottom panel, add the query to create the precomputed result set.
  10. On the Summary page, view your choices. Select Finish to create the precomputed result set. Select Back to change a selection.
Related tasks
Refreshing Precomputed Result Sets
Configuring SAP ASE to Use Precomputed Result Sets
Deleting a Precomputed Result Set
Altering a Precomputed Result Set