For performance tuning there some areas where you need to look and work accordingly.

like

1) is there sufficient space so that MSTR can create temporary tables.

2)proper filtering condition.

3)proper joining between required tables.

4) VLDB property

5)optimization (manual, logical and global)

its better if go go in the same order....