use tpcds_holodesk_1;
--set holodesk.automerge.enabled=true;
analyze table call_center compute statistics;
analyze table call_center compute statistics for columns cc_call_center_id,cc_county,cc_manager,cc_call_center_sk,cc_name;
analyze table catalog_page compute statistics;
analyze table catalog_page compute statistics for columns cp_catalog_page_id,cp_catalog_page_sk;
analyze table customer_address compute statistics;
analyze table customer_address compute statistics for columns ca_street_number,ca_city,ca_county,ca_gmt_offset,ca_state,ca_suite_number,ca_country,ca_zip,ca_address_sk,ca_street_name,ca_location_type,ca_street_type;
analyze table customer compute statistics;
analyze table customer compute statistics for columns c_last_review_date_sk,c_customer_id,c_email_address,c_login,c_first_sales_date_sk,c_preferred_cust_flag,c_first_shipto_date_sk,c_birth_day,c_customer_sk,c_first_name,c_birth_year,c_birth_month,c_current_hdemo_sk,c_last_name,c_current_addr_sk,c_birth_country,c_salutation,c_current_cdemo_sk;
analyze table customer_demographics compute statistics;
analyze table customer_demographics compute statistics for columns cd_credit_rating,cd_marital_status,cd_dep_count,cd_education_status,cd_demo_sk,cd_purchase_estimate,cd_gender,cd_dep_college_count,cd_dep_employed_count;
analyze table date_dim compute statistics;
analyze table date_dim compute statistics for columns d_dom,d_day_name,d_dow,d_moy,d_week_seq,d_year,d_quarter_name,d_date,d_qoy,d_date_sk,d_month_seq;
analyze table household_demographics compute statistics;
analyze table household_demographics compute statistics for columns hd_demo_sk,hd_vehicle_count,hd_income_band_sk,hd_dep_count,hd_buy_potential;
analyze table catalog_returns compute statistics;
analyze table catalog_returns partition p1 compute statistics for columns;
analyze table store_returns compute statistics;
analyze table store_returns partition p1 compute statistics for columns;
analyze table web_returns compute statistics;
analyze table web_returns partition p1 compute statistics for columns;
