KB38647: Recommended VLDB Properties for use of MicroStrategy 9 with Hive 0.7x

• Strategy

The recommended VLDB optimizations for Hive 0.7x are listed below. These values are set by default when the "Hive 0.7x" database object is used (set at Configuration Managers > Database Instances > Database Instance > Database connection type).
Selected Default VLDB Properties for Hive 0.7x

1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION	1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION	1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION
1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION	1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION	1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION
1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION	1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION	1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION
1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION	1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION	1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION
1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION	1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION	1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION
1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION	1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION	1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION
1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION	1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION	1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION
1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION	1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION	1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION
1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION	1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION	1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION
1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION	1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION	1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION
1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION	1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION	1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION
1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION	1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION	1. Perform cross-tabbing] Tables Fallback Table Type Permanent Table Tables Maximum SQL Passes Before FallBack 0 (no threshold) Tables Maximum Tables in FROM Clause Before FallBack 0 (no threshold) Tables Drop Temp Table Method Drop after final pass Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type Use Temporary Table, falling back to IN (SELECT COL) for correlated subquery Joins Full Outer Join Support Support Select/Insert Distinct/Group By option (when no aggregation and not table key) Use GROUP BY Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different Where Query Optimizations Set Operator Optimization Disabled Joins Join Type Join 92 Select/Insert UNION Multiple Insert Use UNION

Third Party Software Installation WARNING
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.

Comment

0 comments

Details

Knowledge Article

Published:

May 30, 2017

Last Updated:

May 30, 2017