Materialized View Logs (190)

tsinglee發表於2007-11-12

A materialized view log is a schema object that records changes to a master table’s
data so that a materialized view defined on the master table can be refreshed
incrementally.

Each materialized view log is associated with a single master table. The materialized
view log resides in the same database and schema as its master table.

物化檢視日誌
1. 記錄主表資料變化的方案物件 , 使得定義在主表上的物化檢視能夠增量重新整理
2. 每個物化檢視日誌與一個主表相關 , 與主表位於同一資料庫同一方案

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-981947/,如需轉載,請註明出處,否則將追究法律責任。

相關文章