Details
-
Bug
-
Status: Resolved
-
Minor
-
Resolution: Duplicate
-
None
-
None
-
None
Description
select ca_zip ,sum(cs_sales_price) from catalog_sales ,customer ,customer_address ,date_dim where cs_bill_customer_sk = c_customer_sk and c_current_addr_sk = ca_address_sk and ( substr(ca_zip,1,5) in ('85669', '86197','88274','83405','86475', '85392', '85460', '80348', '81792') or ca_state in ('CA','WA','GA') or cs_sales_price > 500) and cs_sold_date_sk = d_date_sk and d_qoy = 2 and d_year = 2000 group by ca_zip order by ca_zip limit 100;
The above query is TPC-DS query15. The logical planner generates the plan as the following. Some filters are in the SELECTION(4) but after optimizing there are no filters in the plan. Optimizer may removes some filters.
PROJECTION(8) => Targets: tpcds.customer_address.ca_zip (TEXT), ?sum (FLOAT8) => out schema: {(2) tpcds.customer_address.ca_zip (TEXT), ?sum (FLOAT8)} => in schema: {(2) tpcds.customer_address.ca_zip (TEXT), ?sum (FLOAT8)} LIMIT(7) 100 SORT(6) => Sort Keys: tpcds.customer_address.ca_zip (TEXT) (asc) GROUP_BY(5)(ca_zip) => exprs: (sum(tpcds.catalog_sales.cs_sales_price (FLOAT4))) => target list: tpcds.customer_address.ca_zip (TEXT), ?sum (FLOAT8) => out schema:{(2) tpcds.customer_address.ca_zip (TEXT), ?sum (FLOAT8)} => in schema:{(95) tpcds.catalog_sales.cs_sold_date_sk (INT4), tpcds.catalog_sales.cs_sold_time_sk (INT4), tpcds.catalog_sales.cs_ship_date_sk (INT4), tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_bill_cdemo_sk (INT4), tpcds.catalog_sales.cs_bill_hdemo_sk (INT4), tpcds.catalog_sales.cs_bill_addr_sk (INT4), tpcds.catalog_sales.cs_ship_customer_sk (INT4), tpcds.catalog_sales.cs_ship_cdemo_sk (INT4), tpcds.catalog_sales.cs_ship_hdemo_sk (INT4), tpcds.catalog_sales.cs_ship_addr_sk (INT4), tpcds.catalog_sales.cs_call_center_sk (INT4), tpcds.catalog_sales.cs_catalog_page_sk (INT4), tpcds.catalog_sales.cs_ship_mode_sk (INT4), tpcds.catalog_sales.cs_warehouse_sk (INT4), tpcds.catalog_sales.cs_item_sk (INT4), tpcds.catalog_sales.cs_promo_sk (INT4), tpcds.catalog_sales.cs_order_number (INT4), tpcds.catalog_sales.cs_quantity (INT4), tpcds.catalog_sales.cs_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_list_price (FLOAT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_discount_amt (FLOAT4), tpcds.catalog_sales.cs_ext_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_ext_list_price (FLOAT4), tpcds.catalog_sales.cs_ext_tax (FLOAT4), tpcds.catalog_sales.cs_coupon_amt (FLOAT4), tpcds.catalog_sales.cs_ext_ship_cost (FLOAT4), tpcds.catalog_sales.cs_net_paid (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_tax (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship_tax (FLOAT4), tpcds.catalog_sales.cs_net_profit (FLOAT4), tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_customer_id (TEXT), tpcds.customer.c_current_cdemo_sk (INT4), tpcds.customer.c_current_hdemo_sk (INT4), tpcds.customer.c_current_addr_sk (INT4), tpcds.customer.c_first_shipto_date_sk (INT4), tpcds.customer.c_first_sales_date_sk (INT4), tpcds.customer.c_salutation (TEXT), tpcds.customer.c_first_name (TEXT), tpcds.customer.c_last_name (TEXT), tpcds.customer.c_preferred_cust_flag (TEXT), tpcds.customer.c_birth_day (INT4), tpcds.customer.c_birth_month (INT4), tpcds.customer.c_birth_year (INT4), tpcds.customer.c_birth_country (TEXT), tpcds.customer.c_login (TEXT), tpcds.customer.c_email_address (TEXT), tpcds.customer.c_last_review_date (TEXT), tpcds.customer_address.ca_zip (TEXT), ?and_1 (BOOLEAN), tpcds.customer_address.ca_address_sk (INT4), tpcds.customer_address.ca_address_id (TEXT), tpcds.customer_address.ca_street_number (TEXT), tpcds.customer_address.ca_street_name (TEXT), tpcds.customer_address.ca_street_type (TEXT), tpcds.customer_address.ca_suite_number (TEXT), tpcds.customer_address.ca_city (TEXT), tpcds.customer_address.ca_county (TEXT), tpcds.customer_address.ca_state (TEXT), ?fake0 (TEXT), tpcds.customer_address.ca_country (TEXT), tpcds.customer_address.ca_gmt_offset (FLOAT4), tpcds.customer_address.ca_location_type (TEXT), tpcds.date_dim.d_date_sk (INT4), tpcds.date_dim.d_date_id (TEXT), tpcds.date_dim.d_date (DATE), tpcds.date_dim.d_month_seq (INT4), tpcds.date_dim.d_week_seq (INT4), tpcds.date_dim.d_quarter_seq (INT4), tpcds.date_dim.d_year (INT4), tpcds.date_dim.d_dow (INT4), tpcds.date_dim.d_moy (INT4), tpcds.date_dim.d_dom (INT4), tpcds.date_dim.d_qoy (INT4), tpcds.date_dim.d_fy_year (INT4), tpcds.date_dim.d_fy_quarter_seq (INT4), tpcds.date_dim.d_fy_week_seq (INT4), tpcds.date_dim.d_day_name (TEXT), tpcds.date_dim.d_quarter_name (TEXT), tpcds.date_dim.d_holiday (TEXT), tpcds.date_dim.d_weekend (TEXT), tpcds.date_dim.d_following_holiday (TEXT), tpcds.date_dim.d_first_dom (INT4), tpcds.date_dim.d_last_dom (INT4), tpcds.date_dim.d_same_day_ly (INT4), tpcds.date_dim.d_same_day_lq (INT4), tpcds.date_dim.d_current_day (TEXT), tpcds.date_dim.d_current_week (TEXT), tpcds.date_dim.d_current_month (TEXT), tpcds.date_dim.d_current_quarter (TEXT), tpcds.date_dim.d_current_year (TEXT)} SELECTION(4) => Search Cond: tpcds.catalog_sales.cs_bill_customer_sk (INT4) = tpcds.customer.c_customer_sk (INT4) AND tpcds.customer.c_current_addr_sk (INT4) = tpcds.customer_address.ca_address_sk (INT4) AND substr(tpcds.customer_address.ca_zip (TEXT),1,5) IN (85669, 86197, 88274, 83405, 86475, 85392, 85460, 80348, 81792) OR tpcds.customer_address.ca_state (TEXT) IN (CA, WA, GA) OR tpcds.catalog_sales.cs_sales_price (FLOAT4) > 500.0 AND tpcds.catalog_sales.cs_sold_date_sk (INT4) = tpcds.date_dim.d_date_sk (INT4) AND tpcds.date_dim.d_qoy (INT4) = 2 AND tpcds.date_dim.d_year (INT4) = 2000 JOIN(11)(CROSS) => target list: tpcds.catalog_sales.cs_sold_date_sk (INT4), tpcds.catalog_sales.cs_sold_time_sk (INT4), tpcds.catalog_sales.cs_ship_date_sk (INT4), tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_bill_cdemo_sk (INT4), tpcds.catalog_sales.cs_bill_hdemo_sk (INT4), tpcds.catalog_sales.cs_bill_addr_sk (INT4), tpcds.catalog_sales.cs_ship_customer_sk (INT4), tpcds.catalog_sales.cs_ship_cdemo_sk (INT4), tpcds.catalog_sales.cs_ship_hdemo_sk (INT4), tpcds.catalog_sales.cs_ship_addr_sk (INT4), tpcds.catalog_sales.cs_call_center_sk (INT4), tpcds.catalog_sales.cs_catalog_page_sk (INT4), tpcds.catalog_sales.cs_ship_mode_sk (INT4), tpcds.catalog_sales.cs_warehouse_sk (INT4), tpcds.catalog_sales.cs_item_sk (INT4), tpcds.catalog_sales.cs_promo_sk (INT4), tpcds.catalog_sales.cs_order_number (INT4), tpcds.catalog_sales.cs_quantity (INT4), tpcds.catalog_sales.cs_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_list_price (FLOAT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_discount_amt (FLOAT4), tpcds.catalog_sales.cs_ext_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_ext_list_price (FLOAT4), tpcds.catalog_sales.cs_ext_tax (FLOAT4), tpcds.catalog_sales.cs_coupon_amt (FLOAT4), tpcds.catalog_sales.cs_ext_ship_cost (FLOAT4), tpcds.catalog_sales.cs_net_paid (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_tax (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship_tax (FLOAT4), tpcds.catalog_sales.cs_net_profit (FLOAT4), tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_customer_id (TEXT), tpcds.customer.c_current_cdemo_sk (INT4), tpcds.customer.c_current_hdemo_sk (INT4), tpcds.customer.c_current_addr_sk (INT4), tpcds.customer.c_first_shipto_date_sk (INT4), tpcds.customer.c_first_sales_date_sk (INT4), tpcds.customer.c_salutation (TEXT), tpcds.customer.c_first_name (TEXT), tpcds.customer.c_last_name (TEXT), tpcds.customer.c_preferred_cust_flag (TEXT), tpcds.customer.c_birth_day (INT4), tpcds.customer.c_birth_month (INT4), tpcds.customer.c_birth_year (INT4), tpcds.customer.c_birth_country (TEXT), tpcds.customer.c_login (TEXT), tpcds.customer.c_email_address (TEXT), tpcds.customer.c_last_review_date (TEXT), tpcds.customer_address.ca_zip (TEXT), ?and_1 (BOOLEAN), tpcds.customer_address.ca_address_sk (INT4), tpcds.customer_address.ca_address_id (TEXT), tpcds.customer_address.ca_street_number (TEXT), tpcds.customer_address.ca_street_name (TEXT), tpcds.customer_address.ca_street_type (TEXT), tpcds.customer_address.ca_suite_number (TEXT), tpcds.customer_address.ca_city (TEXT), tpcds.customer_address.ca_county (TEXT), tpcds.customer_address.ca_state (TEXT), ?fake0 (TEXT), tpcds.customer_address.ca_country (TEXT), tpcds.customer_address.ca_gmt_offset (FLOAT4), tpcds.customer_address.ca_location_type (TEXT), tpcds.date_dim.d_date_sk (INT4), tpcds.date_dim.d_date_id (TEXT), tpcds.date_dim.d_date (DATE), tpcds.date_dim.d_month_seq (INT4), tpcds.date_dim.d_week_seq (INT4), tpcds.date_dim.d_quarter_seq (INT4), tpcds.date_dim.d_year (INT4), tpcds.date_dim.d_dow (INT4), tpcds.date_dim.d_moy (INT4), tpcds.date_dim.d_dom (INT4), tpcds.date_dim.d_qoy (INT4), tpcds.date_dim.d_fy_year (INT4), tpcds.date_dim.d_fy_quarter_seq (INT4), tpcds.date_dim.d_fy_week_seq (INT4), tpcds.date_dim.d_day_name (TEXT), tpcds.date_dim.d_quarter_name (TEXT), tpcds.date_dim.d_holiday (TEXT), tpcds.date_dim.d_weekend (TEXT), tpcds.date_dim.d_following_holiday (TEXT), tpcds.date_dim.d_first_dom (INT4), tpcds.date_dim.d_last_dom (INT4), tpcds.date_dim.d_same_day_ly (INT4), tpcds.date_dim.d_same_day_lq (INT4), tpcds.date_dim.d_current_day (TEXT), tpcds.date_dim.d_current_week (TEXT), tpcds.date_dim.d_current_month (TEXT), tpcds.date_dim.d_current_quarter (TEXT), tpcds.date_dim.d_current_year (TEXT) => out schema: {(95) tpcds.catalog_sales.cs_sold_date_sk (INT4), tpcds.catalog_sales.cs_sold_time_sk (INT4), tpcds.catalog_sales.cs_ship_date_sk (INT4), tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_bill_cdemo_sk (INT4), tpcds.catalog_sales.cs_bill_hdemo_sk (INT4), tpcds.catalog_sales.cs_bill_addr_sk (INT4), tpcds.catalog_sales.cs_ship_customer_sk (INT4), tpcds.catalog_sales.cs_ship_cdemo_sk (INT4), tpcds.catalog_sales.cs_ship_hdemo_sk (INT4), tpcds.catalog_sales.cs_ship_addr_sk (INT4), tpcds.catalog_sales.cs_call_center_sk (INT4), tpcds.catalog_sales.cs_catalog_page_sk (INT4), tpcds.catalog_sales.cs_ship_mode_sk (INT4), tpcds.catalog_sales.cs_warehouse_sk (INT4), tpcds.catalog_sales.cs_item_sk (INT4), tpcds.catalog_sales.cs_promo_sk (INT4), tpcds.catalog_sales.cs_order_number (INT4), tpcds.catalog_sales.cs_quantity (INT4), tpcds.catalog_sales.cs_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_list_price (FLOAT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_discount_amt (FLOAT4), tpcds.catalog_sales.cs_ext_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_ext_list_price (FLOAT4), tpcds.catalog_sales.cs_ext_tax (FLOAT4), tpcds.catalog_sales.cs_coupon_amt (FLOAT4), tpcds.catalog_sales.cs_ext_ship_cost (FLOAT4), tpcds.catalog_sales.cs_net_paid (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_tax (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship_tax (FLOAT4), tpcds.catalog_sales.cs_net_profit (FLOAT4), tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_customer_id (TEXT), tpcds.customer.c_current_cdemo_sk (INT4), tpcds.customer.c_current_hdemo_sk (INT4), tpcds.customer.c_current_addr_sk (INT4), tpcds.customer.c_first_shipto_date_sk (INT4), tpcds.customer.c_first_sales_date_sk (INT4), tpcds.customer.c_salutation (TEXT), tpcds.customer.c_first_name (TEXT), tpcds.customer.c_last_name (TEXT), tpcds.customer.c_preferred_cust_flag (TEXT), tpcds.customer.c_birth_day (INT4), tpcds.customer.c_birth_month (INT4), tpcds.customer.c_birth_year (INT4), tpcds.customer.c_birth_country (TEXT), tpcds.customer.c_login (TEXT), tpcds.customer.c_email_address (TEXT), tpcds.customer.c_last_review_date (TEXT), tpcds.customer_address.ca_zip (TEXT), ?and_1 (BOOLEAN), tpcds.customer_address.ca_address_sk (INT4), tpcds.customer_address.ca_address_id (TEXT), tpcds.customer_address.ca_street_number (TEXT), tpcds.customer_address.ca_street_name (TEXT), tpcds.customer_address.ca_street_type (TEXT), tpcds.customer_address.ca_suite_number (TEXT), tpcds.customer_address.ca_city (TEXT), tpcds.customer_address.ca_county (TEXT), tpcds.customer_address.ca_state (TEXT), ?fake0 (TEXT), tpcds.customer_address.ca_country (TEXT), tpcds.customer_address.ca_gmt_offset (FLOAT4), tpcds.customer_address.ca_location_type (TEXT), tpcds.date_dim.d_date_sk (INT4), tpcds.date_dim.d_date_id (TEXT), tpcds.date_dim.d_date (DATE), tpcds.date_dim.d_month_seq (INT4), tpcds.date_dim.d_week_seq (INT4), tpcds.date_dim.d_quarter_seq (INT4), tpcds.date_dim.d_year (INT4), tpcds.date_dim.d_dow (INT4), tpcds.date_dim.d_moy (INT4), tpcds.date_dim.d_dom (INT4), tpcds.date_dim.d_qoy (INT4), tpcds.date_dim.d_fy_year (INT4), tpcds.date_dim.d_fy_quarter_seq (INT4), tpcds.date_dim.d_fy_week_seq (INT4), tpcds.date_dim.d_day_name (TEXT), tpcds.date_dim.d_quarter_name (TEXT), tpcds.date_dim.d_holiday (TEXT), tpcds.date_dim.d_weekend (TEXT), tpcds.date_dim.d_following_holiday (TEXT), tpcds.date_dim.d_first_dom (INT4), tpcds.date_dim.d_last_dom (INT4), tpcds.date_dim.d_same_day_ly (INT4), tpcds.date_dim.d_same_day_lq (INT4), tpcds.date_dim.d_current_day (TEXT), tpcds.date_dim.d_current_week (TEXT), tpcds.date_dim.d_current_month (TEXT), tpcds.date_dim.d_current_quarter (TEXT), tpcds.date_dim.d_current_year (TEXT)} => in schema: {(95) tpcds.catalog_sales.cs_sold_date_sk (INT4), tpcds.catalog_sales.cs_sold_time_sk (INT4), tpcds.catalog_sales.cs_ship_date_sk (INT4), tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_bill_cdemo_sk (INT4), tpcds.catalog_sales.cs_bill_hdemo_sk (INT4), tpcds.catalog_sales.cs_bill_addr_sk (INT4), tpcds.catalog_sales.cs_ship_customer_sk (INT4), tpcds.catalog_sales.cs_ship_cdemo_sk (INT4), tpcds.catalog_sales.cs_ship_hdemo_sk (INT4), tpcds.catalog_sales.cs_ship_addr_sk (INT4), tpcds.catalog_sales.cs_call_center_sk (INT4), tpcds.catalog_sales.cs_catalog_page_sk (INT4), tpcds.catalog_sales.cs_ship_mode_sk (INT4), tpcds.catalog_sales.cs_warehouse_sk (INT4), tpcds.catalog_sales.cs_item_sk (INT4), tpcds.catalog_sales.cs_promo_sk (INT4), tpcds.catalog_sales.cs_order_number (INT4), tpcds.catalog_sales.cs_quantity (INT4), tpcds.catalog_sales.cs_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_list_price (FLOAT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_discount_amt (FLOAT4), tpcds.catalog_sales.cs_ext_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_ext_list_price (FLOAT4), tpcds.catalog_sales.cs_ext_tax (FLOAT4), tpcds.catalog_sales.cs_coupon_amt (FLOAT4), tpcds.catalog_sales.cs_ext_ship_cost (FLOAT4), tpcds.catalog_sales.cs_net_paid (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_tax (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship_tax (FLOAT4), tpcds.catalog_sales.cs_net_profit (FLOAT4), tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_customer_id (TEXT), tpcds.customer.c_current_cdemo_sk (INT4), tpcds.customer.c_current_hdemo_sk (INT4), tpcds.customer.c_current_addr_sk (INT4), tpcds.customer.c_first_shipto_date_sk (INT4), tpcds.customer.c_first_sales_date_sk (INT4), tpcds.customer.c_salutation (TEXT), tpcds.customer.c_first_name (TEXT), tpcds.customer.c_last_name (TEXT), tpcds.customer.c_preferred_cust_flag (TEXT), tpcds.customer.c_birth_day (INT4), tpcds.customer.c_birth_month (INT4), tpcds.customer.c_birth_year (INT4), tpcds.customer.c_birth_country (TEXT), tpcds.customer.c_login (TEXT), tpcds.customer.c_email_address (TEXT), tpcds.customer.c_last_review_date (TEXT), tpcds.customer_address.ca_zip (TEXT), ?and_1 (BOOLEAN), tpcds.customer_address.ca_address_sk (INT4), tpcds.customer_address.ca_address_id (TEXT), tpcds.customer_address.ca_street_number (TEXT), tpcds.customer_address.ca_street_name (TEXT), tpcds.customer_address.ca_street_type (TEXT), tpcds.customer_address.ca_suite_number (TEXT), tpcds.customer_address.ca_city (TEXT), tpcds.customer_address.ca_county (TEXT), tpcds.customer_address.ca_state (TEXT), ?fake0 (TEXT), tpcds.customer_address.ca_country (TEXT), tpcds.customer_address.ca_gmt_offset (FLOAT4), tpcds.customer_address.ca_location_type (TEXT), tpcds.date_dim.d_date_sk (INT4), tpcds.date_dim.d_date_id (TEXT), tpcds.date_dim.d_date (DATE), tpcds.date_dim.d_month_seq (INT4), tpcds.date_dim.d_week_seq (INT4), tpcds.date_dim.d_quarter_seq (INT4), tpcds.date_dim.d_year (INT4), tpcds.date_dim.d_dow (INT4), tpcds.date_dim.d_moy (INT4), tpcds.date_dim.d_dom (INT4), tpcds.date_dim.d_qoy (INT4), tpcds.date_dim.d_fy_year (INT4), tpcds.date_dim.d_fy_quarter_seq (INT4), tpcds.date_dim.d_fy_week_seq (INT4), tpcds.date_dim.d_day_name (TEXT), tpcds.date_dim.d_quarter_name (TEXT), tpcds.date_dim.d_holiday (TEXT), tpcds.date_dim.d_weekend (TEXT), tpcds.date_dim.d_following_holiday (TEXT), tpcds.date_dim.d_first_dom (INT4), tpcds.date_dim.d_last_dom (INT4), tpcds.date_dim.d_same_day_ly (INT4), tpcds.date_dim.d_same_day_lq (INT4), tpcds.date_dim.d_current_day (TEXT), tpcds.date_dim.d_current_week (TEXT), tpcds.date_dim.d_current_month (TEXT), tpcds.date_dim.d_current_quarter (TEXT), tpcds.date_dim.d_current_year (TEXT)} SCAN(3) on tpcds.date_dim => target list: tpcds.date_dim.d_date_sk (INT4), tpcds.date_dim.d_date_id (TEXT), tpcds.date_dim.d_date (DATE), tpcds.date_dim.d_month_seq (INT4), tpcds.date_dim.d_week_seq (INT4), tpcds.date_dim.d_quarter_seq (INT4), tpcds.date_dim.d_year (INT4), tpcds.date_dim.d_dow (INT4), tpcds.date_dim.d_moy (INT4), tpcds.date_dim.d_dom (INT4), tpcds.date_dim.d_qoy (INT4), tpcds.date_dim.d_fy_year (INT4), tpcds.date_dim.d_fy_quarter_seq (INT4), tpcds.date_dim.d_fy_week_seq (INT4), tpcds.date_dim.d_day_name (TEXT), tpcds.date_dim.d_quarter_name (TEXT), tpcds.date_dim.d_holiday (TEXT), tpcds.date_dim.d_weekend (TEXT), tpcds.date_dim.d_following_holiday (TEXT), tpcds.date_dim.d_first_dom (INT4), tpcds.date_dim.d_last_dom (INT4), tpcds.date_dim.d_same_day_ly (INT4), tpcds.date_dim.d_same_day_lq (INT4), tpcds.date_dim.d_current_day (TEXT), tpcds.date_dim.d_current_week (TEXT), tpcds.date_dim.d_current_month (TEXT), tpcds.date_dim.d_current_quarter (TEXT), tpcds.date_dim.d_current_year (TEXT) => out schema: {(28) tpcds.date_dim.d_date_sk (INT4), tpcds.date_dim.d_date_id (TEXT), tpcds.date_dim.d_date (DATE), tpcds.date_dim.d_month_seq (INT4), tpcds.date_dim.d_week_seq (INT4), tpcds.date_dim.d_quarter_seq (INT4), tpcds.date_dim.d_year (INT4), tpcds.date_dim.d_dow (INT4), tpcds.date_dim.d_moy (INT4), tpcds.date_dim.d_dom (INT4), tpcds.date_dim.d_qoy (INT4), tpcds.date_dim.d_fy_year (INT4), tpcds.date_dim.d_fy_quarter_seq (INT4), tpcds.date_dim.d_fy_week_seq (INT4), tpcds.date_dim.d_day_name (TEXT), tpcds.date_dim.d_quarter_name (TEXT), tpcds.date_dim.d_holiday (TEXT), tpcds.date_dim.d_weekend (TEXT), tpcds.date_dim.d_following_holiday (TEXT), tpcds.date_dim.d_first_dom (INT4), tpcds.date_dim.d_last_dom (INT4), tpcds.date_dim.d_same_day_ly (INT4), tpcds.date_dim.d_same_day_lq (INT4), tpcds.date_dim.d_current_day (TEXT), tpcds.date_dim.d_current_week (TEXT), tpcds.date_dim.d_current_month (TEXT), tpcds.date_dim.d_current_quarter (TEXT), tpcds.date_dim.d_current_year (TEXT)} => in schema: {(28) tpcds.date_dim.d_date_sk (INT4), tpcds.date_dim.d_date_id (TEXT), tpcds.date_dim.d_date (DATE), tpcds.date_dim.d_month_seq (INT4), tpcds.date_dim.d_week_seq (INT4), tpcds.date_dim.d_quarter_seq (INT4), tpcds.date_dim.d_year (INT4), tpcds.date_dim.d_dow (INT4), tpcds.date_dim.d_moy (INT4), tpcds.date_dim.d_dom (INT4), tpcds.date_dim.d_qoy (INT4), tpcds.date_dim.d_fy_year (INT4), tpcds.date_dim.d_fy_quarter_seq (INT4), tpcds.date_dim.d_fy_week_seq (INT4), tpcds.date_dim.d_day_name (TEXT), tpcds.date_dim.d_quarter_name (TEXT), tpcds.date_dim.d_holiday (TEXT), tpcds.date_dim.d_weekend (TEXT), tpcds.date_dim.d_following_holiday (TEXT), tpcds.date_dim.d_first_dom (INT4), tpcds.date_dim.d_last_dom (INT4), tpcds.date_dim.d_same_day_ly (INT4), tpcds.date_dim.d_same_day_lq (INT4), tpcds.date_dim.d_current_day (TEXT), tpcds.date_dim.d_current_week (TEXT), tpcds.date_dim.d_current_month (TEXT), tpcds.date_dim.d_current_quarter (TEXT), tpcds.date_dim.d_current_year (TEXT)} JOIN(10)(CROSS) => target list: tpcds.catalog_sales.cs_sold_date_sk (INT4), tpcds.catalog_sales.cs_sold_time_sk (INT4), tpcds.catalog_sales.cs_ship_date_sk (INT4), tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_bill_cdemo_sk (INT4), tpcds.catalog_sales.cs_bill_hdemo_sk (INT4), tpcds.catalog_sales.cs_bill_addr_sk (INT4), tpcds.catalog_sales.cs_ship_customer_sk (INT4), tpcds.catalog_sales.cs_ship_cdemo_sk (INT4), tpcds.catalog_sales.cs_ship_hdemo_sk (INT4), tpcds.catalog_sales.cs_ship_addr_sk (INT4), tpcds.catalog_sales.cs_call_center_sk (INT4), tpcds.catalog_sales.cs_catalog_page_sk (INT4), tpcds.catalog_sales.cs_ship_mode_sk (INT4), tpcds.catalog_sales.cs_warehouse_sk (INT4), tpcds.catalog_sales.cs_item_sk (INT4), tpcds.catalog_sales.cs_promo_sk (INT4), tpcds.catalog_sales.cs_order_number (INT4), tpcds.catalog_sales.cs_quantity (INT4), tpcds.catalog_sales.cs_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_list_price (FLOAT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_discount_amt (FLOAT4), tpcds.catalog_sales.cs_ext_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_ext_list_price (FLOAT4), tpcds.catalog_sales.cs_ext_tax (FLOAT4), tpcds.catalog_sales.cs_coupon_amt (FLOAT4), tpcds.catalog_sales.cs_ext_ship_cost (FLOAT4), tpcds.catalog_sales.cs_net_paid (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_tax (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship_tax (FLOAT4), tpcds.catalog_sales.cs_net_profit (FLOAT4), tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_customer_id (TEXT), tpcds.customer.c_current_cdemo_sk (INT4), tpcds.customer.c_current_hdemo_sk (INT4), tpcds.customer.c_current_addr_sk (INT4), tpcds.customer.c_first_shipto_date_sk (INT4), tpcds.customer.c_first_sales_date_sk (INT4), tpcds.customer.c_salutation (TEXT), tpcds.customer.c_first_name (TEXT), tpcds.customer.c_last_name (TEXT), tpcds.customer.c_preferred_cust_flag (TEXT), tpcds.customer.c_birth_day (INT4), tpcds.customer.c_birth_month (INT4), tpcds.customer.c_birth_year (INT4), tpcds.customer.c_birth_country (TEXT), tpcds.customer.c_login (TEXT), tpcds.customer.c_email_address (TEXT), tpcds.customer.c_last_review_date (TEXT), tpcds.customer_address.ca_zip (TEXT), ?and_1 (BOOLEAN), tpcds.customer_address.ca_address_sk (INT4), tpcds.customer_address.ca_address_id (TEXT), tpcds.customer_address.ca_street_number (TEXT), tpcds.customer_address.ca_street_name (TEXT), tpcds.customer_address.ca_street_type (TEXT), tpcds.customer_address.ca_suite_number (TEXT), tpcds.customer_address.ca_city (TEXT), tpcds.customer_address.ca_county (TEXT), tpcds.customer_address.ca_state (TEXT), ?fake0 (TEXT), tpcds.customer_address.ca_country (TEXT), tpcds.customer_address.ca_gmt_offset (FLOAT4), tpcds.customer_address.ca_location_type (TEXT) => out schema: {(67) tpcds.catalog_sales.cs_sold_date_sk (INT4), tpcds.catalog_sales.cs_sold_time_sk (INT4), tpcds.catalog_sales.cs_ship_date_sk (INT4), tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_bill_cdemo_sk (INT4), tpcds.catalog_sales.cs_bill_hdemo_sk (INT4), tpcds.catalog_sales.cs_bill_addr_sk (INT4), tpcds.catalog_sales.cs_ship_customer_sk (INT4), tpcds.catalog_sales.cs_ship_cdemo_sk (INT4), tpcds.catalog_sales.cs_ship_hdemo_sk (INT4), tpcds.catalog_sales.cs_ship_addr_sk (INT4), tpcds.catalog_sales.cs_call_center_sk (INT4), tpcds.catalog_sales.cs_catalog_page_sk (INT4), tpcds.catalog_sales.cs_ship_mode_sk (INT4), tpcds.catalog_sales.cs_warehouse_sk (INT4), tpcds.catalog_sales.cs_item_sk (INT4), tpcds.catalog_sales.cs_promo_sk (INT4), tpcds.catalog_sales.cs_order_number (INT4), tpcds.catalog_sales.cs_quantity (INT4), tpcds.catalog_sales.cs_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_list_price (FLOAT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_discount_amt (FLOAT4), tpcds.catalog_sales.cs_ext_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_ext_list_price (FLOAT4), tpcds.catalog_sales.cs_ext_tax (FLOAT4), tpcds.catalog_sales.cs_coupon_amt (FLOAT4), tpcds.catalog_sales.cs_ext_ship_cost (FLOAT4), tpcds.catalog_sales.cs_net_paid (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_tax (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship_tax (FLOAT4), tpcds.catalog_sales.cs_net_profit (FLOAT4), tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_customer_id (TEXT), tpcds.customer.c_current_cdemo_sk (INT4), tpcds.customer.c_current_hdemo_sk (INT4), tpcds.customer.c_current_addr_sk (INT4), tpcds.customer.c_first_shipto_date_sk (INT4), tpcds.customer.c_first_sales_date_sk (INT4), tpcds.customer.c_salutation (TEXT), tpcds.customer.c_first_name (TEXT), tpcds.customer.c_last_name (TEXT), tpcds.customer.c_preferred_cust_flag (TEXT), tpcds.customer.c_birth_day (INT4), tpcds.customer.c_birth_month (INT4), tpcds.customer.c_birth_year (INT4), tpcds.customer.c_birth_country (TEXT), tpcds.customer.c_login (TEXT), tpcds.customer.c_email_address (TEXT), tpcds.customer.c_last_review_date (TEXT), tpcds.customer_address.ca_zip (TEXT), ?and_1 (BOOLEAN), tpcds.customer_address.ca_address_sk (INT4), tpcds.customer_address.ca_address_id (TEXT), tpcds.customer_address.ca_street_number (TEXT), tpcds.customer_address.ca_street_name (TEXT), tpcds.customer_address.ca_street_type (TEXT), tpcds.customer_address.ca_suite_number (TEXT), tpcds.customer_address.ca_city (TEXT), tpcds.customer_address.ca_county (TEXT), tpcds.customer_address.ca_state (TEXT), ?fake0 (TEXT), tpcds.customer_address.ca_country (TEXT), tpcds.customer_address.ca_gmt_offset (FLOAT4), tpcds.customer_address.ca_location_type (TEXT)} => in schema: {(67) tpcds.catalog_sales.cs_sold_date_sk (INT4), tpcds.catalog_sales.cs_sold_time_sk (INT4), tpcds.catalog_sales.cs_ship_date_sk (INT4), tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_bill_cdemo_sk (INT4), tpcds.catalog_sales.cs_bill_hdemo_sk (INT4), tpcds.catalog_sales.cs_bill_addr_sk (INT4), tpcds.catalog_sales.cs_ship_customer_sk (INT4), tpcds.catalog_sales.cs_ship_cdemo_sk (INT4), tpcds.catalog_sales.cs_ship_hdemo_sk (INT4), tpcds.catalog_sales.cs_ship_addr_sk (INT4), tpcds.catalog_sales.cs_call_center_sk (INT4), tpcds.catalog_sales.cs_catalog_page_sk (INT4), tpcds.catalog_sales.cs_ship_mode_sk (INT4), tpcds.catalog_sales.cs_warehouse_sk (INT4), tpcds.catalog_sales.cs_item_sk (INT4), tpcds.catalog_sales.cs_promo_sk (INT4), tpcds.catalog_sales.cs_order_number (INT4), tpcds.catalog_sales.cs_quantity (INT4), tpcds.catalog_sales.cs_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_list_price (FLOAT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_discount_amt (FLOAT4), tpcds.catalog_sales.cs_ext_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_ext_list_price (FLOAT4), tpcds.catalog_sales.cs_ext_tax (FLOAT4), tpcds.catalog_sales.cs_coupon_amt (FLOAT4), tpcds.catalog_sales.cs_ext_ship_cost (FLOAT4), tpcds.catalog_sales.cs_net_paid (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_tax (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship_tax (FLOAT4), tpcds.catalog_sales.cs_net_profit (FLOAT4), tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_customer_id (TEXT), tpcds.customer.c_current_cdemo_sk (INT4), tpcds.customer.c_current_hdemo_sk (INT4), tpcds.customer.c_current_addr_sk (INT4), tpcds.customer.c_first_shipto_date_sk (INT4), tpcds.customer.c_first_sales_date_sk (INT4), tpcds.customer.c_salutation (TEXT), tpcds.customer.c_first_name (TEXT), tpcds.customer.c_last_name (TEXT), tpcds.customer.c_preferred_cust_flag (TEXT), tpcds.customer.c_birth_day (INT4), tpcds.customer.c_birth_month (INT4), tpcds.customer.c_birth_year (INT4), tpcds.customer.c_birth_country (TEXT), tpcds.customer.c_login (TEXT), tpcds.customer.c_email_address (TEXT), tpcds.customer.c_last_review_date (TEXT), tpcds.customer_address.ca_zip (TEXT), ?and_1 (BOOLEAN), tpcds.customer_address.ca_address_sk (INT4), tpcds.customer_address.ca_address_id (TEXT), tpcds.customer_address.ca_street_number (TEXT), tpcds.customer_address.ca_street_name (TEXT), tpcds.customer_address.ca_street_type (TEXT), tpcds.customer_address.ca_suite_number (TEXT), tpcds.customer_address.ca_city (TEXT), tpcds.customer_address.ca_county (TEXT), tpcds.customer_address.ca_state (TEXT), ?fake0 (TEXT), tpcds.customer_address.ca_country (TEXT), tpcds.customer_address.ca_gmt_offset (FLOAT4), tpcds.customer_address.ca_location_type (TEXT)} SCAN(2) on tpcds.customer_address => target list: tpcds.customer_address.ca_address_sk (INT4), tpcds.customer_address.ca_address_id (TEXT), tpcds.customer_address.ca_street_number (TEXT), tpcds.customer_address.ca_street_name (TEXT), tpcds.customer_address.ca_street_type (TEXT), tpcds.customer_address.ca_suite_number (TEXT), tpcds.customer_address.ca_city (TEXT), tpcds.customer_address.ca_county (TEXT), tpcds.customer_address.ca_state (TEXT), tpcds.customer_address.ca_zip (TEXT), tpcds.customer_address.ca_country (TEXT), tpcds.customer_address.ca_gmt_offset (FLOAT4), tpcds.customer_address.ca_location_type (TEXT) => out schema: {(13) tpcds.customer_address.ca_address_sk (INT4), tpcds.customer_address.ca_address_id (TEXT), tpcds.customer_address.ca_street_number (TEXT), tpcds.customer_address.ca_street_name (TEXT), tpcds.customer_address.ca_street_type (TEXT), tpcds.customer_address.ca_suite_number (TEXT), tpcds.customer_address.ca_city (TEXT), tpcds.customer_address.ca_county (TEXT), tpcds.customer_address.ca_state (TEXT), tpcds.customer_address.ca_zip (TEXT), tpcds.customer_address.ca_country (TEXT), tpcds.customer_address.ca_gmt_offset (FLOAT4), tpcds.customer_address.ca_location_type (TEXT)} => in schema: {(13) tpcds.customer_address.ca_address_sk (INT4), tpcds.customer_address.ca_address_id (TEXT), tpcds.customer_address.ca_street_number (TEXT), tpcds.customer_address.ca_street_name (TEXT), tpcds.customer_address.ca_street_type (TEXT), tpcds.customer_address.ca_suite_number (TEXT), tpcds.customer_address.ca_city (TEXT), tpcds.customer_address.ca_county (TEXT), tpcds.customer_address.ca_state (TEXT), tpcds.customer_address.ca_zip (TEXT), tpcds.customer_address.ca_country (TEXT), tpcds.customer_address.ca_gmt_offset (FLOAT4), tpcds.customer_address.ca_location_type (TEXT)} JOIN(9)(CROSS) => target list: tpcds.catalog_sales.cs_sold_date_sk (INT4), tpcds.catalog_sales.cs_sold_time_sk (INT4), tpcds.catalog_sales.cs_ship_date_sk (INT4), tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_bill_cdemo_sk (INT4), tpcds.catalog_sales.cs_bill_hdemo_sk (INT4), tpcds.catalog_sales.cs_bill_addr_sk (INT4), tpcds.catalog_sales.cs_ship_customer_sk (INT4), tpcds.catalog_sales.cs_ship_cdemo_sk (INT4), tpcds.catalog_sales.cs_ship_hdemo_sk (INT4), tpcds.catalog_sales.cs_ship_addr_sk (INT4), tpcds.catalog_sales.cs_call_center_sk (INT4), tpcds.catalog_sales.cs_catalog_page_sk (INT4), tpcds.catalog_sales.cs_ship_mode_sk (INT4), tpcds.catalog_sales.cs_warehouse_sk (INT4), tpcds.catalog_sales.cs_item_sk (INT4), tpcds.catalog_sales.cs_promo_sk (INT4), tpcds.catalog_sales.cs_order_number (INT4), tpcds.catalog_sales.cs_quantity (INT4), tpcds.catalog_sales.cs_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_list_price (FLOAT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_discount_amt (FLOAT4), tpcds.catalog_sales.cs_ext_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_ext_list_price (FLOAT4), tpcds.catalog_sales.cs_ext_tax (FLOAT4), tpcds.catalog_sales.cs_coupon_amt (FLOAT4), tpcds.catalog_sales.cs_ext_ship_cost (FLOAT4), tpcds.catalog_sales.cs_net_paid (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_tax (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship_tax (FLOAT4), tpcds.catalog_sales.cs_net_profit (FLOAT4), tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_customer_id (TEXT), tpcds.customer.c_current_cdemo_sk (INT4), tpcds.customer.c_current_hdemo_sk (INT4), tpcds.customer.c_current_addr_sk (INT4), tpcds.customer.c_first_shipto_date_sk (INT4), tpcds.customer.c_first_sales_date_sk (INT4), tpcds.customer.c_salutation (TEXT), tpcds.customer.c_first_name (TEXT), tpcds.customer.c_last_name (TEXT), tpcds.customer.c_preferred_cust_flag (TEXT), tpcds.customer.c_birth_day (INT4), tpcds.customer.c_birth_month (INT4), tpcds.customer.c_birth_year (INT4), tpcds.customer.c_birth_country (TEXT), tpcds.customer.c_login (TEXT), tpcds.customer.c_email_address (TEXT), tpcds.customer.c_last_review_date (TEXT), tpcds.customer_address.ca_zip (TEXT), tpcds.catalog_sales.cs_bill_customer_sk (INT4) = tpcds.customer.c_customer_sk (INT4) AND tpcds.customer.c_current_addr_sk (INT4) = tpcds.customer_address.ca_address_sk (INT4) AND substr(tpcds.customer_address.ca_zip (TEXT),1,5) IN (85669, 86197, 88274, 83405, 86475, 85392, 85460, 80348, 81792) OR tpcds.customer_address.ca_state (TEXT) IN (CA, WA, GA) OR tpcds.catalog_sales.cs_sales_price (FLOAT4) > 500.0 AND tpcds.catalog_sales.cs_sold_date_sk (INT4) = tpcds.date_dim.d_date_sk (INT4) AND tpcds.date_dim.d_qoy (INT4) = 2 AND tpcds.date_dim.d_year (INT4) = 2000 as ?and_1 => out schema: {(54) tpcds.catalog_sales.cs_sold_date_sk (INT4), tpcds.catalog_sales.cs_sold_time_sk (INT4), tpcds.catalog_sales.cs_ship_date_sk (INT4), tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_bill_cdemo_sk (INT4), tpcds.catalog_sales.cs_bill_hdemo_sk (INT4), tpcds.catalog_sales.cs_bill_addr_sk (INT4), tpcds.catalog_sales.cs_ship_customer_sk (INT4), tpcds.catalog_sales.cs_ship_cdemo_sk (INT4), tpcds.catalog_sales.cs_ship_hdemo_sk (INT4), tpcds.catalog_sales.cs_ship_addr_sk (INT4), tpcds.catalog_sales.cs_call_center_sk (INT4), tpcds.catalog_sales.cs_catalog_page_sk (INT4), tpcds.catalog_sales.cs_ship_mode_sk (INT4), tpcds.catalog_sales.cs_warehouse_sk (INT4), tpcds.catalog_sales.cs_item_sk (INT4), tpcds.catalog_sales.cs_promo_sk (INT4), tpcds.catalog_sales.cs_order_number (INT4), tpcds.catalog_sales.cs_quantity (INT4), tpcds.catalog_sales.cs_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_list_price (FLOAT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_discount_amt (FLOAT4), tpcds.catalog_sales.cs_ext_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_ext_list_price (FLOAT4), tpcds.catalog_sales.cs_ext_tax (FLOAT4), tpcds.catalog_sales.cs_coupon_amt (FLOAT4), tpcds.catalog_sales.cs_ext_ship_cost (FLOAT4), tpcds.catalog_sales.cs_net_paid (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_tax (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship_tax (FLOAT4), tpcds.catalog_sales.cs_net_profit (FLOAT4), tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_customer_id (TEXT), tpcds.customer.c_current_cdemo_sk (INT4), tpcds.customer.c_current_hdemo_sk (INT4), tpcds.customer.c_current_addr_sk (INT4), tpcds.customer.c_first_shipto_date_sk (INT4), tpcds.customer.c_first_sales_date_sk (INT4), tpcds.customer.c_salutation (TEXT), tpcds.customer.c_first_name (TEXT), tpcds.customer.c_last_name (TEXT), tpcds.customer.c_preferred_cust_flag (TEXT), tpcds.customer.c_birth_day (INT4), tpcds.customer.c_birth_month (INT4), tpcds.customer.c_birth_year (INT4), tpcds.customer.c_birth_country (TEXT), tpcds.customer.c_login (TEXT), tpcds.customer.c_email_address (TEXT), tpcds.customer.c_last_review_date (TEXT), tpcds.customer_address.ca_zip (TEXT), ?and_1 (BOOLEAN)} => in schema: {(52) tpcds.catalog_sales.cs_sold_date_sk (INT4), tpcds.catalog_sales.cs_sold_time_sk (INT4), tpcds.catalog_sales.cs_ship_date_sk (INT4), tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_bill_cdemo_sk (INT4), tpcds.catalog_sales.cs_bill_hdemo_sk (INT4), tpcds.catalog_sales.cs_bill_addr_sk (INT4), tpcds.catalog_sales.cs_ship_customer_sk (INT4), tpcds.catalog_sales.cs_ship_cdemo_sk (INT4), tpcds.catalog_sales.cs_ship_hdemo_sk (INT4), tpcds.catalog_sales.cs_ship_addr_sk (INT4), tpcds.catalog_sales.cs_call_center_sk (INT4), tpcds.catalog_sales.cs_catalog_page_sk (INT4), tpcds.catalog_sales.cs_ship_mode_sk (INT4), tpcds.catalog_sales.cs_warehouse_sk (INT4), tpcds.catalog_sales.cs_item_sk (INT4), tpcds.catalog_sales.cs_promo_sk (INT4), tpcds.catalog_sales.cs_order_number (INT4), tpcds.catalog_sales.cs_quantity (INT4), tpcds.catalog_sales.cs_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_list_price (FLOAT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_discount_amt (FLOAT4), tpcds.catalog_sales.cs_ext_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_ext_list_price (FLOAT4), tpcds.catalog_sales.cs_ext_tax (FLOAT4), tpcds.catalog_sales.cs_coupon_amt (FLOAT4), tpcds.catalog_sales.cs_ext_ship_cost (FLOAT4), tpcds.catalog_sales.cs_net_paid (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_tax (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship_tax (FLOAT4), tpcds.catalog_sales.cs_net_profit (FLOAT4), tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_customer_id (TEXT), tpcds.customer.c_current_cdemo_sk (INT4), tpcds.customer.c_current_hdemo_sk (INT4), tpcds.customer.c_current_addr_sk (INT4), tpcds.customer.c_first_shipto_date_sk (INT4), tpcds.customer.c_first_sales_date_sk (INT4), tpcds.customer.c_salutation (TEXT), tpcds.customer.c_first_name (TEXT), tpcds.customer.c_last_name (TEXT), tpcds.customer.c_preferred_cust_flag (TEXT), tpcds.customer.c_birth_day (INT4), tpcds.customer.c_birth_month (INT4), tpcds.customer.c_birth_year (INT4), tpcds.customer.c_birth_country (TEXT), tpcds.customer.c_login (TEXT), tpcds.customer.c_email_address (TEXT), tpcds.customer.c_last_review_date (TEXT)} SCAN(1) on tpcds.customer => target list: tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_customer_id (TEXT), tpcds.customer.c_current_cdemo_sk (INT4), tpcds.customer.c_current_hdemo_sk (INT4), tpcds.customer.c_current_addr_sk (INT4), tpcds.customer.c_first_shipto_date_sk (INT4), tpcds.customer.c_first_sales_date_sk (INT4), tpcds.customer.c_salutation (TEXT), tpcds.customer.c_first_name (TEXT), tpcds.customer.c_last_name (TEXT), tpcds.customer.c_preferred_cust_flag (TEXT), tpcds.customer.c_birth_day (INT4), tpcds.customer.c_birth_month (INT4), tpcds.customer.c_birth_year (INT4), tpcds.customer.c_birth_country (TEXT), tpcds.customer.c_login (TEXT), tpcds.customer.c_email_address (TEXT), tpcds.customer.c_last_review_date (TEXT) => out schema: {(18) tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_customer_id (TEXT), tpcds.customer.c_current_cdemo_sk (INT4), tpcds.customer.c_current_hdemo_sk (INT4), tpcds.customer.c_current_addr_sk (INT4), tpcds.customer.c_first_shipto_date_sk (INT4), tpcds.customer.c_first_sales_date_sk (INT4), tpcds.customer.c_salutation (TEXT), tpcds.customer.c_first_name (TEXT), tpcds.customer.c_last_name (TEXT), tpcds.customer.c_preferred_cust_flag (TEXT), tpcds.customer.c_birth_day (INT4), tpcds.customer.c_birth_month (INT4), tpcds.customer.c_birth_year (INT4), tpcds.customer.c_birth_country (TEXT), tpcds.customer.c_login (TEXT), tpcds.customer.c_email_address (TEXT), tpcds.customer.c_last_review_date (TEXT)} => in schema: {(18) tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_customer_id (TEXT), tpcds.customer.c_current_cdemo_sk (INT4), tpcds.customer.c_current_hdemo_sk (INT4), tpcds.customer.c_current_addr_sk (INT4), tpcds.customer.c_first_shipto_date_sk (INT4), tpcds.customer.c_first_sales_date_sk (INT4), tpcds.customer.c_salutation (TEXT), tpcds.customer.c_first_name (TEXT), tpcds.customer.c_last_name (TEXT), tpcds.customer.c_preferred_cust_flag (TEXT), tpcds.customer.c_birth_day (INT4), tpcds.customer.c_birth_month (INT4), tpcds.customer.c_birth_year (INT4), tpcds.customer.c_birth_country (TEXT), tpcds.customer.c_login (TEXT), tpcds.customer.c_email_address (TEXT), tpcds.customer.c_last_review_date (TEXT)} SCAN(0) on tpcds.catalog_sales => target list: tpcds.catalog_sales.cs_sold_date_sk (INT4), tpcds.catalog_sales.cs_sold_time_sk (INT4), tpcds.catalog_sales.cs_ship_date_sk (INT4), tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_bill_cdemo_sk (INT4), tpcds.catalog_sales.cs_bill_hdemo_sk (INT4), tpcds.catalog_sales.cs_bill_addr_sk (INT4), tpcds.catalog_sales.cs_ship_customer_sk (INT4), tpcds.catalog_sales.cs_ship_cdemo_sk (INT4), tpcds.catalog_sales.cs_ship_hdemo_sk (INT4), tpcds.catalog_sales.cs_ship_addr_sk (INT4), tpcds.catalog_sales.cs_call_center_sk (INT4), tpcds.catalog_sales.cs_catalog_page_sk (INT4), tpcds.catalog_sales.cs_ship_mode_sk (INT4), tpcds.catalog_sales.cs_warehouse_sk (INT4), tpcds.catalog_sales.cs_item_sk (INT4), tpcds.catalog_sales.cs_promo_sk (INT4), tpcds.catalog_sales.cs_order_number (INT4), tpcds.catalog_sales.cs_quantity (INT4), tpcds.catalog_sales.cs_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_list_price (FLOAT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_discount_amt (FLOAT4), tpcds.catalog_sales.cs_ext_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_ext_list_price (FLOAT4), tpcds.catalog_sales.cs_ext_tax (FLOAT4), tpcds.catalog_sales.cs_coupon_amt (FLOAT4), tpcds.catalog_sales.cs_ext_ship_cost (FLOAT4), tpcds.catalog_sales.cs_net_paid (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_tax (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship_tax (FLOAT4), tpcds.catalog_sales.cs_net_profit (FLOAT4) => out schema: {(34) tpcds.catalog_sales.cs_sold_date_sk (INT4), tpcds.catalog_sales.cs_sold_time_sk (INT4), tpcds.catalog_sales.cs_ship_date_sk (INT4), tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_bill_cdemo_sk (INT4), tpcds.catalog_sales.cs_bill_hdemo_sk (INT4), tpcds.catalog_sales.cs_bill_addr_sk (INT4), tpcds.catalog_sales.cs_ship_customer_sk (INT4), tpcds.catalog_sales.cs_ship_cdemo_sk (INT4), tpcds.catalog_sales.cs_ship_hdemo_sk (INT4), tpcds.catalog_sales.cs_ship_addr_sk (INT4), tpcds.catalog_sales.cs_call_center_sk (INT4), tpcds.catalog_sales.cs_catalog_page_sk (INT4), tpcds.catalog_sales.cs_ship_mode_sk (INT4), tpcds.catalog_sales.cs_warehouse_sk (INT4), tpcds.catalog_sales.cs_item_sk (INT4), tpcds.catalog_sales.cs_promo_sk (INT4), tpcds.catalog_sales.cs_order_number (INT4), tpcds.catalog_sales.cs_quantity (INT4), tpcds.catalog_sales.cs_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_list_price (FLOAT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_discount_amt (FLOAT4), tpcds.catalog_sales.cs_ext_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_ext_list_price (FLOAT4), tpcds.catalog_sales.cs_ext_tax (FLOAT4), tpcds.catalog_sales.cs_coupon_amt (FLOAT4), tpcds.catalog_sales.cs_ext_ship_cost (FLOAT4), tpcds.catalog_sales.cs_net_paid (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_tax (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship_tax (FLOAT4), tpcds.catalog_sales.cs_net_profit (FLOAT4)} => in schema: {(34) tpcds.catalog_sales.cs_sold_date_sk (INT4), tpcds.catalog_sales.cs_sold_time_sk (INT4), tpcds.catalog_sales.cs_ship_date_sk (INT4), tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_bill_cdemo_sk (INT4), tpcds.catalog_sales.cs_bill_hdemo_sk (INT4), tpcds.catalog_sales.cs_bill_addr_sk (INT4), tpcds.catalog_sales.cs_ship_customer_sk (INT4), tpcds.catalog_sales.cs_ship_cdemo_sk (INT4), tpcds.catalog_sales.cs_ship_hdemo_sk (INT4), tpcds.catalog_sales.cs_ship_addr_sk (INT4), tpcds.catalog_sales.cs_call_center_sk (INT4), tpcds.catalog_sales.cs_catalog_page_sk (INT4), tpcds.catalog_sales.cs_ship_mode_sk (INT4), tpcds.catalog_sales.cs_warehouse_sk (INT4), tpcds.catalog_sales.cs_item_sk (INT4), tpcds.catalog_sales.cs_promo_sk (INT4), tpcds.catalog_sales.cs_order_number (INT4), tpcds.catalog_sales.cs_quantity (INT4), tpcds.catalog_sales.cs_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_list_price (FLOAT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_discount_amt (FLOAT4), tpcds.catalog_sales.cs_ext_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_ext_list_price (FLOAT4), tpcds.catalog_sales.cs_ext_tax (FLOAT4), tpcds.catalog_sales.cs_coupon_amt (FLOAT4), tpcds.catalog_sales.cs_ext_ship_cost (FLOAT4), tpcds.catalog_sales.cs_net_paid (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_tax (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship_tax (FLOAT4), tpcds.catalog_sales.cs_net_profit (FLOAT4)}
The next plan is generated by Optimizer.
LIMIT(7) 100 SORT(6) => Sort Keys: tpcds.customer_address.ca_zip (TEXT) (asc) GROUP_BY(5)(ca_zip) => exprs: (sum(tpcds.catalog_sales.cs_sales_price (FLOAT4))) => target list: tpcds.customer_address.ca_zip (TEXT), ?sum (FLOAT8) => out schema:{(2) tpcds.customer_address.ca_zip (TEXT), ?sum (FLOAT8)} => in schema:{(2) tpcds.customer_address.ca_zip (TEXT), tpcds.catalog_sales.cs_sales_price (FLOAT4)} JOIN(15)(INNER) => Join Cond: tpcds.catalog_sales.cs_bill_customer_sk (INT4) = tpcds.customer.c_customer_sk (INT4) => target list: tpcds.customer_address.ca_zip (TEXT), tpcds.catalog_sales.cs_sales_price (FLOAT4) => out schema: {(2) tpcds.customer_address.ca_zip (TEXT), tpcds.catalog_sales.cs_sales_price (FLOAT4)} => in schema: {(4) tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.customer_address.ca_zip (TEXT), tpcds.customer.c_customer_sk (INT4)} JOIN(13)(INNER) => Join Cond: tpcds.customer.c_current_addr_sk (INT4) = tpcds.customer_address.ca_address_sk (INT4) => target list: tpcds.customer_address.ca_zip (TEXT), tpcds.customer.c_customer_sk (INT4) => out schema: {(2) tpcds.customer_address.ca_zip (TEXT), tpcds.customer.c_customer_sk (INT4)} => in schema: {(4) tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_current_addr_sk (INT4), tpcds.customer_address.ca_zip (TEXT), tpcds.customer_address.ca_address_sk (INT4)} SCAN(2) on tpcds.customer_address => target list: tpcds.customer_address.ca_zip (TEXT), tpcds.customer_address.ca_address_sk (INT4) => out schema: {(2) tpcds.customer_address.ca_zip (TEXT), tpcds.customer_address.ca_address_sk (INT4)} => in schema: {(13) tpcds.customer_address.ca_address_sk (INT4), tpcds.customer_address.ca_address_id (TEXT), tpcds.customer_address.ca_street_number (TEXT), tpcds.customer_address.ca_street_name (TEXT), tpcds.customer_address.ca_street_type (TEXT), tpcds.customer_address.ca_suite_number (TEXT), tpcds.customer_address.ca_city (TEXT), tpcds.customer_address.ca_county (TEXT), tpcds.customer_address.ca_state (TEXT), tpcds.customer_address.ca_zip (TEXT), tpcds.customer_address.ca_country (TEXT), tpcds.customer_address.ca_gmt_offset (FLOAT4), tpcds.customer_address.ca_location_type (TEXT)} SCAN(1) on tpcds.customer => target list: tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_current_addr_sk (INT4) => out schema: {(2) tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_current_addr_sk (INT4)} => in schema: {(18) tpcds.customer.c_customer_sk (INT4), tpcds.customer.c_customer_id (TEXT), tpcds.customer.c_current_cdemo_sk (INT4), tpcds.customer.c_current_hdemo_sk (INT4), tpcds.customer.c_current_addr_sk (INT4), tpcds.customer.c_first_shipto_date_sk (INT4), tpcds.customer.c_first_sales_date_sk (INT4), tpcds.customer.c_salutation (TEXT), tpcds.customer.c_first_name (TEXT), tpcds.customer.c_last_name (TEXT), tpcds.customer.c_preferred_cust_flag (TEXT), tpcds.customer.c_birth_day (INT4), tpcds.customer.c_birth_month (INT4), tpcds.customer.c_birth_year (INT4), tpcds.customer.c_birth_country (TEXT), tpcds.customer.c_login (TEXT), tpcds.customer.c_email_address (TEXT), tpcds.customer.c_last_review_date (TEXT)} JOIN(14)(INNER) => Join Cond: tpcds.catalog_sales.cs_sold_date_sk (INT4) = tpcds.date_dim.d_date_sk (INT4) => target list: tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_sales_price (FLOAT4) => out schema: {(2) tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_sales_price (FLOAT4)} => in schema: {(4) tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_sold_date_sk (INT4), tpcds.date_dim.d_date_sk (INT4)} SCAN(3) on tpcds.date_dim => filter: tpcds.date_dim.d_year (INT4) = 2000 AND tpcds.date_dim.d_qoy (INT4) = 2 => target list: tpcds.date_dim.d_date_sk (INT4) => out schema: {(1) tpcds.date_dim.d_date_sk (INT4)} => in schema: {(28) tpcds.date_dim.d_date_sk (INT4), tpcds.date_dim.d_date_id (TEXT), tpcds.date_dim.d_date (DATE), tpcds.date_dim.d_month_seq (INT4), tpcds.date_dim.d_week_seq (INT4), tpcds.date_dim.d_quarter_seq (INT4), tpcds.date_dim.d_year (INT4), tpcds.date_dim.d_dow (INT4), tpcds.date_dim.d_moy (INT4), tpcds.date_dim.d_dom (INT4), tpcds.date_dim.d_qoy (INT4), tpcds.date_dim.d_fy_year (INT4), tpcds.date_dim.d_fy_quarter_seq (INT4), tpcds.date_dim.d_fy_week_seq (INT4), tpcds.date_dim.d_day_name (TEXT), tpcds.date_dim.d_quarter_name (TEXT), tpcds.date_dim.d_holiday (TEXT), tpcds.date_dim.d_weekend (TEXT), tpcds.date_dim.d_following_holiday (TEXT), tpcds.date_dim.d_first_dom (INT4), tpcds.date_dim.d_last_dom (INT4), tpcds.date_dim.d_same_day_ly (INT4), tpcds.date_dim.d_same_day_lq (INT4), tpcds.date_dim.d_current_day (TEXT), tpcds.date_dim.d_current_week (TEXT), tpcds.date_dim.d_current_month (TEXT), tpcds.date_dim.d_current_quarter (TEXT), tpcds.date_dim.d_current_year (TEXT)} SCAN(0) on tpcds.catalog_sales => target list: tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_sold_date_sk (INT4) => out schema: {(3) tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_sold_date_sk (INT4)} => in schema: {(34) tpcds.catalog_sales.cs_sold_date_sk (INT4), tpcds.catalog_sales.cs_sold_time_sk (INT4), tpcds.catalog_sales.cs_ship_date_sk (INT4), tpcds.catalog_sales.cs_bill_customer_sk (INT4), tpcds.catalog_sales.cs_bill_cdemo_sk (INT4), tpcds.catalog_sales.cs_bill_hdemo_sk (INT4), tpcds.catalog_sales.cs_bill_addr_sk (INT4), tpcds.catalog_sales.cs_ship_customer_sk (INT4), tpcds.catalog_sales.cs_ship_cdemo_sk (INT4), tpcds.catalog_sales.cs_ship_hdemo_sk (INT4), tpcds.catalog_sales.cs_ship_addr_sk (INT4), tpcds.catalog_sales.cs_call_center_sk (INT4), tpcds.catalog_sales.cs_catalog_page_sk (INT4), tpcds.catalog_sales.cs_ship_mode_sk (INT4), tpcds.catalog_sales.cs_warehouse_sk (INT4), tpcds.catalog_sales.cs_item_sk (INT4), tpcds.catalog_sales.cs_promo_sk (INT4), tpcds.catalog_sales.cs_order_number (INT4), tpcds.catalog_sales.cs_quantity (INT4), tpcds.catalog_sales.cs_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_list_price (FLOAT4), tpcds.catalog_sales.cs_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_discount_amt (FLOAT4), tpcds.catalog_sales.cs_ext_sales_price (FLOAT4), tpcds.catalog_sales.cs_ext_wholesale_cost (FLOAT4), tpcds.catalog_sales.cs_ext_list_price (FLOAT4), tpcds.catalog_sales.cs_ext_tax (FLOAT4), tpcds.catalog_sales.cs_coupon_amt (FLOAT4), tpcds.catalog_sales.cs_ext_ship_cost (FLOAT4), tpcds.catalog_sales.cs_net_paid (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_tax (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship (FLOAT4), tpcds.catalog_sales.cs_net_paid_inc_ship_tax (FLOAT4), tpcds.catalog_sales.cs_net_profit (FLOAT4)}