As with most database solutions, the most appropriate answer would be 'depends on the scenario'. Usually, I would create indexes on the fact tables in a star schema as there would be queries running against them for reporting involving SQL Joins whic...