Microstrategy Performance Tuning
We have different options to make MSTR to write a better query and again it is depends on your business logic. Here I am giving few useful and handy options which improves MSTR query and its performance. Few VLDB settings which are helpful to write better query with respect to different scenarios: Select/Insert --> Attribute Form Selection --> change to select ID and other forms -this might prevent some of the lookup table joins if all information are already in the temp tables. Might not work if you have outer join settings in final pass Select/Insert --> Attribute Selection Option --> change to select other attributes in join tree - this might again diminish the amount of joins in the final pass Query Optimization --> Additional Final Pass --> change to have one additional pass for lkp tables only - this might split your final join and make it easier for SQL server Lookup Table Join Order --> change to "Fully ..." - this might change the