| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
