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: 44
Registered: March 2009
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
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
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: Thu Jan 30 11:44:55 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.