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.
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

Previous Topic: Setup a refresh group for nested materialized views
Next Topic: Materialized view
Goto Forum:
  


Current Time: Thu Mar 28 05:48:13 CDT 2024