Settings within Microstrategy to influence SQL generation to effect specific behavior. Optimizations, alternate sql generation requirements. Can be set at Database Instance, Report, and/or Metric level. Here's an example - "Holding" of results from MicroStrategy intermediate SQL passes can be done in temp tables, or some databases (Teradata for one) allow use of subquery, avoiding drawback of overhead of opening and closing temp table. So global (database instance setting) could be set to use subquery,