use tpcds_holodesk_1;
--set holodesk.automerge.enabled=true;
analyze table catalog_sales compute statistics;
analyze table catalog_sales partition p2 compute statistics for columns; 

analyze table income_band compute statistics;
analyze table income_band compute statistics for columns ib_income_band_sk,ib_lower_bound,ib_upper_bound;
analyze table item compute statistics;
analyze table item compute statistics for columns i_item_desc,i_manufact,i_size,i_wholesale_cost,i_item_id,i_manager_id,i_units,i_category,i_brand_id,i_product_name,i_class,i_item_sk,i_manufact_id,i_class_id,i_current_price,i_brand,i_color,i_category_id;

analyze table time_dim compute statistics;
analyze table time_dim compute statistics for columns t_meal_time,t_minute,t_time_sk,t_hour,t_time;
analyze table warehouse compute statistics;
analyze table warehouse compute statistics for columns w_country,w_state,w_warehouse_sk,w_county,w_warehouse_name,w_warehouse_sq_ft,w_city;
analyze table web_page compute statistics;
analyze table web_page compute statistics for columns wp_web_page_sk,wp_char_count;
analyze table web_site compute statistics;
analyze table web_site compute statistics for columns web_name,web_company_name,web_site_id,web_site_sk;

analyze table promotion compute statistics;
analyze table promotion compute statistics for columns p_channel_tv,p_promo_sk,p_channel_dmail,p_channel_event,p_channel_email;
analyze table reason compute statistics;
analyze table reason compute statistics for columns r_reason_desc,r_reason_sk;
analyze table ship_mode compute statistics;
analyze table ship_mode compute statistics for columns sm_ship_mode_sk,sm_type,sm_carrier;
analyze table store compute statistics;
analyze table store compute statistics for columns s_store_id,s_state,s_street_name,s_city,s_street_type,s_zip,s_company_name,s_store_sk,s_gmt_offset,s_number_employees,s_company_id,s_store_name,s_county,s_suite_number,s_street_number, s_market_id;
