TAGS /

Partitioning

2 tagged articles
DWH Partitioning: When 3 Years of Data Weigh Too Much
Data Warehouse

DWH Partitioning: When 3 Years of Data Weigh Too Much

Range partitioning on an 800-million-row fact table: from 12-minute quarterly queries to 40 seconds. Monthly implementation, exchange and local indexes.

7 April 2026 10 min
Oracle Partitioning: when 2 billion rows no longer fit in a query
Oracle

Oracle Partitioning: when 2 billion rows no longer fit in a query

Oracle Partitioning on a 2-billion-row table: range, interval, partition pruning, local indexes. From hours to seconds on reporting queries.

23 December 2025 12 min