Database tuning: a principled approach
Database tuning: a principled approach
Advanced Oracle Tuning and Administration
Advanced Oracle Tuning and Administration
Oracle Performance Tuning, 2nd Edition
Oracle Performance Tuning, 2nd Edition
Oracle8i Internal Services for Waits, Latches, Locks, and Memory
Oracle8i Internal Services for Waits, Latches, Locks, and Memory
Posse: A Framework for Optimizing Incremental View Maintenance at Data Warehouse
DaWaK '99 Proceedings of the First International Conference on Data Warehousing and Knowledge Discovery
On the Importance of Tuning in Incremental View Maintenance: An Experience Case Study
On the Importance of Tuning in Incremental View Maintenance: An Experience Case Study
Hi-index | 0.00 |
We describe the tuning of a gigabyte-scale TPC-D database for investigation of incremental maintenance of a materialized view. We find that incremental maintenance is feasible over a wide range of update sizes (granularities), that intuitive SQL formulations perform poorly, but that there are better alternatives. We show that these results can be meaningfully evaluated and presented only in the context of reasonable instance tuning.