Share 'Oracle Materialized Views Vs Replication on the same DB server'
We need to run reports at a scheduled time of the day. The application runs 24*7 and so there is not "off-peak" time as such.
Therefore, running the reports should not add undue load on the system.
The application runs on WebSphere v6.1 and the database is Oracle 10g R2.
I have the following approaches at my disposal
A set of de-normalized tables aimed at reporting.
Creating Materialized views a…
You can share this discussion in two ways…
Share this link:
Send it with your computer's email program: Email this