GS_MATVIEW_DEPENDENCY
GS_MATVIEW_DEPENDENCY provides association information about each fast-refresh materialized view, base table, and Mlog table in the database. The Mlog table corresponding to the base table does not exist in the complete-refresh materialized view. Therefore, no record is written into the Mlog table.
Table 1 GS_MATVIEW_DEPENDENCY columns
OID of a Mlog table which is the log table of a materialized view. Each Mlog table corresponds to one base table. | ||
Feedback