I was reading the performance manual section on the STAR hint and it said that this works best if you have a concatenated index on the fact table of your data warehouse.
This surprised me as I'd always thought concatenated indexes were frowned on in data warehousing. I thought you are supposed to use lots of single (preferably bitmap) indexes on the fact table. Does anyone actually find a benefit in creating concatenated indexes ?
