Oracle Partitioning: when 2 billion rows no longer fit in a query
A client with a 2-billion-row transaction table and reporting queries that had gone from seconds to hours. How I solved it with Oracle partitioning — range, interval, partition pruning and local indexes.
·12 mins
