RelationalDBDesign RelationalDBDesign 


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 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 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_ALL_MVIEWS procedure refreshes all materialized views that need refreshing

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