Members   Search   Help    Register    Login   Home
Home » Server Options » Replication » Sub-query in Materialized Views (Oracle 10.2.0.3)
Sub-query in Materialized Views [message #395567] Wed, 01 April 2009 21:54 Go to next message
summoner
Messages: 27
Registered: March 2009
Junior Member
I have a view with complex query that have grouping and aggregations in sub-queries.

Now we would like to change it to a materialized view. However, materialized view does not support GROUP BY clause in sub-query. Therefore, we would like to ask how we could do in order to solve this problem.

The solution suggested by my boss is to create several view for the sub-queries and then create a materialized view based on it. It seems it can help, but I guest every time complete refresh is required.

I think another approach is to refine the query. Can anyone give me some suggestions on that? It will be great if there are some tools for that.
Report message to a moderator
Re: Sub-query in Materialized Views [message #395641 is a reply to message #395567] Thu, 02 April 2009 02:35 Go to previous message
gentlebabu
Messages: 1382
Registered: December 2005
Location: India, Hyderabad
Senior Member
>>but I guest every time complete refresh is required.

Yes. For complex materialized view you need refresh using "Complete" only..

Babu
Report message to a moderator
Previous Topic:Setup a refresh group for nested materialized views
Next Topic:Materialized view
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 8 22:41:52 CST 2009

Total time taken to generate the page: 25.48339 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.