Archive for January, 2011

Materialized View Maintenance – Part I: Guidelines

January 15, 2011

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.

Tags: , , , , , ,
Posted in Best Practices, Data Warehousing, Oracle Database, Technical | No Comments »