Configuring SAP ASE for Precomputed Result Sets

Before you create or alter precomputed result sets, verify that a number of session set parameters are set correctly

  • set ansinull – on

  • set arithabort – on

  • set arithignore – off

  • set string_rtruncation – on

  1. Use create precomputed result set to create precomputed result sets.
  2. To use precomputed result sets for your queries, issue the set materialized_view_optimization command for the session.