Home » Server Options » Replication » Materialized Views
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 2070 times)
Previous Topic: session blocked after network failure
Next Topic: Materialized views
Goto Forum:
  


Current Time: Thu Mar 28 05:59:38 CDT 2024