Method and mechanism of materialized view mix incremental refresh
A method and system for updating both partition change track tables and non-partition track tables in a materialized view. A log-based incremental refresh is performed on the materialized view and a partition change tracking based refresh is performed on the materialized view. The dependency of the...
Saved in:
| Main Author | |
|---|---|
| Format | Patent |
| Language | English |
| Published |
22.02.2011
|
| Online Access | Get full text |
Cover
Loading…
| Summary: | A method and system for updating both partition change track tables and non-partition track tables in a materialized view. A log-based incremental refresh is performed on the materialized view and a partition change tracking based refresh is performed on the materialized view. The dependency of the materialized view log for the partition change track base table is removed. |
|---|