
3.2 Star Queries and Star Query Transformations 67
Chapter 3
rows read from fact table bitmap indexes are dependant on filter-
ing requirements applied to dimension tables.
3. Filtered, dimension Cartesian joined rows are joined to the bit-
map resulting row set of the fact table.
4. The final step is reading actual table rows from the fact table
using the resulting fact-bitmap to dimension-ROWID join,
shown as a nested loop join in Figure 3.10. In Figure 3.10 SALE
fact table rows are accessed using the fact table ROWID values
found in the previously executed steps.
In Figure 3.10 the star transformation query reads and filters each
dimension, Cartesian joins ...