This content has been marked as final. Show 4 replies
If you create a materialized view with 10 tables, the performance wonot good.
Better create a view first and then create materiialized view based on that view and then index the materilialized view.
This is best way also.
Edited by: oracle.beginner on Jul 1, 2009 3:44 AM
how changes will be reflected into materialized view then? if changes done on base tables.. refresh rate and etc.? what will be the best way if we create view in between?
Edited by: user612078 on Jul 1, 2009 4:25 AM
Schedule this materilaized view to what frequency of data changes i.e. daily or weekly or monthly.