Microstrategy Analytics

Order of tables appear in the SQL generated by the MicroStrategy Most latest generation databases provide the same performance regardless of the order in which the tables are placed in the FROM clause SQL query. Their optimizers take care of choosing the most efficient way of performing the joins. Other databases perform differently producing a different order. This means that a database compiler may choose a different join path that can be more or less efficient. By default, the MicroStrategy SQL Generation Engine orders the tables in the following way: Fact Tables Metric Qualification (MQ) Tables Relationship Tables Lookup Tables But this behavior can be changed by using the 'From Clause Order' VLDB property under the 'Joins' folder. This setting has four values: Below are the values that the setting may have: Normal FROM clause order as generated by the engine This is the default value. It uses the foll...