Database materialised views - are you using them?
Posted: Thu Sep 29, 2005 6:30 pm
Are you using materialised views? What do you like about them?
Our project is considering using DB2 materialised views for reports instead of queries against tables. One particular features looks very useful, the ability to freeze the view to a snapshot even when the underlying tables are being updated, and then refreshing the view with a command when the loads are complete. Might also be good for rollback of failed ETL jobs.
Our project is considering using DB2 materialised views for reports instead of queries against tables. One particular features looks very useful, the ability to freeze the view to a snapshot even when the underlying tables are being updated, and then refreshing the view with a command when the loads are complete. Might also be good for rollback of failed ETL jobs.