Partition Option Benchmarks
The natural question is which of these many techniques is best? Well, that all depends. You must weigh the options with regard to the nature of your data. What works best in one case may not work at all in another. That said, here's what I found on the 7-Eleven data warehouse (shown in Table 8-1).
Fact Implementation | Timing |
---|---|
Non-Partitioned Table | 9,293 |
Range Partitioned Table | 4,747 |
Multi-Column Range Partitioned Table | 4,987 |
Range-Hash Partitioned Table | 6,319 |
Range-List Partitioned Table | 4,820 |
Non-Partitioned IOT[1] | 12,508 |
Range Partitioned IOT | 14,902 |
[1] IOT stands for index organized table. This is a table in Oracle where both the table and its index are ...
Get Oracle® DBA Guide to Data Warehousing and Star Schemas now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.