Where do indexes usually go missing in the BW environment with MaxDB?
Indexes are usually missing from master data tables if a selective column that can significantly restrict the result set was qualified in the WHERE clause. Since there is no relation between dimension tables, it can be useful to create a suitable multiple index on the fact table if two restrictions on different dimension tables were specified in the WHERE clause.