Data Warehouse Best Practices(2) -- Optimizing Star Queries

--From Oracle DW Best Practices White Paper

Two most important criteria are:

1. Create a BITMAP index on each of the foreign key columns in the fact table or tables

2. Set the init parameter STAR_TRANSFORMATION_ENABLE to TRUE. This will enable the optimizer feature for star queries.