The Strategy Technical Support Team
Diamond GatewayParameters Number LimitationReferenceAmazon RedshiftN/ADocumentation regarding the limitation in Redshift has not been found. Testing shows it works for 3000 parameters. IBM Db216000https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_limits.htmlAzure Synapse Analytics2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Microsoft SQL Server2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Oracle1000https://www.ibm.com/support/pages/ora-01795-maximum-number-expressions-list-1000-0Teradata2536https://docs.teradata.com/reader/bBJcqMYyoxECDlJRAz9Dgw/ZmMJSlE91qowaUXxYi52wwHierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8YearDollar_Sales_Promotion199935000200045386DateDollar_Sales02-05-1999236502-06-20005326 Tables Intermediate Table Type True temporary table Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type WHERE (col1, col2) in (SELECT s1.col1, s1.col2…) Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different WHERE Query Optimizations Set Operator Optimization Enable set operator optimization Select/Insert GROUP BY Non-ID Attribute Use Group By Tables Intermediate Table Type Permanent table Tables Table Qualifier GLOBAL TEMPORARY Tables Table Space ON COMMIT PRESERVE ROWS Tables Drop Temp Table Method Truncate table, then drop after final pass Select/Insert UNION Multiple INSERT Use UNION Pre/Post Statements Table Post Statement DBMS_STATS.GATHER_TABLE_STATS(‘schema’, ‘???’) | The Strategy Technical Support Team
Diamond GatewayParameters Number LimitationReferenceAmazon RedshiftN/ADocumentation regarding the limitation in Redshift has not been found. Testing shows it works for 3000 parameters. IBM Db216000https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_limits.htmlAzure Synapse Analytics2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Microsoft SQL Server2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Oracle1000https://www.ibm.com/support/pages/ora-01795-maximum-number-expressions-list-1000-0Teradata2536https://docs.teradata.com/reader/bBJcqMYyoxECDlJRAz9Dgw/ZmMJSlE91qowaUXxYi52wwHierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8YearDollar_Sales_Promotion199935000200045386DateDollar_Sales02-05-1999236502-06-20005326 Tables Intermediate Table Type True temporary table Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type WHERE (col1, col2) in (SELECT s1.col1, s1.col2…) Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different WHERE Query Optimizations Set Operator Optimization Enable set operator optimization Select/Insert GROUP BY Non-ID Attribute Use Group By Tables Intermediate Table Type Permanent table Tables Table Qualifier GLOBAL TEMPORARY Tables Table Space ON COMMIT PRESERVE ROWS Tables Drop Temp Table Method Truncate table, then drop after final pass Select/Insert UNION Multiple INSERT Use UNION Pre/Post Statements Table Post Statement DBMS_STATS.GATHER_TABLE_STATS(‘schema’, ‘???’) | The Strategy Technical Support Team
Diamond GatewayParameters Number LimitationReferenceAmazon RedshiftN/ADocumentation regarding the limitation in Redshift has not been found. Testing shows it works for 3000 parameters. IBM Db216000https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_limits.htmlAzure Synapse Analytics2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Microsoft SQL Server2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Oracle1000https://www.ibm.com/support/pages/ora-01795-maximum-number-expressions-list-1000-0Teradata2536https://docs.teradata.com/reader/bBJcqMYyoxECDlJRAz9Dgw/ZmMJSlE91qowaUXxYi52wwHierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8YearDollar_Sales_Promotion199935000200045386DateDollar_Sales02-05-1999236502-06-20005326 Tables Intermediate Table Type True temporary table Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type WHERE (col1, col2) in (SELECT s1.col1, s1.col2…) Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different WHERE Query Optimizations Set Operator Optimization Enable set operator optimization Select/Insert GROUP BY Non-ID Attribute Use Group By Tables Intermediate Table Type Permanent table Tables Table Qualifier GLOBAL TEMPORARY Tables Table Space ON COMMIT PRESERVE ROWS Tables Drop Temp Table Method Truncate table, then drop after final pass Select/Insert UNION Multiple INSERT Use UNION Pre/Post Statements Table Post Statement DBMS_STATS.GATHER_TABLE_STATS(‘schema’, ‘???’) |
The Strategy Technical Support Team
Diamond GatewayParameters Number LimitationReferenceAmazon RedshiftN/ADocumentation regarding the limitation in Redshift has not been found. Testing shows it works for 3000 parameters. IBM Db216000https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_limits.htmlAzure Synapse Analytics2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Microsoft SQL Server2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Oracle1000https://www.ibm.com/support/pages/ora-01795-maximum-number-expressions-list-1000-0Teradata2536https://docs.teradata.com/reader/bBJcqMYyoxECDlJRAz9Dgw/ZmMJSlE91qowaUXxYi52wwHierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8YearDollar_Sales_Promotion199935000200045386DateDollar_Sales02-05-1999236502-06-20005326 Tables Intermediate Table Type True temporary table Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type WHERE (col1, col2) in (SELECT s1.col1, s1.col2…) Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different WHERE Query Optimizations Set Operator Optimization Enable set operator optimization Select/Insert GROUP BY Non-ID Attribute Use Group By Tables Intermediate Table Type Permanent table Tables Table Qualifier GLOBAL TEMPORARY Tables Table Space ON COMMIT PRESERVE ROWS Tables Drop Temp Table Method Truncate table, then drop after final pass Select/Insert UNION Multiple INSERT Use UNION Pre/Post Statements Table Post Statement DBMS_STATS.GATHER_TABLE_STATS(‘schema’, ‘???’) | The Strategy Technical Support Team
Diamond GatewayParameters Number LimitationReferenceAmazon RedshiftN/ADocumentation regarding the limitation in Redshift has not been found. Testing shows it works for 3000 parameters. IBM Db216000https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_limits.htmlAzure Synapse Analytics2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Microsoft SQL Server2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Oracle1000https://www.ibm.com/support/pages/ora-01795-maximum-number-expressions-list-1000-0Teradata2536https://docs.teradata.com/reader/bBJcqMYyoxECDlJRAz9Dgw/ZmMJSlE91qowaUXxYi52wwHierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8YearDollar_Sales_Promotion199935000200045386DateDollar_Sales02-05-1999236502-06-20005326 Tables Intermediate Table Type True temporary table Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type WHERE (col1, col2) in (SELECT s1.col1, s1.col2…) Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different WHERE Query Optimizations Set Operator Optimization Enable set operator optimization Select/Insert GROUP BY Non-ID Attribute Use Group By Tables Intermediate Table Type Permanent table Tables Table Qualifier GLOBAL TEMPORARY Tables Table Space ON COMMIT PRESERVE ROWS Tables Drop Temp Table Method Truncate table, then drop after final pass Select/Insert UNION Multiple INSERT Use UNION Pre/Post Statements Table Post Statement DBMS_STATS.GATHER_TABLE_STATS(‘schema’, ‘???’) | The Strategy Technical Support Team
Diamond GatewayParameters Number LimitationReferenceAmazon RedshiftN/ADocumentation regarding the limitation in Redshift has not been found. Testing shows it works for 3000 parameters. IBM Db216000https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_limits.htmlAzure Synapse Analytics2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Microsoft SQL Server2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Oracle1000https://www.ibm.com/support/pages/ora-01795-maximum-number-expressions-list-1000-0Teradata2536https://docs.teradata.com/reader/bBJcqMYyoxECDlJRAz9Dgw/ZmMJSlE91qowaUXxYi52wwHierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8YearDollar_Sales_Promotion199935000200045386DateDollar_Sales02-05-1999236502-06-20005326 Tables Intermediate Table Type True temporary table Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type WHERE (col1, col2) in (SELECT s1.col1, s1.col2…) Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different WHERE Query Optimizations Set Operator Optimization Enable set operator optimization Select/Insert GROUP BY Non-ID Attribute Use Group By Tables Intermediate Table Type Permanent table Tables Table Qualifier GLOBAL TEMPORARY Tables Table Space ON COMMIT PRESERVE ROWS Tables Drop Temp Table Method Truncate table, then drop after final pass Select/Insert UNION Multiple INSERT Use UNION Pre/Post Statements Table Post Statement DBMS_STATS.GATHER_TABLE_STATS(‘schema’, ‘???’) |
The Strategy Technical Support Team
Diamond GatewayParameters Number LimitationReferenceAmazon RedshiftN/ADocumentation regarding the limitation in Redshift has not been found. Testing shows it works for 3000 parameters. IBM Db216000https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_limits.htmlAzure Synapse Analytics2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Microsoft SQL Server2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Oracle1000https://www.ibm.com/support/pages/ora-01795-maximum-number-expressions-list-1000-0Teradata2536https://docs.teradata.com/reader/bBJcqMYyoxECDlJRAz9Dgw/ZmMJSlE91qowaUXxYi52wwHierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8YearDollar_Sales_Promotion199935000200045386DateDollar_Sales02-05-1999236502-06-20005326 Tables Intermediate Table Type True temporary table Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type WHERE (col1, col2) in (SELECT s1.col1, s1.col2…) Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different WHERE Query Optimizations Set Operator Optimization Enable set operator optimization Select/Insert GROUP BY Non-ID Attribute Use Group By Tables Intermediate Table Type Permanent table Tables Table Qualifier GLOBAL TEMPORARY Tables Table Space ON COMMIT PRESERVE ROWS Tables Drop Temp Table Method Truncate table, then drop after final pass Select/Insert UNION Multiple INSERT Use UNION Pre/Post Statements Table Post Statement DBMS_STATS.GATHER_TABLE_STATS(‘schema’, ‘???’) | The Strategy Technical Support Team
Diamond GatewayParameters Number LimitationReferenceAmazon RedshiftN/ADocumentation regarding the limitation in Redshift has not been found. Testing shows it works for 3000 parameters. IBM Db216000https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_limits.htmlAzure Synapse Analytics2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Microsoft SQL Server2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Oracle1000https://www.ibm.com/support/pages/ora-01795-maximum-number-expressions-list-1000-0Teradata2536https://docs.teradata.com/reader/bBJcqMYyoxECDlJRAz9Dgw/ZmMJSlE91qowaUXxYi52wwHierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8YearDollar_Sales_Promotion199935000200045386DateDollar_Sales02-05-1999236502-06-20005326 Tables Intermediate Table Type True temporary table Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type WHERE (col1, col2) in (SELECT s1.col1, s1.col2…) Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different WHERE Query Optimizations Set Operator Optimization Enable set operator optimization Select/Insert GROUP BY Non-ID Attribute Use Group By Tables Intermediate Table Type Permanent table Tables Table Qualifier GLOBAL TEMPORARY Tables Table Space ON COMMIT PRESERVE ROWS Tables Drop Temp Table Method Truncate table, then drop after final pass Select/Insert UNION Multiple INSERT Use UNION Pre/Post Statements Table Post Statement DBMS_STATS.GATHER_TABLE_STATS(‘schema’, ‘???’) | The Strategy Technical Support Team
Diamond GatewayParameters Number LimitationReferenceAmazon RedshiftN/ADocumentation regarding the limitation in Redshift has not been found. Testing shows it works for 3000 parameters. IBM Db216000https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_limits.htmlAzure Synapse Analytics2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Microsoft SQL Server2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Oracle1000https://www.ibm.com/support/pages/ora-01795-maximum-number-expressions-list-1000-0Teradata2536https://docs.teradata.com/reader/bBJcqMYyoxECDlJRAz9Dgw/ZmMJSlE91qowaUXxYi52wwHierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8YearDollar_Sales_Promotion199935000200045386DateDollar_Sales02-05-1999236502-06-20005326 Tables Intermediate Table Type True temporary table Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type WHERE (col1, col2) in (SELECT s1.col1, s1.col2…) Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different WHERE Query Optimizations Set Operator Optimization Enable set operator optimization Select/Insert GROUP BY Non-ID Attribute Use Group By Tables Intermediate Table Type Permanent table Tables Table Qualifier GLOBAL TEMPORARY Tables Table Space ON COMMIT PRESERVE ROWS Tables Drop Temp Table Method Truncate table, then drop after final pass Select/Insert UNION Multiple INSERT Use UNION Pre/Post Statements Table Post Statement DBMS_STATS.GATHER_TABLE_STATS(‘schema’, ‘???’) |
The Strategy Technical Support Team
Diamond GatewayParameters Number LimitationReferenceAmazon RedshiftN/ADocumentation regarding the limitation in Redshift has not been found. Testing shows it works for 3000 parameters. IBM Db216000https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_limits.htmlAzure Synapse Analytics2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Microsoft SQL Server2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Oracle1000https://www.ibm.com/support/pages/ora-01795-maximum-number-expressions-list-1000-0Teradata2536https://docs.teradata.com/reader/bBJcqMYyoxECDlJRAz9Dgw/ZmMJSlE91qowaUXxYi52wwHierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8YearDollar_Sales_Promotion199935000200045386DateDollar_Sales02-05-1999236502-06-20005326 Tables Intermediate Table Type True temporary table Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type WHERE (col1, col2) in (SELECT s1.col1, s1.col2…) Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different WHERE Query Optimizations Set Operator Optimization Enable set operator optimization Select/Insert GROUP BY Non-ID Attribute Use Group By Tables Intermediate Table Type Permanent table Tables Table Qualifier GLOBAL TEMPORARY Tables Table Space ON COMMIT PRESERVE ROWS Tables Drop Temp Table Method Truncate table, then drop after final pass Select/Insert UNION Multiple INSERT Use UNION Pre/Post Statements Table Post Statement DBMS_STATS.GATHER_TABLE_STATS(‘schema’, ‘???’) | The Strategy Technical Support Team
Diamond GatewayParameters Number LimitationReferenceAmazon RedshiftN/ADocumentation regarding the limitation in Redshift has not been found. Testing shows it works for 3000 parameters. IBM Db216000https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_limits.htmlAzure Synapse Analytics2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Microsoft SQL Server2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Oracle1000https://www.ibm.com/support/pages/ora-01795-maximum-number-expressions-list-1000-0Teradata2536https://docs.teradata.com/reader/bBJcqMYyoxECDlJRAz9Dgw/ZmMJSlE91qowaUXxYi52wwHierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8YearDollar_Sales_Promotion199935000200045386DateDollar_Sales02-05-1999236502-06-20005326 Tables Intermediate Table Type True temporary table Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type WHERE (col1, col2) in (SELECT s1.col1, s1.col2…) Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different WHERE Query Optimizations Set Operator Optimization Enable set operator optimization Select/Insert GROUP BY Non-ID Attribute Use Group By Tables Intermediate Table Type Permanent table Tables Table Qualifier GLOBAL TEMPORARY Tables Table Space ON COMMIT PRESERVE ROWS Tables Drop Temp Table Method Truncate table, then drop after final pass Select/Insert UNION Multiple INSERT Use UNION Pre/Post Statements Table Post Statement DBMS_STATS.GATHER_TABLE_STATS(‘schema’, ‘???’) | The Strategy Technical Support Team
Diamond GatewayParameters Number LimitationReferenceAmazon RedshiftN/ADocumentation regarding the limitation in Redshift has not been found. Testing shows it works for 3000 parameters. IBM Db216000https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_limits.htmlAzure Synapse Analytics2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Microsoft SQL Server2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Oracle1000https://www.ibm.com/support/pages/ora-01795-maximum-number-expressions-list-1000-0Teradata2536https://docs.teradata.com/reader/bBJcqMYyoxECDlJRAz9Dgw/ZmMJSlE91qowaUXxYi52wwHierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8YearDollar_Sales_Promotion199935000200045386DateDollar_Sales02-05-1999236502-06-20005326 Tables Intermediate Table Type True temporary table Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type WHERE (col1, col2) in (SELECT s1.col1, s1.col2…) Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different WHERE Query Optimizations Set Operator Optimization Enable set operator optimization Select/Insert GROUP BY Non-ID Attribute Use Group By Tables Intermediate Table Type Permanent table Tables Table Qualifier GLOBAL TEMPORARY Tables Table Space ON COMMIT PRESERVE ROWS Tables Drop Temp Table Method Truncate table, then drop after final pass Select/Insert UNION Multiple INSERT Use UNION Pre/Post Statements Table Post Statement DBMS_STATS.GATHER_TABLE_STATS(‘schema’, ‘???’) |
The Strategy Technical Support Team
Diamond GatewayParameters Number LimitationReferenceAmazon RedshiftN/ADocumentation regarding the limitation in Redshift has not been found. Testing shows it works for 3000 parameters. IBM Db216000https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_limits.htmlAzure Synapse Analytics2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Microsoft SQL Server2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Oracle1000https://www.ibm.com/support/pages/ora-01795-maximum-number-expressions-list-1000-0Teradata2536https://docs.teradata.com/reader/bBJcqMYyoxECDlJRAz9Dgw/ZmMJSlE91qowaUXxYi52wwHierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8YearDollar_Sales_Promotion199935000200045386DateDollar_Sales02-05-1999236502-06-20005326 Tables Intermediate Table Type True temporary table Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type WHERE (col1, col2) in (SELECT s1.col1, s1.col2…) Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different WHERE Query Optimizations Set Operator Optimization Enable set operator optimization Select/Insert GROUP BY Non-ID Attribute Use Group By Tables Intermediate Table Type Permanent table Tables Table Qualifier GLOBAL TEMPORARY Tables Table Space ON COMMIT PRESERVE ROWS Tables Drop Temp Table Method Truncate table, then drop after final pass Select/Insert UNION Multiple INSERT Use UNION Pre/Post Statements Table Post Statement DBMS_STATS.GATHER_TABLE_STATS(‘schema’, ‘???’) | The Strategy Technical Support Team
Diamond GatewayParameters Number LimitationReferenceAmazon RedshiftN/ADocumentation regarding the limitation in Redshift has not been found. Testing shows it works for 3000 parameters. IBM Db216000https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_limits.htmlAzure Synapse Analytics2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Microsoft SQL Server2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Oracle1000https://www.ibm.com/support/pages/ora-01795-maximum-number-expressions-list-1000-0Teradata2536https://docs.teradata.com/reader/bBJcqMYyoxECDlJRAz9Dgw/ZmMJSlE91qowaUXxYi52wwHierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8YearDollar_Sales_Promotion199935000200045386DateDollar_Sales02-05-1999236502-06-20005326 Tables Intermediate Table Type True temporary table Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type WHERE (col1, col2) in (SELECT s1.col1, s1.col2…) Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different WHERE Query Optimizations Set Operator Optimization Enable set operator optimization Select/Insert GROUP BY Non-ID Attribute Use Group By Tables Intermediate Table Type Permanent table Tables Table Qualifier GLOBAL TEMPORARY Tables Table Space ON COMMIT PRESERVE ROWS Tables Drop Temp Table Method Truncate table, then drop after final pass Select/Insert UNION Multiple INSERT Use UNION Pre/Post Statements Table Post Statement DBMS_STATS.GATHER_TABLE_STATS(‘schema’, ‘???’) | The Strategy Technical Support Team
Diamond GatewayParameters Number LimitationReferenceAmazon RedshiftN/ADocumentation regarding the limitation in Redshift has not been found. Testing shows it works for 3000 parameters. IBM Db216000https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_limits.htmlAzure Synapse Analytics2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Microsoft SQL Server2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Oracle1000https://www.ibm.com/support/pages/ora-01795-maximum-number-expressions-list-1000-0Teradata2536https://docs.teradata.com/reader/bBJcqMYyoxECDlJRAz9Dgw/ZmMJSlE91qowaUXxYi52wwHierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8YearDollar_Sales_Promotion199935000200045386DateDollar_Sales02-05-1999236502-06-20005326 Tables Intermediate Table Type True temporary table Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type WHERE (col1, col2) in (SELECT s1.col1, s1.col2…) Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different WHERE Query Optimizations Set Operator Optimization Enable set operator optimization Select/Insert GROUP BY Non-ID Attribute Use Group By Tables Intermediate Table Type Permanent table Tables Table Qualifier GLOBAL TEMPORARY Tables Table Space ON COMMIT PRESERVE ROWS Tables Drop Temp Table Method Truncate table, then drop after final pass Select/Insert UNION Multiple INSERT Use UNION Pre/Post Statements Table Post Statement DBMS_STATS.GATHER_TABLE_STATS(‘schema’, ‘???’) |
The Strategy Technical Support Team
Diamond GatewayParameters Number LimitationReferenceAmazon RedshiftN/ADocumentation regarding the limitation in Redshift has not been found. Testing shows it works for 3000 parameters. IBM Db216000https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_limits.htmlAzure Synapse Analytics2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Microsoft SQL Server2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Oracle1000https://www.ibm.com/support/pages/ora-01795-maximum-number-expressions-list-1000-0Teradata2536https://docs.teradata.com/reader/bBJcqMYyoxECDlJRAz9Dgw/ZmMJSlE91qowaUXxYi52wwHierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8YearDollar_Sales_Promotion199935000200045386DateDollar_Sales02-05-1999236502-06-20005326 Tables Intermediate Table Type True temporary table Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type WHERE (col1, col2) in (SELECT s1.col1, s1.col2…) Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different WHERE Query Optimizations Set Operator Optimization Enable set operator optimization Select/Insert GROUP BY Non-ID Attribute Use Group By Tables Intermediate Table Type Permanent table Tables Table Qualifier GLOBAL TEMPORARY Tables Table Space ON COMMIT PRESERVE ROWS Tables Drop Temp Table Method Truncate table, then drop after final pass Select/Insert UNION Multiple INSERT Use UNION Pre/Post Statements Table Post Statement DBMS_STATS.GATHER_TABLE_STATS(‘schema’, ‘???’) | The Strategy Technical Support Team
Diamond GatewayParameters Number LimitationReferenceAmazon RedshiftN/ADocumentation regarding the limitation in Redshift has not been found. Testing shows it works for 3000 parameters. IBM Db216000https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_limits.htmlAzure Synapse Analytics2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Microsoft SQL Server2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Oracle1000https://www.ibm.com/support/pages/ora-01795-maximum-number-expressions-list-1000-0Teradata2536https://docs.teradata.com/reader/bBJcqMYyoxECDlJRAz9Dgw/ZmMJSlE91qowaUXxYi52wwHierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8YearDollar_Sales_Promotion199935000200045386DateDollar_Sales02-05-1999236502-06-20005326 Tables Intermediate Table Type True temporary table Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type WHERE (col1, col2) in (SELECT s1.col1, s1.col2…) Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different WHERE Query Optimizations Set Operator Optimization Enable set operator optimization Select/Insert GROUP BY Non-ID Attribute Use Group By Tables Intermediate Table Type Permanent table Tables Table Qualifier GLOBAL TEMPORARY Tables Table Space ON COMMIT PRESERVE ROWS Tables Drop Temp Table Method Truncate table, then drop after final pass Select/Insert UNION Multiple INSERT Use UNION Pre/Post Statements Table Post Statement DBMS_STATS.GATHER_TABLE_STATS(‘schema’, ‘???’) | The Strategy Technical Support Team
Diamond GatewayParameters Number LimitationReferenceAmazon RedshiftN/ADocumentation regarding the limitation in Redshift has not been found. Testing shows it works for 3000 parameters. IBM Db216000https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/sqlref/src/tpc/db2z_limits.htmlAzure Synapse Analytics2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Microsoft SQL Server2100https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15Oracle1000https://www.ibm.com/support/pages/ora-01795-maximum-number-expressions-list-1000-0Teradata2536https://docs.teradata.com/reader/bBJcqMYyoxECDlJRAz9Dgw/ZmMJSlE91qowaUXxYi52wwHierarchyAttributeLevel in HierarchyWeight1A11/3 * 10 = 3.33B22/3 * 10 = 6.66C11/3 * 10 = 3.33D33/3 * 10 = 102E11/4 * 10 = 2.5F22/4 * 10 = 5G33/4 * 10 = 7.5H44/4 * 10 = 10TableAttribute IDsLogical Table SizeLU_AAROUND(3.33) = 3LU_BA, BROUND(3.33 + 6.66) = 10LU_CCROUND(3.33) = 3LU_DA, B, C, DROUND(3.33 + 6.66 + 3.33 + 10) = 23LU_EEROUND(2.5) = 2LU_FE, FROUND(2.5 + 5) = 7LU_GF, GROUND(5 + 7.5) = 12LU_HG, HROUND(7.5 + 10) = 17F1A, B, C, D, E, F, G, HROUND(3.33 + 6.66 + 3.33 + 10 + 2.5 + 5 + 7 + 7.5 + 10) = 55F2D, HROUND(10 + 10) = 20F3A, FROUND(5 + 3.33) = 8YearDollar_Sales_Promotion199935000200045386DateDollar_Sales02-05-1999236502-06-20005326 Tables Intermediate Table Type True temporary table Tables Table Creation Type Implicit Table Query Optimizations Sub Query Type WHERE (col1, col2) in (SELECT s1.col1, s1.col2…) Query Optimizations SQL Global Optimization Level 4: Level 2 + Merge All Passes with Different WHERE Query Optimizations Set Operator Optimization Enable set operator optimization Select/Insert GROUP BY Non-ID Attribute Use Group By Tables Intermediate Table Type Permanent table Tables Table Qualifier GLOBAL TEMPORARY Tables Table Space ON COMMIT PRESERVE ROWS Tables Drop Temp Table Method Truncate table, then drop after final pass Select/Insert UNION Multiple INSERT Use UNION Pre/Post Statements Table Post Statement DBMS_STATS.GATHER_TABLE_STATS(‘schema’, ‘???’) |
