O'Reilly logo

Oracle® DBA Guide to Data Warehousing and Star Schemas by Bert Scalzo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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).

Table 8-1. Performance Charcteristics for Various Table Implementation Options
Fact ImplementationTiming
Non-Partitioned Table9,293
Range Partitioned Table4,747
Multi-Column Range Partitioned Table4,987
Range-Hash Partitioned Table6,319
Range-List Partitioned Table4,820
Non-Partitioned IOT[1]12,508
Range Partitioned IOT14,902

[1] IOT stands for index organized table. This is a table in Oracle where both the table and its index are ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required