------------------ v1.1.0rc1 result (incorrect) ------------------ SQL>set schema trafodion.g_tpcds1x; --- SQL operation complete. SQL>set param ?q 18; SQL>prepare xx from select [first 200] i_item_id, ca_country, ca_state, ca_county, agg1, agg2, agg3, agg4, agg5, agg6, agg7 from ( select i_item_id, ca_country, ca_state, ca_county, avg(cs_quantity) agg1, avg(cs_list_price) agg2, avg(cs_coupon_amt) agg3, avg(cs_sales_price) agg4, avg(cs_net_profit) agg5, avg(c_birth_year) agg6, avg(cd1.cd_dep_count) agg7 from catalog_sales, customer_demographics cd1, customer_demographics cd2, customer, customer_address, date_dim, item where cs_sold_date_sk = d_date_sk and cs_item_sk = i_item_sk and cs_bill_cdemo_sk = cd1.cd_demo_sk and cs_bill_customer_sk = c_customer_sk and cd1.cd_gender = 'F' and cd1.cd_education_status = 'Primary' and c_current_cdemo_sk = cd2.cd_demo_sk and c_current_addr_sk = ca_address_sk and c_birth_month in (9,4,3,11,1,12) and d_year = 1999 and ca_state in ('VA','NE','MI','WV','WV','CO','IN') group by 1,2,3,4 union all select i_item_id, cast(null as char), ca_state, ca_county, avg(cs_quantity) agg1, avg(cs_list_price) agg2, avg(cs_coupon_amt) agg3, avg(cs_sales_price) agg4, avg(cs_net_profit) agg5, avg(c_birth_year) agg6, avg(cd1.cd_dep_count) agg7 from catalog_sales, customer_demographics cd1, customer_demographics cd2, customer, customer_address, date_dim, item where cs_sold_date_sk = d_date_sk and cs_item_sk = i_item_sk and cs_bill_cdemo_sk = cd1.cd_demo_sk and cs_bill_customer_sk = c_customer_sk and cd1.cd_gender = 'F' and cd1.cd_education_status = 'Primary' and c_current_cdemo_sk = cd2.cd_demo_sk and c_current_addr_sk = ca_address_sk and c_birth_month in (9,4,3,11,1,12) and d_year = 1999 and ca_state in ('VA','NE','MI','WV','WV','CO','IN') group by 1,2,3,4 union all select i_item_id, cast(null as char), cast(null as char), ca_county, avg(cs_quantity) agg1, avg(cs_list_price) agg2, avg(cs_coupon_amt) agg3, avg(cs_sales_price) agg4, avg(cs_net_profit) agg5, avg(c_birth_year) agg6, avg(cd1.cd_dep_count) agg7 from catalog_sales, customer_demographics cd1, customer_demographics cd2, customer, customer_address, date_dim, item where cs_sold_date_sk = d_date_sk and cs_item_sk = i_item_sk and cs_bill_cdemo_sk = cd1.cd_demo_sk and cs_bill_customer_sk = c_customer_sk and cd1.cd_gender = 'F' and cd1.cd_education_status = 'Primary' and c_current_cdemo_sk = cd2.cd_demo_sk and c_current_addr_sk = ca_address_sk and c_birth_month in (9,4,3,11,1,12) and d_year = 1999 and ca_state in ('VA','NE','MI','WV','WV','CO','IN') group by 1,2,3,4 union all select i_item_id, cast(null as char), cast(null as char), cast(null as char), avg(cs_quantity) agg1, avg(cs_list_price) agg2, avg(cs_coupon_amt) agg3, avg(cs_sales_price) agg4, avg(cs_net_profit) agg5, avg(c_birth_year) agg6, avg(cd1.cd_dep_count) agg7 from catalog_sales, customer_demographics cd1, customer_demographics cd2, customer, customer_address, date_dim, item where cs_sold_date_sk = d_date_sk and cs_item_sk = i_item_sk and cs_bill_cdemo_sk = cd1.cd_demo_sk and cs_bill_customer_sk = c_customer_sk and cd1.cd_gender = 'F' and cd1.cd_education_status = 'Primary' and c_current_cdemo_sk = cd2.cd_demo_sk and c_current_addr_sk = ca_address_sk and c_birth_month in (9,4,3,11,1,12) and d_year = 1999 and ca_state in ('VA','NE','MI','WV','WV','CO','IN') group by 1,2,3,4 union all select cast(null as char), cast(null as char), cast(null as char), cast(null as char), avg(cs_quantity) agg1, avg(cs_list_price) agg2, avg(cs_coupon_amt) agg3, avg(cs_sales_price) agg4, avg(cs_net_profit) agg5, avg(c_birth_year) agg6, avg(cd1.cd_dep_count) agg7 from catalog_sales, customer_demographics cd1, customer_demographics cd2, customer, customer_address, date_dim, item where cs_sold_date_sk = d_date_sk and cs_item_sk = i_item_sk and cs_bill_cdemo_sk = cd1.cd_demo_sk and cs_bill_customer_sk = c_customer_sk and cd1.cd_gender = 'F' and cd1.cd_education_status = 'Primary' and c_current_cdemo_sk = cd2.cd_demo_sk and c_current_addr_sk = ca_address_sk and c_birth_month in (9,4,3,11,1,12) and d_year = 1999 and ca_state in ('VA','NE','MI','WV','WV','CO','IN') group by 1,2,3,4 ) v1 order by 2,3,4,1; *** WARNING[6007] Multi-column statistics for columns (CD_GENDER, CD_EDUCATION_STATUS) from table TRAFODION.G_TPCDS1X.CUSTOMER_DEMOGRAPHICS were not available. The columns were being used by Scan operator. As a result, the access path chosen might not be the best possible. [2015-04-11 12:58:33] *** WARNING[6007] Multi-column statistics for columns (CA_COUNTY, CA_COUNTRY) from table TRAFODION.G_TPCDS1X.CUSTOMER_ADDRESS were not available. The columns were being used by Scan operator. As a result, the access path chosen might not be the best possible. [2015-04-11 12:58:33] *** WARNING[6007] Multi-column statistics for columns (CA_COUNTY, CA_STATE, CA_COUNTRY) from table TRAFODION.G_TPCDS1X.CUSTOMER_ADDRESS were not available. The columns were being used by GroupBy operator. As a result, the access path chosen might not be the best possible. [2015-04-11 12:58:33] *** WARNING[6007] Multi-column statistics for columns (CA_COUNTY, CA_STATE) from table TRAFODION.G_TPCDS1X.CUSTOMER_ADDRESS were not available. The columns were being used by GroupBy operator. As a result, the access path chosen might not be the best possible. [2015-04-11 12:58:33] --- SQL command prepared. SQL>explain options 'f' xx; LC RC OP OPERATOR OPT DESCRIPTION CARD ---- ---- ---- -------------------- -------- -------------------- --------- 124 . 125 root 1.30E+005 123 . 124 firstn 1.30E+005 99 122 123 merge_union 1.30E+005 121 . 122 hash_partial_groupby 1.00E+000 120 . 121 esp_exchange 1:8(hash2) 1.00E+000 119 . 120 sort_partial_groupby 1.00E+000 118 100 119 hybrid_hash_join 3.96E+004 117 . 118 esp_exchange 8(hash2):8(hash2) 4.25E+004 114 116 117 nested_join 4.25E+004 115 . 116 probe_cache 1.00E+000 . . 115 trafodion_scan CUSTOMER_DEMOGRAPHIC 1.00E+000 113 . 114 esp_exchange 8(hash2):8(hash2) 4.25E+004 112 102 113 hybrid_hash_join 4.25E+004 111 104 112 hybrid_hash_join 4.25E+004 110 105 111 hybrid_hash_join 1.88E+005 109 . 110 esp_exchange 8(hash2):8(hash2) 2.73E+005 108 107 109 hybrid_hash_join 2.73E+005 . . 108 trafodion_scan CATALOG_SALES 1.43E+006 106 . 107 esp_exchange 8(rep-b):8(hash2) 3.50E+002 . . 106 trafodion_scan DATE_DIM 3.50E+002 . . 105 trafodion_scan CUSTOMER 4.56E+004 103 . 104 esp_exchange 8(rep-b):8(hash2) 7.98E+003 . . 103 trafodion_scan CUSTOMER_ADDRESS 7.98E+003 101 . 102 esp_exchange 8(rep-b):8(hash2) 1.79E+004 . . 101 trafodion_scan ITEM 1.79E+004 . . 100 trafodion_scan CUSTOMER_DEMOGRAPHIC 1.36E+005 98 . 99 esp_exchange 1:8(hash2) (m) 1.30E+005 73 97 98 merge_union 1.30E+005 96 . 97 sort_partial_groupby 8.95E+003 95 . 96 sort 8.95E+003 94 . 95 esp_exchange 8(hash2):8(hash2) 8.95E+003 93 . 94 hash_partial_groupby 8.95E+003 92 75 93 hybrid_hash_join 3.96E+004 91 76 92 hybrid_hash_join 3.96E+004 90 . 91 esp_exchange 8(hash2):8(hash2) 4.25E+004 87 89 90 nested_join 4.25E+004 88 . 89 probe_cache 1.00E+000 . . 88 trafodion_scan CUSTOMER_DEMOGRAPHIC 1.00E+000 86 . 87 esp_exchange 8(hash2):8(hash2) 4.25E+004 85 78 86 hybrid_hash_join 4.25E+004 84 79 85 hybrid_hash_join 1.88E+005 83 . 84 esp_exchange 8(hash2):8(hash2) 2.73E+005 82 81 83 hybrid_hash_join 2.73E+005 . . 82 trafodion_scan CATALOG_SALES 1.43E+006 80 . 81 esp_exchange 8(rep-b):8(hash2) 3.50E+002 . . 80 trafodion_scan DATE_DIM 3.50E+002 . . 79 trafodion_scan CUSTOMER 4.56E+004 77 . 78 esp_exchange 8(rep-b):8(hash2) 7.98E+003 . . 77 trafodion_scan CUSTOMER_ADDRESS 7.98E+003 . . 76 trafodion_scan CUSTOMER_DEMOGRAPHIC 1.36E+005 74 . 75 esp_exchange 8(rep-b):8(hash2) 1.79E+004 . . 74 trafodion_scan ITEM 1.79E+004 49 72 73 merge_union 1.21E+005 71 . 72 sort_groupby 3.96E+004 70 . 71 sort 3.96E+004 69 . 70 esp_exchange 8(hash2):8(hash2) 3.96E+004 68 51 69 hybrid_hash_join 3.96E+004 67 52 68 hybrid_hash_join 3.96E+004 66 . 67 esp_exchange 8(hash2):8(hash2) 4.25E+004 63 65 66 nested_join 4.25E+004 64 . 65 probe_cache 1.00E+000 . . 64 trafodion_scan CUSTOMER_DEMOGRAPHIC 1.00E+000 62 . 63 esp_exchange 8(hash2):8(hash2) 4.25E+004 61 54 62 hybrid_hash_join 4.25E+004 60 55 61 hybrid_hash_join 1.88E+005 59 . 60 esp_exchange 8(hash2):8(hash2) 2.73E+005 58 57 59 hybrid_hash_join 2.73E+005 . . 58 trafodion_scan CATALOG_SALES 1.43E+006 56 . 57 esp_exchange 8(rep-b):8(hash2) 3.50E+002 . . 56 trafodion_scan DATE_DIM 3.50E+002 . . 55 trafodion_scan CUSTOMER 4.56E+004 53 . 54 esp_exchange 8(rep-b):8(hash2) 7.98E+003 . . 53 trafodion_scan CUSTOMER_ADDRESS 7.98E+003 . . 52 trafodion_scan CUSTOMER_DEMOGRAPHIC 1.36E+005 50 . 51 esp_exchange 8(rep-b):8(hash2) 1.79E+004 . . 50 trafodion_scan ITEM 1.79E+004 24 48 49 merge_union 8.18E+004 47 . 48 sort_groupby 3.96E+004 46 . 47 sort 3.96E+004 45 . 46 esp_exchange 8(hash2):8(hash2) 3.96E+004 44 26 45 hybrid_hash_join 3.96E+004 43 27 44 hybrid_hash_join 3.96E+004 42 . 43 esp_exchange 8(hash2):8(hash2) 4.25E+004 41 29 42 hybrid_hash_join 4.25E+004 40 31 41 hybrid_hash_join 2.23E+005 39 . 40 esp_exchange 8(hash2):8(hash2) 1.03E+004 36 38 39 nested_join 1.03E+004 37 . 38 probe_cache 1.00E+000 . . 37 trafodion_scan CUSTOMER_DEMOGRAPHIC 1.00E+000 35 . 36 esp_exchange 8(hash2):8(hash2) 1.03E+004 34 33 35 hybrid_hash_join 1.03E+004 . . 34 trafodion_scan CUSTOMER_ADDRESS 7.98E+003 32 . 33 esp_exchange 8(hash2):8(hash2) 4.56E+004 . . 32 trafodion_scan CUSTOMER 4.56E+004 30 . 31 esp_exchange 8(hash2):8(hash2) 1.43E+006 . . 30 trafodion_scan CATALOG_SALES 1.43E+006 28 . 29 esp_exchange 8(rep-b):8(hash2) 3.50E+002 . . 28 trafodion_scan DATE_DIM 3.50E+002 . . 27 trafodion_scan CUSTOMER_DEMOGRAPHIC 1.36E+005 25 . 26 esp_exchange 8(rep-b):8(hash2) 1.79E+004 . . 25 trafodion_scan ITEM 1.79E+004 23 . 24 sort_groupby 4.21E+004 22 . 23 sort 4.21E+004 21 . 22 esp_exchange 8(hash2):8(hash2) 4.21E+004 20 2 21 hybrid_hash_join 4.21E+004 19 3 20 hybrid_hash_join 4.21E+004 18 . 19 esp_exchange 8(hash2):8(hash2) 4.52E+004 17 5 18 hybrid_hash_join 4.52E+004 16 7 17 hybrid_hash_join 2.37E+005 15 . 16 esp_exchange 8(hash2):8(hash2) 1.09E+004 12 14 15 nested_join 1.09E+004 13 . 14 probe_cache 1.00E+000 . . 13 trafodion_scan CUSTOMER_DEMOGRAPHIC 1.00E+000 11 . 12 esp_exchange 8(hash2):8(hash2) 1.09E+004 10 9 11 hybrid_hash_join 1.09E+004 . . 10 trafodion_scan CUSTOMER_ADDRESS 8.12E+003 8 . 9 esp_exchange 8(hash2):8(hash2) 4.77E+004 . . 8 trafodion_scan CUSTOMER 4.77E+004 6 . 7 esp_exchange 8(hash2):8(hash2) 1.43E+006 . . 6 trafodion_scan CATALOG_SALES 1.43E+006 4 . 5 esp_exchange 8(rep-b):8(hash2) 3.50E+002 . . 4 trafodion_scan DATE_DIM 3.50E+002 . . 3 trafodion_scan CUSTOMER_DEMOGRAPHIC 1.36E+005 1 . 2 esp_exchange 8(rep-b):8(hash2) 1.79E+004 . . 1 trafodion_scan ITEM 1.79E+004 SQL>execute xx; I_ITEM_ID CA_COUNTRY CA_STATE CA_COUNTY AGG1 AGG2 AGG3 AGG4 AGG5 AGG6 AGG7 ---------------- -------------------- -------- ------------------------------ -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- AAAAAAAAACJCAAAA United States CO Baca County 52 34.58 33.09 1.72 -1158.89 1957 0 AAAAAAAADDKAAAAA United States CO Baca County 43 11.80 0.00 4.48 -10.32 1957 0 AAAAAAAAECHDAAAA United States CO Baca County 63 56.96 0.00 22.21 -1591.38 1957 0 AAAAAAAAHMPDAAAA United States CO Baca County 43 49.46 0.00 11.37 -692.73 1957 0 AAAAAAAAAOCBAAAA United States CO Clear Creek County 97 141.95 0.00 117.81 6402.00 1978 0 AAAAAAAACDODAAAA United States CO Clear Creek County 69 94.13 5676.38 89.42 -3643.64 1978 0 AAAAAAAADJNDAAAA United States CO Clear Creek County 99 107.39 0.00 46.17 -1504.80 1978 0 AAAAAAAAEGKDAAAA United States CO Clear Creek County 15 94.76 0.00 50.22 110.10 1978 0 AAAAAAAAFDIAAAAA United States CO Clear Creek County 91 140.72 3725.87 42.21 -7079.22 1978 0 AAAAAAAAFEEDAAAA United States CO Clear Creek County 99 33.35 0.00 26.34 569.25 1978 0 AAAAAAAAIAKCAAAA United States CO Clear Creek County 54 117.89 0.00 7.07 -4631.04 1978 0 AAAAAAAAIKKDAAAA United States CO Clear Creek County 54 19.83 0.00 17.64 451.98 1978 0 AAAAAAAALGACAAAA United States CO Clear Creek County 17 10.41 0.00 1.45 -34.34 1978 0 AAAAAAAALKDEAAAA United States CO Clear Creek County 55 198.37 0.00 45.62 -2361.70 1978 0 AAAAAAAAOJAAAAAA United States CO Clear Creek County 43 84.61 63.99 13.53 -1231.44 1978 0 AAAAAAAAOLBDAAAA United States CO Clear Creek County 41 44.41 0.00 19.98 -882.73 1978 0 AAAAAAAAOLKCAAAA United States CO Clear Creek County 50 97.20 0.00 74.84 1481.50 1978 0 AAAAAAAAAMLAAAAA United States CO Denver County 69 40.22 0.00 18.50 -908.73 1958 1 AAAAAAAABCBDAAAA United States CO Denver County 38 65.32 0.00 18.28 -654.36 1958 1 AAAAAAAACFPAAAAA United States CO Denver County 38 76.09 0.00 6.08 -742.52 1958 1 AAAAAAAAEOKAAAAA United States CO Denver County 84 129.07 0.00 52.91 -2688.84 1958 1 AAAAAAAAGFODAAAA United States CO Denver County 98 10.48 0.00 1.25 -576.24 1958 1 AAAAAAAAGNDAAAAA United States CO Denver County 87 53.79 0.00 19.36 -728.19 1958 1 AAAAAAAAIJBBAAAA United States CO Denver County 60 145.95 0.00 94.86 -265.80 1958 1 AAAAAAAAKIIAAAAA United States CO Denver County 1 52.95 0.00 2.11 -20.33 1958 1 AAAAAAAAKMECAAAA United States CO Denver County 72 99.98 0.00 72.98 2627.28 1958 1 AAAAAAAALDIAAAAA United States CO Denver County 19 102.24 0.00 56.23 396.15 1958 1 AAAAAAAALMEEAAAA United States CO Denver County 67 3.91 0.00 0.35 -129.98 1958 1 AAAAAAAANLEDAAAA United States CO Denver County 90 22.35 0.00 4.02 -1467.00 1958 1 AAAAAAAAAGODAAAA United States CO Douglas County 50 218.95 0.00 172.97 4987.00 1947 1 AAAAAAAADPICAAAA United States CO Douglas County 9 37.22 112.48 27.17 -114.28 1947 1 AAAAAAAAELEAAAAA United States CO Douglas County 37 148.13 0.00 5.92 -1982.09 1947 1 AAAAAAAAFLCEAAAA United States CO Douglas County 70 88.98 0.00 51.60 868.00 1947 1 AAAAAAAAGNDDAAAA United States CO Douglas County 41 34.05 0.00 2.38 -465.35 1947 1 AAAAAAAAGOIDAAAA United States CO Douglas County 82 104.28 0.00 90.72 4406.68 1947 1 AAAAAAAAIGCEAAAA United States CO Douglas County 20 131.96 926.28 102.92 -40.88 1947 1 AAAAAAAAJMFCAAAA United States CO Douglas County 2 233.52 0.00 70.05 -35.48 1947 1 AAAAAAAAMDICAAAA United States CO Douglas County 30 72.12 0.00 59.85 912.30 1947 1 AAAAAAAAMGDCAAAA United States CO Douglas County 7 50.02 0.00 44.51 -38.57 1947 1 AAAAAAAAOAJDAAAA United States CO Douglas County 70 60.34 2022.13 38.01 -1363.43 1947 1 AAAAAAAAONNAAAAA United States CO Douglas County 4 55.50 0.00 27.75 -80.40 1947 1 AAAAAAAAPBJAAAAA United States CO Douglas County 6 193.01 0.00 71.41 -156.42 1947 1 AAAAAAAAPGNDAAAA United States CO Douglas County 90 173.83 0.00 34.76 -3390.30 1947 1 AAAAAAAACEEBAAAA United States CO Eagle County 83 23.80 0.00 2.61 -1194.37 1956 2 AAAAAAAADMKDAAAA United States CO Eagle County 17 223.82 0.00 214.86 2322.20 1956 2 AAAAAAAAEPHDAAAA United States CO Eagle County 97 44.40 0.00 33.30 153.26 1956 2 AAAAAAAAFPEEAAAA United States CO Eagle County 16 107.53 0.00 81.72 703.84 1956 2 AAAAAAAAGMODAAAA United States CO Eagle County 64 169.41 0.00 3.38 -4245.76 1956 2 AAAAAAAAIFKCAAAA United States CO Eagle County 62 230.14 0.00 46.02 -1967.26 1956 2 AAAAAAAAILADAAAA United States CO Eagle County 61 38.14 0.00 16.40 10.37 1956 2 AAAAAAAAMDBEAAAA United States CO Eagle County 53 143.86 0.00 5.75 -2498.42 1956 2 AAAAAAAAMJDBAAAA United States CO Eagle County 100 65.60 2124.62 51.82 -272.62 1956 2 AAAAAAAAOHOCAAAA United States CO Eagle County 40 164.24 492.72 41.06 -1553.92 1956 2 AAAAAAAAPDEAAAAA United States CO Eagle County 48 36.25 0.00 6.16 -1300.80 1956 2 AAAAAAAAPHNCAAAA United States CO Eagle County 76 151.32 0.00 21.18 -3919.32 1956 2 AAAAAAAAPLLDAAAA United States CO Eagle County 74 31.40 0.00 12.24 -555.74 1956 2 AAAAAAAAACMDAAAA United States CO Elbert County 5 5.16 0.00 3.45 4.65 1927 1 AAAAAAAAADLAAAAA United States CO Elbert County 99 22.84 0.00 21.69 1109.79 1927 1 AAAAAAAAAKFEAAAA United States CO Elbert County 40 139.99 206.06 128.79 1612.34 1924 3 AAAAAAAABCDBAAAA United States CO Elbert County 72 50.15 0.00 46.63 884.16 1927 1 AAAAAAAABGJAAAAA United States CO Elbert County 33 118.09 0.00 89.74 380.49 1924 3 AAAAAAAADGNDAAAA United States CO Elbert County 59 93.20 0.00 71.76 2331.09 1927 1 AAAAAAAAEGOBAAAA United States CO Elbert County 22 144.11 0.00 28.82 -833.80 1927 1 AAAAAAAAEMCBAAAA United States CO Elbert County 43 8.02 0.00 4.09 -119.11 1927 1 AAAAAAAAGOGAAAAA United States CO Elbert County 58 18.70 0.00 8.78 -114.26 1927 1 AAAAAAAAHAIBAAAA United States CO Elbert County 76 7.61 0.00 4.26 99.56 1927 1 AAAAAAAAHJECAAAA United States CO Elbert County 80 61.68 0.00 28.98 -1793.60 1927 1 AAAAAAAAIPIAAAAA United States CO Elbert County 96 31.62 0.00 12.01 -1182.72 1924 3 AAAAAAAAKECAAAAA United States CO Elbert County 29 26.75 0.00 5.88 -343.36 1924 3 AAAAAAAAKKLDAAAA United States CO Elbert County 20 65.42 0.00 58.22 496.80 1927 1 AAAAAAAALBEAAAAA United States CO Elbert County 20 9.98 122.04 6.78 -157.04 1924 3 AAAAAAAAMLFDAAAA United States CO Elbert County 42 132.79 0.00 111.54 2656.50 1927 1 AAAAAAAAOBGEAAAA United States CO Elbert County 89 284.28 0.00 102.34 323.07 1927 1 AAAAAAAAOMFBAAAA United States CO Elbert County 79 124.53 363.99 92.15 3351.38 1924 3 AAAAAAAAOPCDAAAA United States CO Elbert County 99 32.56 0.00 4.55 -2619.54 1924 3 AAAAAAAAALKCAAAA United States CO Huerfano County 18 93.27 736.79 53.16 -494.33 1984 5 AAAAAAAACCDBAAAA United States CO Huerfano County 76 153.44 0.00 116.61 3585.68 1984 5 AAAAAAAACHGBAAAA United States CO Huerfano County 66 97.59 1468.52 92.71 -120.80 1984 5 AAAAAAAACOEAAAAA United States CO Huerfano County 8 68.60 0.00 66.54 33.36 1984 5 AAAAAAAADOFAAAAA United States CO Huerfano County 45 99.53 762.23 22.89 -1281.98 1984 5 AAAAAAAAHCJBAAAA United States CO Huerfano County 92 110.37 2662.37 50.77 -5626.61 1984 5 AAAAAAAAIABCAAAA United States CO Huerfano County 21 97.55 0.00 94.62 656.67 1984 5 AAAAAAAAANPDAAAA United States CO Jefferson County 81 10.20 112.10 3.46 -132.35 1939 6 AAAAAAAACCLBAAAA United States CO Jefferson County 44 150.24 0.00 18.02 -1440.56 1939 6 AAAAAAAADGHDAAAA United States CO Jefferson County 68 159.16 1916.37 36.60 -4324.93 1939 6 AAAAAAAAKFGBAAAA United States CO Jefferson County 26 97.84 0.00 39.13 -867.10 1939 6 AAAAAAAAKGGAAAAA United States CO Jefferson County 54 114.36 0.00 48.03 -1881.36 1939 6 AAAAAAAAMLIBAAAA United States CO Jefferson County 95 99.02 0.00 5.94 -2856.65 1939 6 AAAAAAAANFOCAAAA United States CO Jefferson County 94 40.46 1373.47 33.98 -17.05 1939 6 AAAAAAAANLKAAAAA United States CO Jefferson County 45 96.34 0.00 79.96 2033.10 1939 6 AAAAAAAACEBAAAAA United States CO Kit Carson County 69 12.85 0.00 11.82 287.73 1972 2 AAAAAAAADFLAAAAA United States CO Kit Carson County 58 184.27 0.00 162.15 5601.06 1972 2 AAAAAAAADNJDAAAA United States CO Kit Carson County 86 238.08 0.00 30.95 -5006.92 1972 2 AAAAAAAAGDLDAAAA United States CO Kit Carson County 6 161.87 0.00 147.30 434.16 1972 2 AAAAAAAAICMBAAAA United States CO Kit Carson County 78 49.89 0.00 47.89 2425.02 1972 2 AAAAAAAAJJEDAAAA United States CO Kit Carson County 12 269.21 0.00 43.07 -624.72 1972 2 AAAAAAAAKIJBAAAA United States CO Kit Carson County 23 247.03 0.00 242.08 3574.20 1972 2 AAAAAAAAKOFDAAAA United States CO Kit Carson County 1 197.42 0.00 96.73 14.47 1972 2 AAAAAAAAMANBAAAA United States CO Kit Carson County 37 55.87 0.00 12.29 -1135.53 1972 2 AAAAAAAANIEDAAAA United States CO Kit Carson County 37 48.79 0.00 16.58 -336.70 1972 2 AAAAAAAAPIJCAAAA United States CO Kit Carson County 98 95.75 0.00 46.91 902.58 1972 2 AAAAAAAAPNHCAAAA United States CO Kit Carson County 47 9.95 0.00 2.68 -170.14 1972 2 AAAAAAAABKFDAAAA United States CO La Plata County 90 36.61 0.00 33.31 899.10 1954 5 AAAAAAAAGHLCAAAA United States CO La Plata County 18 42.41 0.00 35.20 -60.48 1954 5 AAAAAAAAKBOBAAAA United States CO La Plata County 21 123.99 431.17 85.55 390.14 1954 5 AAAAAAAALFLBAAAA United States CO La Plata County 72 178.62 4853.27 91.09 -2988.47 1954 5 AAAAAAAAMDKDAAAA United States CO La Plata County 37 69.28 0.00 24.24 -1371.59 1954 5 AAAAAAAANHACAAAA United States CO La Plata County 92 180.96 0.00 85.05 -179.40 1954 5 AAAAAAAAEFLCAAAA United States CO Las Animas County 90 103.96 0.00 49.90 -594.00 1927 4 AAAAAAAAEHADAAAA United States CO Las Animas County 70 80.21 0.00 57.75 1731.80 1927 4 AAAAAAAAKKBBAAAA United States CO Las Animas County 37 108.40 0.00 4.33 -1671.29 1927 4 AAAAAAAAMCACAAAA United States CO Las Animas County 80 91.09 6233.13 85.62 -5949.13 1927 4 AAAAAAAAOFOCAAAA United States CO Las Animas County 57 64.00 0.00 3.84 -1009.47 1927 4 AAAAAAAAAAODAAAA United States CO Rio Blanco County 25 248.64 0.00 146.69 1190.75 1948 4 AAAAAAAAABAAAAAA United States CO Rio Blanco County 24 27.75 0.00 9.71 -317.52 1948 4 AAAAAAAAAEIBAAAA United States CO Rio Blanco County 76 9.73 0.00 3.50 -31.16 1948 4 AAAAAAAAANCCAAAA United States CO Rio Blanco County 84 49.99 0.00 22.49 -82.32 1925 2 AAAAAAAAAOJCAAAA United States CO Rio Blanco County 35 5.22 0.00 1.09 -104.65 1948 4 AAAAAAAACFBDAAAA United States CO Rio Blanco County 18 247.17 0.00 54.37 -539.82 1948 4 AAAAAAAAFABEAAAA United States CO Rio Blanco County 67 133.05 0.00 38.58 -2480.34 1948 4 AAAAAAAAFBNAAAAA United States CO Rio Blanco County 68 195.99 0.00 156.79 5918.72 1948 4 AAAAAAAAGBLCAAAA United States CO Rio Blanco County 62 1.21 0.00 0.22 -52.08 1948 4 AAAAAAAAGHIBAAAA United States CO Rio Blanco County 68 41.11 0.00 29.18 799.68 1948 4 AAAAAAAAGICAAAAA United States CO Rio Blanco County 41 21.35 0.00 10.46 -101.68 1925 2 AAAAAAAAHJGAAAAA United States CO Rio Blanco County 46 70.05 0.00 28.72 118.68 1925 2 AAAAAAAAHLNAAAAA United States CO Rio Blanco County 68 133.59 0.00 44.08 -1434.12 1925 2 AAAAAAAAIEODAAAA United States CO Rio Blanco County 65 82.15 0.00 2.46 -2999.75 1925 2 AAAAAAAAILLBAAAA United States CO Rio Blanco County 60 33.52 0.00 19.10 -151.80 1925 2 AAAAAAAAJEECAAAA United States CO Rio Blanco County 10 155.36 0.00 10.87 -779.10 1948 4 AAAAAAAALHJBAAAA United States CO Rio Blanco County 95 239.78 0.00 220.59 12519.10 1948 4 AAAAAAAAMEEDAAAA United States CO Rio Blanco County 19 68.85 0.00 44.75 -317.87 1925 2 AAAAAAAAGCLAAAAA United States IN Bartholomew County 95 40.01 0.00 28.00 56.05 1926 1 AAAAAAAAHBBEAAAA United States IN Bartholomew County 2 115.44 0.00 61.18 -76.68 1926 1 AAAAAAAAMJEDAAAA United States IN Bartholomew County 90 96.65 0.00 14.49 -6005.70 1926 1 AAAAAAAAAHKCAAAA United States IN Blackford County 50 133.58 0.00 13.35 -3064.00 1932 2 AAAAAAAAGALAAAAA United States IN Franklin County 70 48.12 1919.98 48.12 50.52 1943 1 AAAAAAAAKGPBAAAA United States IN Franklin County 57 73.37 0.00 38.88 625.86 1943 1 AAAAAAAAGBCBAAAA United States IN Hancock County 92 78.71 47.76 4.72 -6854.84 1985 5 AAAAAAAAHGJAAAAA United States IN Hancock County 97 58.93 0.00 45.96 1075.73 1985 5 AAAAAAAAKDHCAAAA United States IN Hancock County 65 170.01 0.00 88.40 629.85 1985 5 AAAAAAAAMAPCAAAA United States IN Howard County 58 114.32 0.00 107.46 3558.88 1967 6 AAAAAAAAOPJAAAAA United States IN Howard County 46 71.50 0.00 5.72 -1349.18 1954 0 AAAAAAAACIJAAAAA United States IN Lagrange County 7 118.89 0.00 64.20 96.74 1964 5 AAAAAAAAOJMCAAAA United States IN Lagrange County 24 244.70 0.00 4.89 -2150.16 1964 5 AAAAAAAAMFDAAAAA United States IN Marshall County 78 79.41 0.00 53.20 1953.12 1927 5 AAAAAAAAHAPDAAAA United States IN Ohio County 62 73.39 0.00 21.28 -2026.78 1970 3 AAAAAAAACGECAAAA United States IN Parke County 94 156.95 0.00 123.99 5482.08 1931 3 AAAAAAAAEOBBAAAA United States IN Parke County 61 110.15 0.00 16.52 -1679.94 1980 0 AAAAAAAAHILCAAAA United States IN Parke County 44 34.55 0.00 25.22 572.44 1980 0 AAAAAAAAHGMDAAAA United States IN Pike County 78 17.82 0.00 15.85 772.98 1928 2 AAAAAAAAMEHDAAAA United States CO Rio Blanco County 93 268.25 0.00 112.66 1535.43 1948 4 AAAAAAAAMLDAAAAA United States CO Rio Blanco County 98 75.38 0.00 74.62 3253.60 1925 2 AAAAAAAANKJCAAAA United States CO Rio Blanco County 16 98.09 0.00 89.26 -141.28 1948 4 AAAAAAAAPAEAAAAA United States IN Bartholomew County 59 150.06 0.00 127.55 3501.06 1926 1 AAAAAAAANNIAAAAA United States IN Clinton County 62 7.46 0.00 1.64 -159.96 1947 0 AAAAAAAAFHGBAAAA United States IN Franklin County 38 48.28 0.00 9.17 -699.96 1943 1 AAAAAAAABGIBAAAA United States IN Hamilton County 60 209.08 0.00 188.17 5400.60 1931 6 AAAAAAAAKDCBAAAA United States IN Hamilton County 77 265.18 0.00 238.66 10978.66 1931 6 AAAAAAAAEMLCAAAA United States IN Hancock County 11 79.75 0.00 78.95 85.14 1985 5 AAAAAAAANMBCAAAA United States IN Hancock County 14 97.03 0.00 7.76 -854.84 1985 5 AAAAAAAAOKIAAAAA United States IN Hancock County 22 8.47 0.00 7.96 106.04 1985 5 AAAAAAAABDADAAAA United States IN Howard County 12 76.83 0.00 70.68 471.84 1954 0 AAAAAAAAEBOBAAAA United States IN Howard County 31 68.03 0.00 21.08 -422.53 1967 6 AAAAAAAAEKPAAAAA United States IN Howard County 50 143.77 0.00 143.77 2858.00 1967 6 AAAAAAAAEHIAAAAA United States IN Johnson County 30 103.26 0.00 11.35 -1352.40 1933 2 AAAAAAAAFPFAAAAA United States IN Johnson County 34 88.77 0.00 87.88 244.12 1933 2 AAAAAAAAMEGDAAAA United States IN Johnson County 11 215.08 0.00 129.04 589.27 1933 2 AAAAAAAALBBDAAAA United States IN Lagrange County 82 37.91 0.00 5.30 -2341.10 1964 5 AAAAAAAAOFFEAAAA United States IN Lagrange County 28 136.08 0.00 125.19 744.24 1964 5 AAAAAAAAAKJAAAAA United States IN Lake County 43 80.08 0.00 51.25 991.15 1946 5 AAAAAAAABCKAAAAA United States IN Lake County 46 229.75 0.00 59.73 -1364.82 1946 5 AAAAAAAACOICAAAA United States IN Lake County 84 74.93 377.49 14.98 -3816.45 1946 5 AAAAAAAAIEKDAAAA United States IN Lake County 82 85.91 0.00 38.65 65.60 1946 5 AAAAAAAAPCPCAAAA United States IN Miami County 85 67.88 0.00 9.50 -1864.05 1937 0 AAAAAAAAPCHBAAAA United States IN Ohio County 17 57.59 93.96 23.03 -67.78 1970 3 AAAAAAAAACKCAAAA United States IN Parke County 12 166.07 0.00 107.94 425.04 1980 0 AAAAAAAADOKBAAAA United States IN Parke County 77 104.66 4776.98 81.63 -2645.62 1931 3 AAAAAAAAGGCDAAAA United States IN Parke County 65 116.33 0.00 1.16 -6279.00 1931 3 AAAAAAAALCNCAAAA United States IN Parke County 75 141.14 0.00 87.50 1347.75 1980 0 AAAAAAAAMACCAAAA United States IN Parke County 11 62.19 0.00 41.66 -111.87 1980 0 AAAAAAAAOBFCAAAA United States IN Parke County 80 176.65 0.00 26.49 -3358.40 1980 0 AAAAAAAACFCEAAAA United States IN Pike County 68 113.92 0.00 66.07 350.20 1928 2 AAAAAAAAIPDCAAAA United States IN Ripley County 34 225.63 0.00 121.84 1049.24 1945 3 AAAAAAAAOBNDAAAA United States IN Ripley County 5 102.44 0.00 16.39 -178.05 1945 3 AAAAAAAAAGFCAAAA United States CO Routt County 70 187.00 0.00 16.83 -5366.90 1951 2 AAAAAAAAJPNAAAAA United States IN Bartholomew County 19 61.22 0.00 27.54 90.82 1926 1 AAAAAAAAMJEEAAAA United States IN Bartholomew County 74 254.71 0.00 99.33 16.28 1926 1 AAAAAAAAFOIBAAAA United States IN Blackford County 48 232.32 0.00 85.95 -282.24 1932 2 AAAAAAAAADFCAAAA United States IN Clinton County 5 97.97 19.59 19.59 -383.79 1947 0 AAAAAAAAGCDCAAAA United States IN Daviess County 29 201.75 0.00 133.15 1891.38 1948 3 AAAAAAAALMFDAAAA United States IN Hancock County 67 142.39 0.00 130.99 4099.73 1985 5 AAAAAAAAOEBAAAAA United States IN Howard County 16 3.75 0.00 2.73 -5.92 1967 6 AAAAAAAAIOCCAAAA United States IN Johnson County 47 162.33 0.00 105.51 1641.71 1933 5 AAAAAAAANBCDAAAA United States IN Johnson County 27 122.20 0.00 0.00 -1153.71 1933 2 AAAAAAAAMHJBAAAA United States IN Lagrange County 66 138.02 0.00 23.46 -4958.58 1964 5 AAAAAAAABEBBAAAA United States IN Lake County 3 242.93 0.00 48.58 -119.28 1946 5 AAAAAAAAJABAAAAA United States IN Lake County 70 201.49 0.00 179.32 5672.10 1946 5 AAAAAAAAEKHCAAAA United States IN Miami County 99 146.28 2815.20 52.66 -5144.67 1937 0 AAAAAAAAOBKDAAAA United States IN Miami County 82 7.29 0.00 1.45 -308.32 1937 0 AAAAAAAACODDAAAA United States IN Monroe County 38 228.78 0.00 16.01 -2507.62 1939 5 --- 200 row(s) selected. ------------------ v0407 result (correct) ------------------ SQL>set schema trafodion.g_tpcds1x; --- SQL operation complete. SQL>set param ?q 18; SQL>prepare xx from select [first 200] i_item_id, ca_country, ca_state, ca_county, agg1, agg2, agg3, agg4, agg5, agg6, agg7 from ( select i_item_id, ca_country, ca_state, ca_county, avg(cs_quantity) agg1, avg(cs_list_price) agg2, avg(cs_coupon_amt) agg3, avg(cs_sales_price) agg4, avg(cs_net_profit) agg5, avg(c_birth_year) agg6, avg(cd1.cd_dep_count) agg7 from catalog_sales, customer_demographics cd1, customer_demographics cd2, customer, customer_address, date_dim, item where cs_sold_date_sk = d_date_sk and cs_item_sk = i_item_sk and cs_bill_cdemo_sk = cd1.cd_demo_sk and cs_bill_customer_sk = c_customer_sk and cd1.cd_gender = 'F' and cd1.cd_education_status = 'Primary' and c_current_cdemo_sk = cd2.cd_demo_sk and c_current_addr_sk = ca_address_sk and c_birth_month in (9,4,3,11,1,12) and d_year = 1999 and ca_state in ('VA','NE','MI','WV','WV','CO','IN') group by 1,2,3,4 union all select i_item_id, cast(null as char), ca_state, ca_county, avg(cs_quantity) agg1, avg(cs_list_price) agg2, avg(cs_coupon_amt) agg3, avg(cs_sales_price) agg4, avg(cs_net_profit) agg5, avg(c_birth_year) agg6, avg(cd1.cd_dep_count) agg7 from catalog_sales, customer_demographics cd1, customer_demographics cd2, customer, customer_address, date_dim, item where cs_sold_date_sk = d_date_sk and cs_item_sk = i_item_sk and cs_bill_cdemo_sk = cd1.cd_demo_sk and cs_bill_customer_sk = c_customer_sk and cd1.cd_gender = 'F' and cd1.cd_education_status = 'Primary' and c_current_cdemo_sk = cd2.cd_demo_sk and c_current_addr_sk = ca_address_sk and c_birth_month in (9,4,3,11,1,12) and d_year = 1999 and ca_state in ('VA','NE','MI','WV','WV','CO','IN') group by 1,2,3,4 union all select i_item_id, cast(null as char), cast(null as char), ca_county, avg(cs_quantity) agg1, avg(cs_list_price) agg2, avg(cs_coupon_amt) agg3, avg(cs_sales_price) agg4, avg(cs_net_profit) agg5, avg(c_birth_year) agg6, avg(cd1.cd_dep_count) agg7 from catalog_sales, customer_demographics cd1, customer_demographics cd2, customer, customer_address, date_dim, item where cs_sold_date_sk = d_date_sk and cs_item_sk = i_item_sk and cs_bill_cdemo_sk = cd1.cd_demo_sk and cs_bill_customer_sk = c_customer_sk and cd1.cd_gender = 'F' and cd1.cd_education_status = 'Primary' and c_current_cdemo_sk = cd2.cd_demo_sk and c_current_addr_sk = ca_address_sk and c_birth_month in (9,4,3,11,1,12) and d_year = 1999 and ca_state in ('VA','NE','MI','WV','WV','CO','IN') group by 1,2,3,4 union all select i_item_id, cast(null as char), cast(null as char), cast(null as char), avg(cs_quantity) agg1, avg(cs_list_price) agg2, avg(cs_coupon_amt) agg3, avg(cs_sales_price) agg4, avg(cs_net_profit) agg5, avg(c_birth_year) agg6, avg(cd1.cd_dep_count) agg7 from catalog_sales, customer_demographics cd1, customer_demographics cd2, customer, customer_address, date_dim, item where cs_sold_date_sk = d_date_sk and cs_item_sk = i_item_sk and cs_bill_cdemo_sk = cd1.cd_demo_sk and cs_bill_customer_sk = c_customer_sk and cd1.cd_gender = 'F' and cd1.cd_education_status = 'Primary' and c_current_cdemo_sk = cd2.cd_demo_sk and c_current_addr_sk = ca_address_sk and c_birth_month in (9,4,3,11,1,12) and d_year = 1999 and ca_state in ('VA','NE','MI','WV','WV','CO','IN') group by 1,2,3,4 union all select cast(null as char), cast(null as char), cast(null as char), cast(null as char), avg(cs_quantity) agg1, avg(cs_list_price) agg2, avg(cs_coupon_amt) agg3, avg(cs_sales_price) agg4, avg(cs_net_profit) agg5, avg(c_birth_year) agg6, avg(cd1.cd_dep_count) agg7 from catalog_sales, customer_demographics cd1, customer_demographics cd2, customer, customer_address, date_dim, item where cs_sold_date_sk = d_date_sk and cs_item_sk = i_item_sk and cs_bill_cdemo_sk = cd1.cd_demo_sk and cs_bill_customer_sk = c_customer_sk and cd1.cd_gender = 'F' and cd1.cd_education_status = 'Primary' and c_current_cdemo_sk = cd2.cd_demo_sk and c_current_addr_sk = ca_address_sk and c_birth_month in (9,4,3,11,1,12) and d_year = 1999 and ca_state in ('VA','NE','MI','WV','WV','CO','IN') group by 1,2,3,4 ) v1 order by 2,3,4,1; *** WARNING[6007] Multi-column statistics for columns (CD_GENDER, CD_EDUCATION_STATUS) from table TRAFODION.G_TPCDS1X.CUSTOMER_DEMOGRAPHICS were not available. The columns were being used by Scan operator. As a result, the access path chosen might not be the best possible. [2015-04-09 18:02:47] *** WARNING[6007] Multi-column statistics for columns (CA_COUNTY, CA_COUNTRY) from table TRAFODION.G_TPCDS1X.CUSTOMER_ADDRESS were not available. The columns were being used by Scan operator. As a result, the access path chosen might not be the best possible. [2015-04-09 18:02:47] *** WARNING[6007] Multi-column statistics for columns (CA_COUNTY, CA_STATE, CA_COUNTRY) from table TRAFODION.G_TPCDS1X.CUSTOMER_ADDRESS were not available. The columns were being used by GroupBy operator. As a result, the access path chosen might not be the best possible. [2015-04-09 18:02:47] *** WARNING[6007] Multi-column statistics for columns (CA_COUNTY, CA_STATE) from table TRAFODION.G_TPCDS1X.CUSTOMER_ADDRESS were not available. The columns were being used by GroupBy operator. As a result, the access path chosen might not be the best possible. [2015-04-09 18:02:47] --- SQL command prepared. SQL>explain options 'f' xx; LC RC OP OPERATOR OPT DESCRIPTION CARD ---- ---- ---- -------------------- -------- -------------------- --------- 124 . 125 root 1.30E+005 123 . 124 firstn 1.30E+005 99 122 123 merge_union 1.30E+005 121 . 122 hash_partial_groupby 1.00E+000 120 . 121 esp_exchange 1:8(hash2) 1.00E+000 119 . 120 sort_partial_groupby 1.00E+000 118 100 119 hybrid_hash_join 3.96E+004 117 . 118 esp_exchange 8(hash2):8(hash2) 4.25E+004 114 116 117 nested_join 4.25E+004 115 . 116 probe_cache 1.00E+000 . . 115 trafodion_scan CUSTOMER_DEMOGRAPHIC 1.00E+000 113 . 114 esp_exchange 8(hash2):8(hash2) 4.25E+004 112 102 113 hybrid_hash_join 4.25E+004 111 104 112 hybrid_hash_join 4.25E+004 110 105 111 hybrid_hash_join 1.88E+005 109 . 110 esp_exchange 8(hash2):8(hash2) 2.73E+005 108 107 109 hybrid_hash_join 2.73E+005 . . 108 trafodion_scan CATALOG_SALES 1.43E+006 106 . 107 esp_exchange 8(rep-b):8(hash2) 3.50E+002 . . 106 trafodion_scan DATE_DIM 3.50E+002 . . 105 trafodion_scan CUSTOMER 4.56E+004 103 . 104 esp_exchange 8(rep-b):8(hash2) 7.98E+003 . . 103 trafodion_scan CUSTOMER_ADDRESS 7.98E+003 101 . 102 esp_exchange 8(rep-b):8(hash2) 1.79E+004 . . 101 trafodion_scan ITEM 1.79E+004 . . 100 trafodion_scan CUSTOMER_DEMOGRAPHIC 1.36E+005 98 . 99 esp_exchange 1:8(hash2) (m) 1.30E+005 73 97 98 merge_union 1.30E+005 96 . 97 sort_partial_groupby 8.95E+003 95 . 96 sort 8.95E+003 94 . 95 esp_exchange 8(hash2):8(hash2) 8.95E+003 93 . 94 hash_partial_groupby 8.95E+003 92 75 93 hybrid_hash_join 3.96E+004 91 76 92 hybrid_hash_join 3.96E+004 90 . 91 esp_exchange 8(hash2):8(hash2) 4.25E+004 87 89 90 nested_join 4.25E+004 88 . 89 probe_cache 1.00E+000 . . 88 trafodion_scan CUSTOMER_DEMOGRAPHIC 1.00E+000 86 . 87 esp_exchange 8(hash2):8(hash2) 4.25E+004 85 78 86 hybrid_hash_join 4.25E+004 84 79 85 hybrid_hash_join 1.88E+005 83 . 84 esp_exchange 8(hash2):8(hash2) 2.73E+005 82 81 83 hybrid_hash_join 2.73E+005 . . 82 trafodion_scan CATALOG_SALES 1.43E+006 80 . 81 esp_exchange 8(rep-b):8(hash2) 3.50E+002 . . 80 trafodion_scan DATE_DIM 3.50E+002 . . 79 trafodion_scan CUSTOMER 4.56E+004 77 . 78 esp_exchange 8(rep-b):8(hash2) 7.98E+003 . . 77 trafodion_scan CUSTOMER_ADDRESS 7.98E+003 . . 76 trafodion_scan CUSTOMER_DEMOGRAPHIC 1.36E+005 74 . 75 esp_exchange 8(rep-b):8(hash2) 1.79E+004 . . 74 trafodion_scan ITEM 1.79E+004 49 72 73 merge_union 1.21E+005 71 . 72 sort_groupby 3.96E+004 70 . 71 sort 3.96E+004 69 . 70 esp_exchange 8(hash2):8(hash2) 3.96E+004 68 51 69 hybrid_hash_join 3.96E+004 67 52 68 hybrid_hash_join 3.96E+004 66 . 67 esp_exchange 8(hash2):8(hash2) 4.25E+004 63 65 66 nested_join 4.25E+004 64 . 65 probe_cache 1.00E+000 . . 64 trafodion_scan CUSTOMER_DEMOGRAPHIC 1.00E+000 62 . 63 esp_exchange 8(hash2):8(hash2) 4.25E+004 61 54 62 hybrid_hash_join 4.25E+004 60 55 61 hybrid_hash_join 1.88E+005 59 . 60 esp_exchange 8(hash2):8(hash2) 2.73E+005 58 57 59 hybrid_hash_join 2.73E+005 . . 58 trafodion_scan CATALOG_SALES 1.43E+006 56 . 57 esp_exchange 8(rep-b):8(hash2) 3.50E+002 . . 56 trafodion_scan DATE_DIM 3.50E+002 . . 55 trafodion_scan CUSTOMER 4.56E+004 53 . 54 esp_exchange 8(rep-b):8(hash2) 7.98E+003 . . 53 trafodion_scan CUSTOMER_ADDRESS 7.98E+003 . . 52 trafodion_scan CUSTOMER_DEMOGRAPHIC 1.36E+005 50 . 51 esp_exchange 8(rep-b):8(hash2) 1.79E+004 . . 50 trafodion_scan ITEM 1.79E+004 24 48 49 merge_union 8.18E+004 47 . 48 sort_groupby 3.96E+004 46 . 47 sort 3.96E+004 45 . 46 esp_exchange 8(hash2):8(hash2) 3.96E+004 44 26 45 hybrid_hash_join 3.96E+004 43 27 44 hybrid_hash_join 3.96E+004 42 . 43 esp_exchange 8(hash2):8(hash2) 4.25E+004 41 29 42 hybrid_hash_join 4.25E+004 40 31 41 hybrid_hash_join 2.23E+005 39 . 40 esp_exchange 8(hash2):8(hash2) 1.03E+004 36 38 39 nested_join 1.03E+004 37 . 38 probe_cache 1.00E+000 . . 37 trafodion_scan CUSTOMER_DEMOGRAPHIC 1.00E+000 35 . 36 esp_exchange 8(hash2):8(hash2) 1.03E+004 34 33 35 hybrid_hash_join 1.03E+004 . . 34 trafodion_scan CUSTOMER_ADDRESS 7.98E+003 32 . 33 esp_exchange 8(hash2):8(hash2) 4.56E+004 . . 32 trafodion_scan CUSTOMER 4.56E+004 30 . 31 esp_exchange 8(hash2):8(hash2) 1.43E+006 . . 30 trafodion_scan CATALOG_SALES 1.43E+006 28 . 29 esp_exchange 8(rep-b):8(hash2) 3.50E+002 . . 28 trafodion_scan DATE_DIM 3.50E+002 . . 27 trafodion_scan CUSTOMER_DEMOGRAPHIC 1.36E+005 25 . 26 esp_exchange 8(rep-b):8(hash2) 1.79E+004 . . 25 trafodion_scan ITEM 1.79E+004 23 . 24 sort_groupby 4.21E+004 22 . 23 sort 4.21E+004 21 . 22 esp_exchange 8(hash2):8(hash2) 4.21E+004 20 2 21 hybrid_hash_join 4.21E+004 19 3 20 hybrid_hash_join 4.21E+004 18 . 19 esp_exchange 8(hash2):8(hash2) 4.52E+004 17 5 18 hybrid_hash_join 4.52E+004 15 . 16 esp_exchange 8(hash2):8(hash2) 1.09E+004 12 14 15 nested_join 1.09E+004 13 . 14 probe_cache 1.00E+000 . . 13 trafodion_scan CUSTOMER_DEMOGRAPHIC 1.00E+000 11 . 12 esp_exchange 8(hash2):8(hash2) 1.09E+004 10 9 11 hybrid_hash_join 1.09E+004 . . 10 trafodion_scan CUSTOMER_ADDRESS 8.12E+003 8 . 9 esp_exchange 8(hash2):8(hash2) 4.77E+004 . . 8 trafodion_scan CUSTOMER 4.77E+004 6 . 7 esp_exchange 8(hash2):8(hash2) 1.43E+006 . . 6 trafodion_scan CATALOG_SALES 1.43E+006 4 . 5 esp_exchange 8(rep-b):8(hash2) 3.50E+002 . . 4 trafodion_scan DATE_DIM 3.50E+002 . . 3 trafodion_scan CUSTOMER_DEMOGRAPHIC 1.36E+005 1 . 2 esp_exchange 8(rep-b):8(hash2) 1.79E+004 . . 1 trafodion_scan ITEM 1.79E+004 --- SQL operation complete. SQL>execute xx; I_ITEM_ID CA_COUNTRY CA_STATE CA_COUNTY AGG1 AGG2 AGG3 AGG4 AGG5 AGG6 AGG7 ---------------- -------------------- -------- ------------------------------ -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- AAAAAAAAACJCAAAA United States CO Baca County 52 34.58 33.09 1.72 -1158.89 1957 0 AAAAAAAADDKAAAAA United States CO Baca County 43 11.80 0.00 4.48 -10.32 1957 0 AAAAAAAAECHDAAAA United States CO Baca County 63 56.96 0.00 22.21 -1591.38 1957 0 AAAAAAAAHMPDAAAA United States CO Baca County 43 49.46 0.00 11.37 -692.73 1957 0 AAAAAAAAAOCBAAAA United States CO Clear Creek County 97 141.95 0.00 117.81 6402.00 1978 0 AAAAAAAACDODAAAA United States CO Clear Creek County 69 94.13 5676.38 89.42 -3643.64 1978 0 AAAAAAAADJNDAAAA United States CO Clear Creek County 99 107.39 0.00 46.17 -1504.80 1978 0 AAAAAAAAEGKDAAAA United States CO Clear Creek County 15 94.76 0.00 50.22 110.10 1978 0 AAAAAAAAFDIAAAAA United States CO Clear Creek County 91 140.72 3725.87 42.21 -7079.22 1978 0 AAAAAAAAFEEDAAAA United States CO Clear Creek County 99 33.35 0.00 26.34 569.25 1978 0 AAAAAAAAIAKCAAAA United States CO Clear Creek County 54 117.89 0.00 7.07 -4631.04 1978 0 AAAAAAAAIKKDAAAA United States CO Clear Creek County 54 19.83 0.00 17.64 451.98 1978 0 AAAAAAAALGACAAAA United States CO Clear Creek County 17 10.41 0.00 1.45 -34.34 1978 0 AAAAAAAALKDEAAAA United States CO Clear Creek County 55 198.37 0.00 45.62 -2361.70 1978 0 AAAAAAAAOJAAAAAA United States CO Clear Creek County 43 84.61 63.99 13.53 -1231.44 1978 0 AAAAAAAAOLBDAAAA United States CO Clear Creek County 41 44.41 0.00 19.98 -882.73 1978 0 AAAAAAAAOLKCAAAA United States CO Clear Creek County 50 97.20 0.00 74.84 1481.50 1978 0 AAAAAAAAAMLAAAAA United States CO Denver County 69 40.22 0.00 18.50 -908.73 1958 1 AAAAAAAABCBDAAAA United States CO Denver County 38 65.32 0.00 18.28 -654.36 1958 1 AAAAAAAACFPAAAAA United States CO Denver County 38 76.09 0.00 6.08 -742.52 1958 1 AAAAAAAAEOKAAAAA United States CO Denver County 84 129.07 0.00 52.91 -2688.84 1958 1 AAAAAAAAGFODAAAA United States CO Denver County 98 10.48 0.00 1.25 -576.24 1958 1 AAAAAAAAGNDAAAAA United States CO Denver County 87 53.79 0.00 19.36 -728.19 1958 1 AAAAAAAAIJBBAAAA United States CO Denver County 60 145.95 0.00 94.86 -265.80 1958 1 AAAAAAAAKIIAAAAA United States CO Denver County 1 52.95 0.00 2.11 -20.33 1958 1 AAAAAAAAKMECAAAA United States CO Denver County 72 99.98 0.00 72.98 2627.28 1958 1 AAAAAAAALDIAAAAA United States CO Denver County 19 102.24 0.00 56.23 396.15 1958 1 AAAAAAAALMEEAAAA United States CO Denver County 67 3.91 0.00 0.35 -129.98 1958 1 AAAAAAAANLEDAAAA United States CO Denver County 90 22.35 0.00 4.02 -1467.00 1958 1 AAAAAAAAAGODAAAA United States CO Douglas County 50 218.95 0.00 172.97 4987.00 1947 1 AAAAAAAADPICAAAA United States CO Douglas County 9 37.22 112.48 27.17 -114.28 1947 1 AAAAAAAAELEAAAAA United States CO Douglas County 37 148.13 0.00 5.92 -1982.09 1947 1 AAAAAAAAFLCEAAAA United States CO Douglas County 70 88.98 0.00 51.60 868.00 1947 1 AAAAAAAAGNDDAAAA United States CO Douglas County 41 34.05 0.00 2.38 -465.35 1947 1 AAAAAAAAGOIDAAAA United States CO Douglas County 82 104.28 0.00 90.72 4406.68 1947 1 AAAAAAAAIGCEAAAA United States CO Douglas County 20 131.96 926.28 102.92 -40.88 1947 1 AAAAAAAAJMFCAAAA United States CO Douglas County 2 233.52 0.00 70.05 -35.48 1947 1 AAAAAAAAMDICAAAA United States CO Douglas County 30 72.12 0.00 59.85 912.30 1947 1 AAAAAAAAMGDCAAAA United States CO Douglas County 7 50.02 0.00 44.51 -38.57 1947 1 AAAAAAAAOAJDAAAA United States CO Douglas County 70 60.34 2022.13 38.01 -1363.43 1947 1 AAAAAAAAONNAAAAA United States CO Douglas County 4 55.50 0.00 27.75 -80.40 1947 1 AAAAAAAAPBJAAAAA United States CO Douglas County 6 193.01 0.00 71.41 -156.42 1947 1 AAAAAAAAPGNDAAAA United States CO Douglas County 90 173.83 0.00 34.76 -3390.30 1947 1 AAAAAAAACEEBAAAA United States CO Eagle County 83 23.80 0.00 2.61 -1194.37 1956 2 AAAAAAAADMKDAAAA United States CO Eagle County 17 223.82 0.00 214.86 2322.20 1956 2 AAAAAAAAEPHDAAAA United States CO Eagle County 97 44.40 0.00 33.30 153.26 1956 2 AAAAAAAAFPEEAAAA United States CO Eagle County 16 107.53 0.00 81.72 703.84 1956 2 AAAAAAAAGMODAAAA United States CO Eagle County 64 169.41 0.00 3.38 -4245.76 1956 2 AAAAAAAAIFKCAAAA United States CO Eagle County 62 230.14 0.00 46.02 -1967.26 1956 2 AAAAAAAAILADAAAA United States CO Eagle County 61 38.14 0.00 16.40 10.37 1956 2 AAAAAAAAMDBEAAAA United States CO Eagle County 53 143.86 0.00 5.75 -2498.42 1956 2 AAAAAAAAMJDBAAAA United States CO Eagle County 100 65.60 2124.62 51.82 -272.62 1956 2 AAAAAAAAOHOCAAAA United States CO Eagle County 40 164.24 492.72 41.06 -1553.92 1956 2 AAAAAAAAPDEAAAAA United States CO Eagle County 48 36.25 0.00 6.16 -1300.80 1956 2 AAAAAAAAPHNCAAAA United States CO Eagle County 76 151.32 0.00 21.18 -3919.32 1956 2 AAAAAAAAPLLDAAAA United States CO Eagle County 74 31.40 0.00 12.24 -555.74 1956 2 AAAAAAAAACMDAAAA United States CO Elbert County 5 5.16 0.00 3.45 4.65 1927 1 AAAAAAAAADLAAAAA United States CO Elbert County 99 22.84 0.00 21.69 1109.79 1927 1 AAAAAAAAAKFEAAAA United States CO Elbert County 40 139.99 206.06 128.79 1612.34 1924 3 AAAAAAAABCDBAAAA United States CO Elbert County 72 50.15 0.00 46.63 884.16 1927 1 AAAAAAAABGJAAAAA United States CO Elbert County 33 118.09 0.00 89.74 380.49 1924 3 AAAAAAAADGNDAAAA United States CO Elbert County 59 93.20 0.00 71.76 2331.09 1927 1 AAAAAAAAEGOBAAAA United States CO Elbert County 22 144.11 0.00 28.82 -833.80 1927 1 AAAAAAAAEMCBAAAA United States CO Elbert County 43 8.02 0.00 4.09 -119.11 1927 1 AAAAAAAAGOGAAAAA United States CO Elbert County 58 18.70 0.00 8.78 -114.26 1927 1 AAAAAAAAHAIBAAAA United States CO Elbert County 76 7.61 0.00 4.26 99.56 1927 1 AAAAAAAAHJECAAAA United States CO Elbert County 80 61.68 0.00 28.98 -1793.60 1927 1 AAAAAAAAIPIAAAAA United States CO Elbert County 96 31.62 0.00 12.01 -1182.72 1924 3 AAAAAAAAKECAAAAA United States CO Elbert County 29 26.75 0.00 5.88 -343.36 1924 3 AAAAAAAAKKLDAAAA United States CO Elbert County 20 65.42 0.00 58.22 496.80 1927 1 AAAAAAAALBEAAAAA United States CO Elbert County 20 9.98 122.04 6.78 -157.04 1924 3 AAAAAAAAMLFDAAAA United States CO Elbert County 42 132.79 0.00 111.54 2656.50 1927 1 AAAAAAAAOBGEAAAA United States CO Elbert County 89 284.28 0.00 102.34 323.07 1927 1 AAAAAAAAOMFBAAAA United States CO Elbert County 79 124.53 363.99 92.15 3351.38 1924 3 AAAAAAAAOPCDAAAA United States CO Elbert County 99 32.56 0.00 4.55 -2619.54 1924 3 AAAAAAAAALKCAAAA United States CO Huerfano County 18 93.27 736.79 53.16 -494.33 1984 5 AAAAAAAACCDBAAAA United States CO Huerfano County 76 153.44 0.00 116.61 3585.68 1984 5 AAAAAAAACHGBAAAA United States CO Huerfano County 66 97.59 1468.52 92.71 -120.80 1984 5 AAAAAAAACOEAAAAA United States CO Huerfano County 8 68.60 0.00 66.54 33.36 1984 5 AAAAAAAADOFAAAAA United States CO Huerfano County 45 99.53 762.23 22.89 -1281.98 1984 5 AAAAAAAAHCJBAAAA United States CO Huerfano County 92 110.37 2662.37 50.77 -5626.61 1984 5 AAAAAAAAIABCAAAA United States CO Huerfano County 21 97.55 0.00 94.62 656.67 1984 5 AAAAAAAAANPDAAAA United States CO Jefferson County 81 10.20 112.10 3.46 -132.35 1939 6 AAAAAAAACCLBAAAA United States CO Jefferson County 44 150.24 0.00 18.02 -1440.56 1939 6 AAAAAAAADGHDAAAA United States CO Jefferson County 68 159.16 1916.37 36.60 -4324.93 1939 6 AAAAAAAAKFGBAAAA United States CO Jefferson County 26 97.84 0.00 39.13 -867.10 1939 6 AAAAAAAAKGGAAAAA United States CO Jefferson County 54 114.36 0.00 48.03 -1881.36 1939 6 AAAAAAAAMLIBAAAA United States CO Jefferson County 95 99.02 0.00 5.94 -2856.65 1939 6 AAAAAAAANFOCAAAA United States CO Jefferson County 94 40.46 1373.47 33.98 -17.05 1939 6 AAAAAAAANLKAAAAA United States CO Jefferson County 45 96.34 0.00 79.96 2033.10 1939 6 AAAAAAAACEBAAAAA United States CO Kit Carson County 69 12.85 0.00 11.82 287.73 1972 2 AAAAAAAADFLAAAAA United States CO Kit Carson County 58 184.27 0.00 162.15 5601.06 1972 2 AAAAAAAADNJDAAAA United States CO Kit Carson County 86 238.08 0.00 30.95 -5006.92 1972 2 AAAAAAAAGDLDAAAA United States CO Kit Carson County 6 161.87 0.00 147.30 434.16 1972 2 AAAAAAAAICMBAAAA United States CO Kit Carson County 78 49.89 0.00 47.89 2425.02 1972 2 AAAAAAAAJJEDAAAA United States CO Kit Carson County 12 269.21 0.00 43.07 -624.72 1972 2 AAAAAAAAKIJBAAAA United States CO Kit Carson County 23 247.03 0.00 242.08 3574.20 1972 2 AAAAAAAAKOFDAAAA United States CO Kit Carson County 1 197.42 0.00 96.73 14.47 1972 2 AAAAAAAAMANBAAAA United States CO Kit Carson County 37 55.87 0.00 12.29 -1135.53 1972 2 AAAAAAAANIEDAAAA United States CO Kit Carson County 37 48.79 0.00 16.58 -336.70 1972 2 AAAAAAAAPIJCAAAA United States CO Kit Carson County 98 95.75 0.00 46.91 902.58 1972 2 AAAAAAAAPNHCAAAA United States CO Kit Carson County 47 9.95 0.00 2.68 -170.14 1972 2 AAAAAAAABKFDAAAA United States CO La Plata County 90 36.61 0.00 33.31 899.10 1954 5 AAAAAAAAGHLCAAAA United States CO La Plata County 18 42.41 0.00 35.20 -60.48 1954 5 AAAAAAAAKBOBAAAA United States CO La Plata County 21 123.99 431.17 85.55 390.14 1954 5 AAAAAAAALFLBAAAA United States CO La Plata County 72 178.62 4853.27 91.09 -2988.47 1954 5 AAAAAAAAMDKDAAAA United States CO La Plata County 37 69.28 0.00 24.24 -1371.59 1954 5 AAAAAAAANHACAAAA United States CO La Plata County 92 180.96 0.00 85.05 -179.40 1954 5 AAAAAAAAEFLCAAAA United States CO Las Animas County 90 103.96 0.00 49.90 -594.00 1927 4 AAAAAAAAEHADAAAA United States CO Las Animas County 70 80.21 0.00 57.75 1731.80 1927 4 AAAAAAAAKKBBAAAA United States CO Las Animas County 37 108.40 0.00 4.33 -1671.29 1927 4 AAAAAAAAMCACAAAA United States CO Las Animas County 80 91.09 6233.13 85.62 -5949.13 1927 4 AAAAAAAAOFOCAAAA United States CO Las Animas County 57 64.00 0.00 3.84 -1009.47 1927 4 AAAAAAAAAAODAAAA United States CO Rio Blanco County 25 248.64 0.00 146.69 1190.75 1948 4 AAAAAAAAABAAAAAA United States CO Rio Blanco County 24 27.75 0.00 9.71 -317.52 1948 4 AAAAAAAAAEIBAAAA United States CO Rio Blanco County 76 9.73 0.00 3.50 -31.16 1948 4 AAAAAAAAANCCAAAA United States CO Rio Blanco County 84 49.99 0.00 22.49 -82.32 1925 2 AAAAAAAAAOJCAAAA United States CO Rio Blanco County 35 5.22 0.00 1.09 -104.65 1948 4 AAAAAAAACFBDAAAA United States CO Rio Blanco County 18 247.17 0.00 54.37 -539.82 1948 4 AAAAAAAAFABEAAAA United States CO Rio Blanco County 67 133.05 0.00 38.58 -2480.34 1948 4 AAAAAAAAFBNAAAAA United States CO Rio Blanco County 68 195.99 0.00 156.79 5918.72 1948 4 AAAAAAAAGBLCAAAA United States CO Rio Blanco County 62 1.21 0.00 0.22 -52.08 1948 4 AAAAAAAAGHIBAAAA United States CO Rio Blanco County 68 41.11 0.00 29.18 799.68 1948 4 AAAAAAAAGICAAAAA United States CO Rio Blanco County 41 21.35 0.00 10.46 -101.68 1925 2 AAAAAAAAHJGAAAAA United States CO Rio Blanco County 46 70.05 0.00 28.72 118.68 1925 2 AAAAAAAAHLNAAAAA United States CO Rio Blanco County 68 133.59 0.00 44.08 -1434.12 1925 2 AAAAAAAAIEODAAAA United States CO Rio Blanco County 65 82.15 0.00 2.46 -2999.75 1925 2 AAAAAAAAILLBAAAA United States CO Rio Blanco County 60 33.52 0.00 19.10 -151.80 1925 2 AAAAAAAAJEECAAAA United States CO Rio Blanco County 10 155.36 0.00 10.87 -779.10 1948 4 AAAAAAAALHJBAAAA United States CO Rio Blanco County 95 239.78 0.00 220.59 12519.10 1948 4 AAAAAAAAMEEDAAAA United States CO Rio Blanco County 19 68.85 0.00 44.75 -317.87 1925 2 AAAAAAAAMEHDAAAA United States CO Rio Blanco County 93 268.25 0.00 112.66 1535.43 1948 4 AAAAAAAAMLDAAAAA United States CO Rio Blanco County 98 75.38 0.00 74.62 3253.60 1925 2 AAAAAAAANKJCAAAA United States CO Rio Blanco County 16 98.09 0.00 89.26 -141.28 1948 4 AAAAAAAAAGFCAAAA United States CO Routt County 70 187.00 0.00 16.83 -5366.90 1951 2 AAAAAAAADABDAAAA United States CO Routt County 54 108.39 0.00 50.94 -2168.10 1951 2 AAAAAAAAFCIBAAAA United States CO Routt County 44 184.34 0.00 62.67 -980.32 1951 2 AAAAAAAAFMEEAAAA United States CO Routt County 23 187.92 0.00 62.01 -14.49 1951 2 AAAAAAAAGOFDAAAA United States CO Routt County 52 109.18 126.96 4.36 -3539.72 1951 2 AAAAAAAAHFICAAAA United States CO Routt County 98 122.14 6010.68 65.95 -4279.02 1951 2 AAAAAAAAHLMBAAAA United States CO Routt County 92 32.35 0.00 21.99 -357.88 1951 2 AAAAAAAAKEBEAAAA United States CO Routt County 18 147.36 0.00 48.62 -230.04 1951 2 AAAAAAAAOLPAAAAA United States CO Routt County 19 98.19 0.00 42.22 -848.92 1951 2 AAAAAAAAPMDBAAAA United States CO Routt County 64 121.41 3566.24 109.26 -1554.72 1951 2 AAAAAAAACIAEAAAA United States IN Bartholomew County 29 65.53 0.00 39.97 7.25 1926 1 AAAAAAAAGCLAAAAA United States IN Bartholomew County 95 40.01 0.00 28.00 56.05 1926 1 AAAAAAAAHBBEAAAA United States IN Bartholomew County 2 115.44 0.00 61.18 -76.68 1926 1 AAAAAAAAJPNAAAAA United States IN Bartholomew County 19 61.22 0.00 27.54 90.82 1926 1 AAAAAAAAKEJDAAAA United States IN Bartholomew County 29 76.77 0.00 75.23 1009.78 1926 1 AAAAAAAAMJEDAAAA United States IN Bartholomew County 90 96.65 0.00 14.49 -6005.70 1926 1 AAAAAAAAMJEEAAAA United States IN Bartholomew County 74 254.71 0.00 99.33 16.28 1926 1 AAAAAAAAPAEAAAAA United States IN Bartholomew County 59 150.06 0.00 127.55 3501.06 1926 1 AAAAAAAAAHKCAAAA United States IN Blackford County 50 133.58 0.00 13.35 -3064.00 1932 2 AAAAAAAACKNDAAAA United States IN Blackford County 86 7.73 0.00 2.39 -98.04 1932 2 AAAAAAAAEMABAAAA United States IN Blackford County 74 255.05 0.00 252.49 12130.82 1932 2 AAAAAAAAFOIBAAAA United States IN Blackford County 48 232.32 0.00 85.95 -282.24 1932 2 AAAAAAAAGCBCAAAA United States IN Blackford County 49 125.56 0.00 111.74 1427.37 1932 2 AAAAAAAAGLJDAAAA United States IN Blackford County 19 109.56 49.94 32.86 -199.47 1932 2 AAAAAAAAMACDAAAA United States IN Blackford County 5 27.17 0.00 26.62 52.70 1932 2 AAAAAAAANFNDAAAA United States IN Blackford County 57 99.53 0.00 0.99 -2037.18 1932 2 AAAAAAAAADFCAAAA United States IN Clinton County 5 97.97 19.59 19.59 -383.79 1947 0 AAAAAAAABOPBAAAA United States IN Clinton County 13 97.92 0.00 77.35 405.08 1947 0 AAAAAAAAEKDCAAAA United States IN Clinton County 89 71.55 3048.71 40.78 -3581.82 1947 0 AAAAAAAAEMMAAAAA United States IN Clinton County 15 147.64 1.77 2.95 -1117.02 1947 0 AAAAAAAAEPDAAAAA United States IN Clinton County 92 100.42 1075.34 12.05 -3185.82 1947 0 AAAAAAAAFIOBAAAA United States IN Clinton County 85 29.57 0.00 7.39 -1616.70 1947 0 AAAAAAAALDODAAAA United States IN Clinton County 64 80.08 0.00 55.25 -1254.40 1947 0 AAAAAAAAMEICAAAA United States IN Clinton County 6 49.80 0.00 14.94 -46.20 1947 0 AAAAAAAAMIPDAAAA United States IN Clinton County 54 89.07 0.00 12.46 -1744.20 1947 0 AAAAAAAAMMAEAAAA United States IN Clinton County 38 58.45 0.00 23.96 114.38 1947 0 AAAAAAAANFHDAAAA United States IN Clinton County 53 239.50 1726.31 38.32 -4485.49 1947 0 AAAAAAAANNIAAAAA United States IN Clinton County 62 7.46 0.00 1.64 -159.96 1947 0 AAAAAAAAOAMDAAAA United States IN Clinton County 48 51.10 0.00 19.92 -847.68 1947 0 AAAAAAAABLBAAAAA United States IN Daviess County 66 207.37 0.00 194.92 7232.28 1948 3 AAAAAAAAGCDCAAAA United States IN Daviess County 29 201.75 0.00 133.15 1891.38 1948 3 AAAAAAAAKJBDAAAA United States IN Daviess County 28 219.28 0.00 17.54 -1843.52 1948 3 AAAAAAAALBCCAAAA United States IN Daviess County 45 47.55 0.00 35.18 573.75 1948 3 AAAAAAAAFHGBAAAA United States IN Franklin County 38 48.28 0.00 9.17 -699.96 1943 1 AAAAAAAAGALAAAAA United States IN Franklin County 70 48.12 1919.98 48.12 50.52 1943 1 AAAAAAAAKGPBAAAA United States IN Franklin County 57 73.37 0.00 38.88 625.86 1943 1 AAAAAAAANBGCAAAA United States IN Franklin County 29 45.82 0.00 30.69 117.45 1943 1 AAAAAAAAPJGBAAAA United States IN Franklin County 82 20.62 0.00 6.80 -431.32 1943 1 AAAAAAAABGIBAAAA United States IN Hamilton County 60 209.08 0.00 188.17 5400.60 1931 6 AAAAAAAAEIEDAAAA United States IN Hamilton County 73 90.54 0.00 77.86 3244.85 1931 6 AAAAAAAAFLPDAAAA United States IN Hamilton County 94 63.02 0.00 16.38 -3749.66 1931 6 AAAAAAAAGOBBAAAA United States IN Hamilton County 10 149.29 0.00 52.25 -126.60 1931 6 AAAAAAAAIKCCAAAA United States IN Hamilton County 84 86.11 0.00 76.63 3484.32 1931 6 AAAAAAAAKDCBAAAA United States IN Hamilton County 77 265.18 0.00 238.66 10978.66 1931 6 AAAAAAAANCHAAAAA United States IN Hamilton County 52 82.81 1822.22 76.18 -790.54 1931 6 AAAAAAAANGCBAAAA United States IN Hamilton County 62 148.12 0.00 60.72 -1365.86 1931 6 AAAAAAAAOKPCAAAA United States IN Hamilton County 45 151.67 0.00 63.70 -479.25 1931 6 AAAAAAAAOOHCAAAA United States IN Hamilton County 53 42.68 0.00 34.14 971.49 1931 6 AAAAAAAAAJIDAAAA United States IN Hancock County 80 198.99 0.00 119.39 2890.40 1985 5 AAAAAAAAAKKCAAAA United States IN Hancock County 11 38.97 289.76 26.88 -309.34 1956 3 AAAAAAAACHNAAAAA United States IN Hancock County 26 44.43 0.00 35.54 438.62 1985 5 AAAAAAAACLFEAAAA United States IN Hancock County 71 156.63 0.00 23.49 -3044.48 1985 5 AAAAAAAACODAAAAA United States IN Hancock County 13 23.87 0.00 10.98 -23.27 1956 3 AAAAAAAAEIIAAAAA United States IN Hancock County 88 48.77 970.78 38.04 313.14 1956 3 AAAAAAAAEMFCAAAA United States IN Hancock County 68 292.00 0.00 277.40 12086.32 1985 5 AAAAAAAAEMLCAAAA United States IN Hancock County 11 79.75 0.00 78.95 85.14 1985 5 --- 200 row(s) selected.