开发者

What is PCT for a materialized view?

开发者 https://www.devze.com 2023-01-05 11:15 出处:网络
Saw it in a reference manual. What is PC开发者_如何转开发T for a materialized view? What is \"Partition Change Tracking\"?From the Oracle documentation itself :

Saw it in a reference manual. What is PC开发者_如何转开发T for a materialized view?

What is "Partition Change Tracking"?


From the Oracle documentation itself :

"It is possible and advantageous to track freshness to a finer grain than the entire materialized view. The ability to identify which rows in a materialized view are affected by a certain detail table partition, is known as Partition Change Tracking. When one or more of the detail tables are partitioned, it may be possible to identify the specific rows in the materialized view that correspond to a modified detail partition(s); those rows become stale when a partition is modified while all other rows remain fresh."

0

精彩评论

暂无评论...
验证码 换一张
取 消