Complex View: How to convert into Materialized view [message #60222] |
Mon, 26 January 2004 04:15 |
Vinny75
Messages: 44 Registered: October 2003
|
Member |
|
|
Folks,
we have a very complex view that gets executed every night and takes nearly 3 hours to complete. The view has several outer joins, decodes, NVLs and subqueries referencing several tables. I understand we cannot convert complex view into Fast Refereshed Materialized view. Has anyone come up with an alternative approach?
I would like to see this view fast Refreshed and not take 3 hours to do complete refresh. Any suggestions?
Thanks
|
|
|
|