Materialized Views [message #213929] |
Fri, 12 January 2007 16:35 |
cptkirkh
Messages: 1 Registered: January 2007
|
Junior Member |
|
|
I would like to create a MV to solve a problem with a query we have. The query is quote large and full of aggregrates and outer joins. I have a few questions to ask if I may. One what is the best practice for refresh on the query I have attached? I would prefer to use on commit to always have an update version to query off of for the users. IF I need to create MV logs do what columns do I add from the source table for the log? Should I put these logs in their tablespace. Also if a function is called from within the select statement in the query do I need MV logs for the tables that the functions call from within the function themselves?
-
Attachment: MV query.sql
(Size: 6.48KB, Downloaded 2123 times)
|
|
|