Paper “Scaling To Infinity: Partitioning Data Warehouses On Oracle Database”
Star schemas (a.k.a. dimensional data models) are demanded by BI analysts in data marts and data warehouses. Star transformations are the optimal join method to access star schemas in Oracle. Bitmap indexes are required by the star transformation process, but bitmap indexes quickly become literally infeasible without partitioning. Why isn’t this documented? How do all […]