Tag Archive

Materialized View Maintenance – Part I: Guidelines

Published on January 15, 2011 By Ignacio de la Torre

I have been working with a lot of materialized views in our PeopleSoft Campus Solutions Warehouse lately and let me tell you, they can be a pain some times. Before I go into technical details here are some best practices that we have developed in our environment for data that is loaded once nightly.