Home » Server Options » Replication » Complex View: How to convert into Materialized view
Complex View: How to convert into Materialized view [message #60222] Mon, 26 January 2004 04:15 Go to next message
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

 
Re: Complex View: How to convert into Materialized view [message #60234 is a reply to message #60222] Mon, 26 January 2004 22:45 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

You can solve this problem by creating several materialized views on the required base tables. After that, create your view on top of the materialized views.

Best regards.

Frank
Previous Topic: Updating table connected to materialized view
Next Topic: Advanced Queing
Goto Forum:
  


Current Time: Fri Mar 29 09:53:30 CDT 2024