Before you create or alter precomputed result sets, verify that these session set parameters are set correctly:
set ansinull – on
set arithabort – on
set arithignore – off
set string_rtruncation – on
Use create precomputed result set to create precomputed result sets. To use precomputed result sets for your queries, issue the set materialized_view_optimization command for the session.
