• Based on me, When we have FK constraint on Fact tables then mostly we use in join to get the DimTable data in any report or DW Cubes(in DW world).

    So always the Index help on FK columns help for better performance.

    Also, We don't need to create the index on FK blindly, but if you see the FK is used much in join's then we can have noncluster.