For those of you who have been working with MQT's. have you experienced any issues with doing REFRESH IMMEDIATE? Please take in consideration that we would be updating base tables once a day on the middle of the night at the down time 98% of the time.

8.2 aix 5.1

REFRESH IMMEDIATE is an overhead .. How much, depends on the MQT Definition ..

Why not try this :

Define the MQT as REFRESH IMMEDIATE .. This ensures that Static SQLs also can make use of the immediate updates
Before the night build, alter table drop the mqt definition ..
After the build, create the MQT definition ...
REFRESH the table

Cheers
Sathyaram

Thank you Sathyaram