Altering a Precomputed Result Set

Altering a precomputed result set changes its policies or properties.

  1. In the Administration Console view, select ASE Servers > Compiled Objects > Precomputed Result Sets.
  2. Highlight the precomputed result set to change, and select Properties.
  3. Select the General tab.
  4. Select new options for these precomputed result set policies:
    • Refresh policy
    • Locking scheme
    • Enable the precomputed result set
    • Enable query rewriting
  5. Select Preview to verify your changes.
  6. Click Save to confirm the changes.
Related tasks
Refreshing Precomputed Result Sets
Configuring Adaptive Server to Use Precomputed Result Sets
Creating a Precomputed Result Set
Deleting a Precomputed Result Set