Supercharging Star Transformations
A star transformation is a methodology used to join tables to greatly improve performance of queries on dimensional data warehouse schemas. Prior to star transformations, the primary join methods available were nested loops, merge, and hash joins. Like many other of the more complex Oracle RDBMS features, star transformations much be properly configured and tuned to optimize their performance.
This paper explains how to take full advantage of this powerful data warehouse feature. Specifically, the author will use a specific dimensional data model to introduce star transformations, illustrate the necessity of bitmap indexes, and show how to configure the database instance to minimize star transformation response time. It covers versions 8.1.7 through 9.2 of the Oracle RDBMS. All of the results in this paper were produced on version 9.2.0.4.
When asked to "Select a payment method" for your free download, choose "Print and Call". Your download code will be e-mailed to you after we authorize it. International customers should enter TruTek's address as the shipping address and enter their real shipping address in the Special Instructions field on the payment screen.
- Author:: Jeff Maresh
- Item #: Paper0008
