Performance Tuning   «Prev 

Materialized View Procedures

The RECOMMEND_MV procedure creates a table of recommended materialized views based on the statistics for the database collected with the ANALYZE command

The RECOMMEND_MV_W procedure creates a table of recommended materialized views based on the statistics for the database collected with the ANALYZE command and the specific workload for the database gathered in a trace file

The REFRESH_ALL_MVIEWS procedure refreshes all materialized views that need refreshing

The REFRESH_DEPENDENT procedure refreshes all materialized views in the databsae that need refreshing and that are based on a particular base table