View vs Materialized View
Seyed_GJan 13 2011 — edited Jan 14 2011Hi all,
We are running Oracle 10g. Our customer requires data elements from 7 tables and 1 view. Each of these tables has any where between 26 to 97 million rows. I hesitated to build a materialized view in order to save disk space and system resources. But, now, I am considering building a materialized view with several indexes.
My question is should I totally drop the idea of building our customer a view in favor of an indexed materialized view that would be refreshed nightly? As large as these tables are, I don’t know that refreshing the MV nightly would be feasible.
Thank you,
Seyed