Query 1:
Table: item
i_item_sk: min=8395, max=15115
i_rec_start_date: min=1997-10-27, max=2001-10-27
i_rec_end_date: min=2000-10-26, max=2001-10-26
i_current_price: min=0.23, max=9.53
i_wholesale_cost: min=0.09, max=5.35
i_brand_id: min=2002001, max=9012004
i_class_id: min=1, max=12
i_category_id: min=2, max=9
i_manufact_id: min=808, max=808
i_manager_id: min=8, max=95
Table: date_dim
d_date_sk: min=2415355, max=2488069
d_date: min=1900-12-01, max=2099-12-31
d_month_seq: min=11, max=2399
d_week_seq: min=48, max=10436
d_quarter_seq: min=5, max=801
d_year: min=1900, max=2099
d_dow: min=0, max=6
d_moy: min=12, max=12
d_dom: min=1, max=31
d_qoy: min=4, max=4
d_fy_year: min=1900, max=2099
d_fy_quarter_seq: min=5, max=801
d_fy_week_seq: min=48, max=10436
d_first_dom: min=2415355, max=2488039
d_last_dom: min=2415689, max=2488372
d_same_day_ly: min=2414990, max=2487704
d_same_day_lq: min=2415263, max=2487977
Join Type: Index Cond
Join Keys: ['store_sales.ss_item_sk=item.i_item_sk']
Join Type: Index Cond
Join Keys: ['date_dim.d_date_sk=store_sales.ss_sold_date_sk']
Query 2:
Table: item
i_item_sk: min=1, max=17995
i_rec_start_date: min=1997-10-27, max=2001-10-27
i_rec_end_date: min=1999-10-27, max=2001-10-26
i_current_price: min=0.09, max=99.96
i_wholesale_cost: min=0.03, max=85.83
i_brand_id: min=1001001, max=10016017
i_class_id: min=1, max=16
i_category_id: min=5, max=10
i_manufact_id: min=1, max=1000
i_manager_id: min=1, max=100
Table: date_dim
d_date_sk: min=2450860, max=2450888
d_date: min=1998-02-15, max=1998-03-15
d_month_seq: min=1177, max=1178
d_week_seq: min=5120, max=5124
d_quarter_seq: min=393, max=394
d_year: min=1998, max=1998
d_dow: min=0, max=6
d_moy: min=2, max=3
d_dom: min=1, max=28
d_qoy: min=1, max=1
d_fy_year: min=1998, max=1998
d_fy_quarter_seq: min=393, max=394
d_fy_week_seq: min=5120, max=5124
d_first_dom: min=2450846, max=2450874
d_last_dom: min=2450876, max=2450932
d_same_day_ly: min=2450495, max=2450523
d_same_day_lq: min=2450768, max=2450796
Join Type: Hash Join
Join Keys: ['web_sales.ws_sold_date_sk=date_dim.d_date_sk']
Join Type: Index Cond
Join Keys: ['item.i_item_sk=web_sales.ws_item_sk']
Query 3:
Table: customer_demographics
cd_demo_sk: min=9, max=1920764
cd_purchase_estimate: min=500, max=10000
cd_dep_count: min=0, max=6
cd_dep_employed_count: min=0, max=6
cd_dep_college_count: min=0, max=6
Table: household_demographics
hd_demo_sk: min=120, max=6479
hd_income_band_sk: min=1, max=20
hd_dep_count: min=1, max=3
hd_vehicle_count: min=-1, max=4
Table: date_dim
d_date_sk: min=2451911, max=2452275
d_date: min=2001-01-01, max=2001-12-31
d_month_seq: min=1212, max=1223
d_week_seq: min=5270, max=5322
d_quarter_seq: min=405, max=409
d_year: min=2001, max=2001
d_dow: min=0, max=6
d_moy: min=1, max=12
d_dom: min=1, max=31
d_qoy: min=1, max=4
d_fy_year: min=2001, max=2001
d_fy_quarter_seq: min=405, max=409
d_fy_week_seq: min=5270, max=5322
d_first_dom: min=2451911, max=2452245
d_last_dom: min=2451910, max=2452578
d_same_day_ly: min=2451545, max=2451910
d_same_day_lq: min=2451819, max=2452183
Join Type: Nested Loop
Join Keys: ['store_sales.ss_hdemo_sk=household_demographics.hd_demo_sk']
Join Type: Hash Join
Join Keys: ['store_sales.ss_sold_date_sk=date_dim.d_date_sk']
Join Type: Index Cond
Join Keys: ['customer_address.ca_address_sk=store_sales.ss_addr_sk']
Join Type: Index Cond
Join Keys: ['customer_demographics.cd_demo_sk=store_sales.ss_cdemo_sk']
Join Type: Index Cond
Join Keys: ['store.s_store_sk=store_sales.ss_store_sk']
Query 4:
Table: date_dim
d_date_sk: min=2452367, max=2452457
d_date: min=2002-04-02, max=2002-07-01
d_month_seq: min=1227, max=1230
d_week_seq: min=5336, max=5348
d_quarter_seq: min=410, max=411
d_year: min=2002, max=2002
d_dow: min=0, max=6
d_moy: min=4, max=7
d_dom: min=1, max=31
d_qoy: min=2, max=2
d_fy_year: min=2002, max=2002
d_fy_quarter_seq: min=410, max=411
d_fy_week_seq: min=5336, max=5348
d_first_dom: min=2452366, max=2452457
d_last_dom: min=2452455, max=2452637
d_same_day_ly: min=2452002, max=2452092
d_same_day_lq: min=2452277, max=2452366
Join Type: Hash Join
Join Keys: ['catalog_sales.cs_sold_date_sk=date_dim.d_date_sk']
Join Type: Index Cond
Join Keys: ['customer.c_customer_sk=catalog_sales.cs_bill_customer_sk']
Join Type: Index Cond
Join Keys: ['customer_address.ca_address_sk=customer.c_current_addr_sk']
Query 5:
Table: customer
c_customer_sk: min=1, max=100000
c_current_cdemo_sk: min=44, max=1920750
c_current_hdemo_sk: min=1, max=7200
c_current_addr_sk: min=1, max=50000
c_first_shipto_date_sk: min=2449028, max=2452678
c_first_sales_date_sk: min=2448998, max=2452648
c_birth_day: min=1, max=31
c_birth_month: min=2, max=12
c_birth_year: min=1924, max=1992
c_last_review_date_sk: min=2452283, max=2452648
Table: customer_address
ca_address_sk: min=5, max=49994
ca_gmt_offset: min=-6.00, max=-5.00
Table: customer_demographics
cd_demo_sk: min=21, max=1920759
cd_purchase_estimate: min=500, max=10000
cd_dep_count: min=0, max=6
cd_dep_employed_count: min=0, max=6
cd_dep_college_count: min=0, max=6
Table: date_dim
d_date_sk: min=2451545, max=2451910
d_date: min=2000-01-01, max=2000-12-31
d_month_seq: min=1200, max=1211
d_week_seq: min=5218, max=5270
d_quarter_seq: min=401, max=405
d_year: min=2000, max=2000
d_dow: min=0, max=6
d_moy: min=1, max=12
d_dom: min=1, max=31
d_qoy: min=1, max=4
d_fy_year: min=2000, max=2000
d_fy_quarter_seq: min=401, max=405
d_fy_week_seq: min=5218, max=5270
d_first_dom: min=2451545, max=2451880
d_last_dom: min=2451544, max=2452214
d_same_day_ly: min=2451180, max=2451544
d_same_day_lq: min=2451453, max=2451818
Join Type: Hash Join
Join Keys: ['catalog_sales.cs_sold_date_sk=date_dim.d_date_sk']
Join Type: Index Cond
Join Keys: ['customer_demographics.cd_demo_sk=catalog_sales.cs_bill_cdemo_sk']
Join Type: Index Cond
Join Keys: ['customer.c_customer_sk=catalog_sales.cs_bill_customer_sk']
Join Type: Index Cond
Join Keys: ['customer_address.ca_address_sk=customer.c_current_addr_sk']
Join Type: Index Cond
Join Keys: ['customer_demographics.cd_demo_sk=customer.c_current_cdemo_sk']
Join Type: Index Cond
Join Keys: ['item.i_item_sk=catalog_sales.cs_item_sk']
Query 6:
Table: item
i_item_sk: min=1, max=17995
i_rec_start_date: min=1997-10-27, max=2001-10-27
i_rec_end_date: min=1999-10-27, max=2001-10-26
i_current_price: min=0.09, max=99.96
i_wholesale_cost: min=0.03, max=85.83
i_brand_id: min=1001001, max=10016017
i_class_id: min=1, max=16
i_category_id: min=5, max=10
i_manufact_id: min=1, max=1000
i_manager_id: min=1, max=100
Table: date_dim
d_date_sk: min=2450860, max=2450888
d_date: min=1998-02-15, max=1998-03-15
d_month_seq: min=1177, max=1178
d_week_seq: min=5120, max=5124
d_quarter_seq: min=393, max=394
d_year: min=1998, max=1998
d_dow: min=0, max=6
d_moy: min=2, max=3
d_dom: min=1, max=28
d_qoy: min=1, max=1
d_fy_year: min=1998, max=1998
d_fy_quarter_seq: min=393, max=394
d_fy_week_seq: min=5120, max=5124
d_first_dom: min=2450846, max=2450874
d_last_dom: min=2450876, max=2450932
d_same_day_ly: min=2450495, max=2450523
d_same_day_lq: min=2450768, max=2450796
Join Type: Hash Join
Join Keys: ['catalog_sales.cs_sold_date_sk=date_dim.d_date_sk']
Join Type: Index Cond
Join Keys: ['item.i_item_sk=catalog_sales.cs_item_sk']
Query 7:
Table: date_dim
d_date_sk: min=2450815, max=2451179
d_date: min=1998-01-01, max=1998-12-31
d_month_seq: min=1176, max=1187
d_week_seq: min=5114, max=5166
d_quarter_seq: min=393, max=397
d_year: min=1998, max=1998
d_dow: min=0, max=6
d_moy: min=1, max=12
d_dom: min=1, max=31
d_qoy: min=1, max=4
d_fy_year: min=1998, max=1998
d_fy_quarter_seq: min=393, max=397
d_fy_week_seq: min=5114, max=5166
d_first_dom: min=2450815, max=2451149
d_last_dom: min=2450814, max=2451482
d_same_day_ly: min=2450450, max=2450814
d_same_day_lq: min=2450723, max=2451087
Join Type: Hash Join
Join Keys: ['inventory.inv_item_sk=item.i_item_sk']
Join Type: Hash Join
Join Keys: ['inventory.inv_date_sk=date_dim.d_date_sk']
Query 8:
Table: date_dim
d_date_sk: min=2452366, max=2452395
d_date: min=2002-04-01, max=2002-04-30
d_month_seq: min=1227, max=1227
d_week_seq: min=5335, max=5340
d_quarter_seq: min=410, max=410
d_year: min=2002, max=2002
d_dow: min=0, max=6
d_moy: min=4, max=4
d_dom: min=1, max=30
d_qoy: min=1, max=2
d_fy_year: min=2002, max=2002
d_fy_quarter_seq: min=410, max=410
d_fy_week_seq: min=5335, max=5340
d_first_dom: min=2452366, max=2452366
d_last_dom: min=2452455, max=2452455
d_same_day_ly: min=2452001, max=2452030
d_same_day_lq: min=2452276, max=2452305
Join Type: Nested Loop
Join Keys: ['store_sales.ss_store_sk=store.s_store_sk']
Join Type: Index Cond
Join Keys: ['store_sales.ss_item_sk=store_returns.sr_item_sk']
Join Type: Index Cond
Join Keys: ['store_sales.ss_ticket_number=store_returns.sr_ticket_number']
Join Type: Index Cond
Join Keys: ['catalog_sales.cs_item_sk=store_sales.ss_item_sk']
Join Type: Index Cond
Join Keys: ['date_dim.d_date_sk=store_sales.ss_sold_date_sk']
Join Type: Index Cond
Join Keys: ['date_dim.d_date_sk=catalog_sales.cs_sold_date_sk']
Join Type: Index Cond
Join Keys: ['item.i_item_sk=store_sales.ss_item_sk']
Query 9:
Table: store
s_store_sk: min=1, max=12
s_rec_start_date: min=1997-03-13, max=2001-03-13
s_rec_end_date: min=1999-03-13, max=2001-03-12
s_closed_date_sk: min=2450910, max=2451189
s_number_employees: min=218, max=294
s_floor_space: min=5219562, max=9341467
s_market_id: min=2, max=10
s_division_id: min=1, max=1
s_company_id: min=1, max=1
s_gmt_offset: min=-5.00, max=-5.00
s_tax_precentage: min=0.01, max=0.11
Table: household_demographics
hd_demo_sk: min=360, max=6479
hd_income_band_sk: min=1, max=20
hd_dep_count: min=0, max=9
hd_vehicle_count: min=-1, max=4
Table: date_dim
d_date_sk: min=2451183, max=2452275
d_date: min=1999-01-04, max=2001-12-31
d_month_seq: min=1188, max=1223
d_week_seq: min=5166, max=5322
d_quarter_seq: min=397, max=409
d_year: min=1999, max=2001
d_dow: min=1, max=1
d_moy: min=1, max=12
d_dom: min=1, max=31
d_qoy: min=1, max=4
d_fy_year: min=1999, max=2001
d_fy_quarter_seq: min=397, max=409
d_fy_week_seq: min=5166, max=5322
d_first_dom: min=2451180, max=2452245
d_last_dom: min=2451179, max=2452578
d_same_day_ly: min=2450818, max=2451910
d_same_day_lq: min=2451091, max=2452183
Join Type: Nested Loop
Join Keys: ['store_sales.ss_store_sk=store.s_store_sk']
Join Type: Hash Join
Join Keys: ['store_sales.ss_sold_date_sk=date_dim.d_date_sk']
Join Type: Index Cond
Join Keys: ['household_demographics.hd_demo_sk=store_sales.ss_hdemo_sk']
Join Type: Index Cond
Join Keys: ['customer.c_customer_sk=store_sales.ss_customer_sk']
Query 10:
Table: date_dim
d_date_sk: min=2450815, max=2451179
d_date: min=1998-01-01, max=1998-12-31
d_month_seq: min=1176, max=1187
d_week_seq: min=5114, max=5166
d_quarter_seq: min=393, max=397
d_year: min=1998, max=1998
d_dow: min=0, max=6
d_moy: min=1, max=12
d_dom: min=1, max=31
d_qoy: min=1, max=4
d_fy_year: min=1998, max=1998
d_fy_quarter_seq: min=393, max=397
d_fy_week_seq: min=5114, max=5166
d_first_dom: min=2450815, max=2451149
d_last_dom: min=2450814, max=2451482
d_same_day_ly: min=2450450, max=2450814
d_same_day_lq: min=2450723, max=2451087
Join Type: Hash Join
Join Keys: ['store_sales.ss_store_sk=store.s_store_sk']
Join Type: Hash Join
Join Keys: ['store_sales.ss_sold_date_sk=date_dim.d_date_sk']
Join Type: Index Cond
Join Keys: ['item.i_item_sk=store_sales.ss_item_sk']
Query 11:
Table: date_dim
d_date_sk: min=2450815, max=2451179
d_date: min=1998-01-01, max=1998-12-31
d_month_seq: min=1176, max=1187
d_week_seq: min=5114, max=5166
d_quarter_seq: min=393, max=397
d_year: min=1998, max=1998
d_dow: min=0, max=6
d_moy: min=1, max=12
d_dom: min=1, max=31
d_qoy: min=1, max=4
d_fy_year: min=1998, max=1998
d_fy_quarter_seq: min=393, max=397
d_fy_week_seq: min=5114, max=5166
d_first_dom: min=2450815, max=2451149
d_last_dom: min=2450814, max=2451482
d_same_day_ly: min=2450450, max=2450814
d_same_day_lq: min=2450723, max=2451087
Join Type: Hash Join
Join Keys: ['store_sales.ss_sold_date_sk=date_dim.d_date_sk']
Join Type: Index Cond
Join Keys: ['customer.c_customer_sk=store_sales.ss_customer_sk']
Join Type: Index Cond
Join Keys: ['customer.c_customer_sk=catalog_sales.cs_bill_customer_sk']
Join Type: Index Cond
Join Keys: ['customer.c_customer_sk=web_sales.ws_bill_customer_sk']
Query 12:
Table: customer_address
ca_address_sk: min=1, max=49997
ca_gmt_offset: min=-7.00, max=-7.00
Table: customer_demographics
cd_demo_sk: min=57, max=1920792
cd_purchase_estimate: min=500, max=10000
cd_dep_count: min=0, max=6
cd_dep_employed_count: min=0, max=6
cd_dep_college_count: min=0, max=6
Table: household_demographics
hd_demo_sk: min=80, max=7179
hd_income_band_sk: min=1, max=20
hd_dep_count: min=0, max=9
hd_vehicle_count: min=-1, max=4
Table: date_dim
d_date_sk: min=2452245, max=2452275
d_date: min=2001-12-01, max=2001-12-31
d_month_seq: min=1223, max=1223
d_week_seq: min=5318, max=5322
d_quarter_seq: min=409, max=409
d_year: min=2001, max=2001
d_dow: min=0, max=6
d_moy: min=12, max=12
d_dom: min=1, max=31
d_qoy: min=4, max=4
d_fy_year: min=2001, max=2001
d_fy_quarter_seq: min=409, max=409
d_fy_week_seq: min=5318, max=5322
d_first_dom: min=2452245, max=2452245
d_last_dom: min=2452578, max=2452578
d_same_day_ly: min=2451880, max=2451910
d_same_day_lq: min=2452153, max=2452183
Join Type: Hash Join
Join Keys: ['catalog_returns.cr_returned_date_sk=date_dim.d_date_sk']
Join Type: Index Cond
Join Keys: ['customer.c_customer_sk=catalog_returns.cr_returning_customer_sk']
Join Type: Index Cond
Join Keys: ['household_demographics.hd_demo_sk=customer.c_current_hdemo_sk']
Join Type: Index Cond
Join Keys: ['customer_address.ca_address_sk=customer.c_current_addr_sk']
Join Type: Index Cond
Join Keys: ['call_center.cc_call_center_sk=catalog_returns.cr_call_center_sk']
Join Type: Index Cond
Join Keys: ['customer_demographics.cd_demo_sk=customer.c_current_cdemo_sk']
Query 13:
Table: item
i_item_sk: min=797, max=17172
i_rec_start_date: min=1997-10-27, max=2001-10-27
i_rec_end_date: min=1999-10-27, max=2001-10-26
i_current_price: min=0.45, max=72.61
i_wholesale_cost: min=0.19, max=55.53
i_brand_id: min=1001001, max=10014016
i_class_id: min=1, max=15
i_category_id: min=1, max=10
i_manufact_id: min=74, max=74
i_manager_id: min=2, max=97
Table: date_dim
d_date_sk: min=2451551, max=2451642
d_date: min=2000-01-07, max=2000-04-07
d_month_seq: min=1200, max=1203
d_week_seq: min=5219, max=5232
d_quarter_seq: min=401, max=402
d_year: min=2000, max=2000
d_dow: min=0, max=6
d_moy: min=1, max=4
d_dom: min=1, max=31
d_qoy: min=1, max=2
d_fy_year: min=2000, max=2000
d_fy_quarter_seq: min=401, max=402
d_fy_week_seq: min=5219, max=5232
d_first_dom: min=2451545, max=2451636
d_last_dom: min=2451544, max=2451726
d_same_day_ly: min=2451186, max=2451276
d_same_day_lq: min=2451459, max=2451551
Join Type: Hash Join
Join Keys: ['web_sales.ws_item_sk=item.i_item_sk']
Join Type: Hash Join
Join Keys: ['web_sales.ws_sold_date_sk=date_dim.d_date_sk']
Join Type: Index Cond
Join Keys: ['web_sales.ws_item_sk=item.i_item_sk']
Query 14:
Table: customer_address
ca_address_sk: min=25, max=49963
ca_gmt_offset: min=-5.00, max=-5.00
Table: web_site
web_site_sk: min=20, max=30
web_rec_start_date: min=1997-08-16, max=2001-08-16
web_rec_end_date: min=1999-08-16, max=2001-08-15
web_open_date_sk: min=2450577, max=2450645
web_close_date_sk: min=2448752, max=2448820
web_mkt_id: min=4, max=5
web_company_id: min=1, max=4
web_gmt_offset: min=-5.00, max=-5.00
web_tax_percentage: min=0.04, max=0.12
Table: date_dim
d_date_sk: min=2451605, max=2451666
d_date: min=2000-03-01, max=2000-05-01
d_month_seq: min=1202, max=1204
d_week_seq: min=5227, max=5235
d_quarter_seq: min=402, max=402
d_year: min=2000, max=2000
d_dow: min=0, max=6
d_moy: min=3, max=5
d_dom: min=1, max=31
d_qoy: min=1, max=2
d_fy_year: min=2000, max=2000
d_fy_quarter_seq: min=402, max=402
d_fy_week_seq: min=5227, max=5235
d_first_dom: min=2451605, max=2451666
d_last_dom: min=2451664, max=2451786
d_same_day_ly: min=2451239, max=2451300
d_same_day_lq: min=2451513, max=2451575
Query 15:
Table: store
s_store_sk: min=4, max=4
s_rec_start_date: min=1997-03-13, max=1997-03-13
s_rec_end_date: min=1999-03-13, max=1999-03-13
s_closed_date_sk: min=2451044, max=2451044
s_number_employees: min=218, max=218
s_floor_space: min=9341467, max=9341467
s_market_id: min=4, max=4
s_division_id: min=1, max=1
s_company_id: min=1, max=1
s_gmt_offset: min=-5.00, max=-5.00
s_tax_precentage: min=0.03, max=0.03
Table: time_dim
t_time_sk: min=55800, max=57599
t_time: min=55800, max=57599
t_hour: min=15, max=15
t_minute: min=30, max=59
t_second: min=0, max=59
Table: household_demographics
hd_demo_sk: min=840, max=6959
hd_income_band_sk: min=1, max=20
hd_dep_count: min=7, max=7
hd_vehicle_count: min=-1, max=4
Join Type: Hash Join
Join Keys: ['store_sales.ss_store_sk=store.s_store_sk']
Join Type: Hash Join
Join Keys: ['store_sales.ss_hdemo_sk=household_demographics.hd_demo_sk']
Join Type: Index Cond
Join Keys: ['time_dim.t_time_sk=store_sales.ss_sold_time_sk']