The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
19 views

How do I stop views (large data sets) from freezing my database

I am working with tables that contain upwards of 200,000 rows. My boss wants to use views that refer to other views in order to have things be more automated. The problem is that the MySQL server ...
0
votes
0answers
27 views

Database dependency problem

Hi I have a small question. I need some suggestions on how to solve this problem. I have database A,B,C,D. D access data from A,B,C in all environments (DEV,UAT,PROD). SO whenever database A,B,C get ...
1
vote
1answer
847 views

Immediate refresh materialized views (MQT) with OUTER JOIN under DB2

DB2 accepts a materialized view based on an "OUTER JOIN" query, as long it doesn't refresh automatically (REFRESH IMMEDIATE). I cannot find a simple solution to get round this problem. Perhaps with ...
1
vote
1answer
507 views

Materialized view log not updating

Under what conditions would a materialized view log not update? I must be missing something. I've got a 10gR2 database. I can create the following MV logs: CREATE MATERIALIZED VIEW LOG ON linked_t1 ...