Home » Server Options » Replication » materialized view logs
materialized view logs [message #153095] Thu, 29 December 2005 00:48
mila82
Messages: 4
Registered: December 2005
Location: Down Under
Junior Member
ppl

i created a post earlier in regards to refreshing a materialized view. i saw that i am able to do a refresh fast on my materialized view but you have to have a materialized view log ...
and does anyone know if a refresh fast copies all of the data from the master tables or does it only copy the new entries ??

my question is: i have to do an update on 27 tables ...
so i have to create 27 logs on each of the master tables ...

does this somehow affect performance ... ??

is there a better way to do it ??

is it possible to create a materialized view without the refresh option - never - and create a trigger which would update the materialized view ... ( if i was to create a trigger, you would apply the trigger on all 27 tables, RIGHT ??? )

help would be appreciated ...

merry xmas and a good slide into the new year ...

cheers
mila
Previous Topic: Data Population
Next Topic: Materialized View Refresh Problem
Goto Forum:
  


Current Time: Sun Jan 17 10:38:46 CST 2021