use gosales_1021; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MariaDB [gosales_1021]> analyze table branch ; +---------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------+---------+----------+----------+ | gosales_1021.branch | analyze | status | OK | +---------------------+---------+----------+----------+ 1 row in set (0.012 sec) MariaDB [gosales_1021]> analyze table conversion_rate ; +------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------------+---------+----------+----------+ | gosales_1021.conversion_rate | analyze | status | OK | +------------------------------+---------+----------+----------+ 1 row in set (0.007 sec) MariaDB [gosales_1021]> analyze table country ; +----------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------+---------+----------+----------+ | gosales_1021.country | analyze | status | OK | +----------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosales_1021]> analyze table currency_lookup ; +------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------------+---------+----------+----------+ | gosales_1021.currency_lookup | analyze | status | OK | +------------------------------+---------+----------+----------+ 1 row in set (0.005 sec) MariaDB [gosales_1021]> analyze table euro_conversion ; +------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------------+---------+----------+----------+ | gosales_1021.euro_conversion | analyze | status | OK | +------------------------------+---------+----------+----------+ 1 row in set (0.006 sec) MariaDB [gosales_1021]> analyze table inventory_levels ; +-------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------------------+---------+----------+----------+ | gosales_1021.inventory_levels | analyze | status | OK | +-------------------------------+---------+----------+----------+ 1 row in set (0.068 sec) MariaDB [gosales_1021]> analyze table order_details ; +----------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------+---------+----------+----------+ | gosales_1021.order_details | analyze | status | OK | +----------------------------+---------+----------+----------+ 1 row in set (0.039 sec) MariaDB [gosales_1021]> analyze table order_header ; +---------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------+---------+----------+----------+ | gosales_1021.order_header | analyze | status | OK | +---------------------------+---------+----------+----------+ 1 row in set (0.015 sec) MariaDB [gosales_1021]> analyze table order_method ; +---------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------+---------+----------+----------+ | gosales_1021.order_method | analyze | status | OK | +---------------------------+---------+----------+----------+ 1 row in set (0.007 sec) MariaDB [gosales_1021]> analyze table product ; +----------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------+---------+----------+----------+ | gosales_1021.product | analyze | status | OK | +----------------------+---------+----------+----------+ 1 row in set (0.005 sec) MariaDB [gosales_1021]> analyze table product_brand ; +----------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------+---------+----------+----------+ | gosales_1021.product_brand | analyze | status | OK | +----------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosales_1021]> analyze table product_color_lookup ; +-----------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------------------------+---------+----------+----------+ | gosales_1021.product_color_lookup | analyze | status | OK | +-----------------------------------+---------+----------+----------+ 1 row in set (0.005 sec) MariaDB [gosales_1021]> analyze table product_forecast ; +-------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------------------+---------+----------+----------+ | gosales_1021.product_forecast | analyze | status | OK | +-------------------------------+---------+----------+----------+ 1 row in set (0.110 sec) MariaDB [gosales_1021]> analyze table product_line ; +---------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------+---------+----------+----------+ | gosales_1021.product_line | analyze | status | OK | +---------------------------+---------+----------+----------+ 1 row in set (0.008 sec) MariaDB [gosales_1021]> analyze table product_name_lookup ; +----------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------------+---------+----------+----------+ | gosales_1021.product_name_lookup | analyze | status | OK | +----------------------------------+---------+----------+----------+ 1 row in set (0.015 sec) MariaDB [gosales_1021]> analyze table product_size_lookup ; +----------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------------+---------+----------+----------+ | gosales_1021.product_size_lookup | analyze | status | OK | +----------------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosales_1021]> analyze table product_type ; +---------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------+---------+----------+----------+ | gosales_1021.product_type | analyze | status | OK | +---------------------------+---------+----------+----------+ 1 row in set (0.007 sec) MariaDB [gosales_1021]> analyze table return_reason ; +----------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------+---------+----------+----------+ | gosales_1021.return_reason | analyze | status | OK | +----------------------------+---------+----------+----------+ 1 row in set (0.008 sec) MariaDB [gosales_1021]> analyze table returned_item ; +----------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------+---------+----------+----------+ | gosales_1021.returned_item | analyze | status | OK | +----------------------------+---------+----------+----------+ 1 row in set (0.008 sec) MariaDB [gosales_1021]> analyze table sales_region ; +---------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------+---------+----------+----------+ | gosales_1021.sales_region | analyze | status | OK | +---------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosales_1021]> analyze table sales_target ; +---------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------+---------+----------+----------+ | gosales_1021.sales_target | analyze | status | OK | +---------------------------+---------+----------+----------+ 1 row in set (0.115 sec) MariaDB [gosales_1021]> analyze table time_dimension ; +-----------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------------------+---------+----------+----------+ | gosales_1021.time_dimension | analyze | status | OK | +-----------------------------+---------+----------+----------+ 1 row in set (0.006 sec) MariaDB [gosales_1021]> analyze table time_quarter_lookup ; +----------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------------+---------+----------+----------+ | gosales_1021.time_quarter_lookup | analyze | status | OK | +----------------------------------+---------+----------+----------+ 1 row in set (0.005 sec) MariaDB [gosales_1021]> analyze table xgorev ; +---------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------+---------+----------+----------+ | gosales_1021.xgorev | analyze | status | OK | +---------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosales_1021]> MariaDB [gosales_1021]> use gosalesdw_1021; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MariaDB [gosalesdw_1021]> MariaDB [gosalesdw_1021]> analyze table aggr_time_prod_om_fact ; +---------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------------------+---------+----------+----------+ | gosalesdw_1021.aggr_time_prod_om_fact | analyze | status | OK | +---------------------------------------+---------+----------+----------+ 1 row in set (0.007 sec) MariaDB [gosalesdw_1021]> analyze table burst_table ; +----------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------+---------+----------+----------+ | gosalesdw_1021.burst_table | analyze | status | OK | +----------------------------+---------+----------+----------+ 1 row in set (0.003 sec) MariaDB [gosalesdw_1021]> analyze table burst_table2 ; +-----------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------------------+---------+----------+----------+ | gosalesdw_1021.burst_table2 | analyze | status | OK | +-----------------------------+---------+----------+----------+ 1 row in set (0.005 sec) MariaDB [gosalesdw_1021]> analyze table dist_inventory_fact ; +------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------------------+---------+----------+----------+ | gosalesdw_1021.dist_inventory_fact | analyze | status | OK | +------------------------------------+---------+----------+----------+ 1 row in set (0.028 sec) +-------------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------------------------------+---------+----------+----------+ | gosalesdw_1021.dist_product_forecast_fact | analyze | status | OK | +-------------------------------------------+---------+----------+----------+ 1 row in set (0.183 sec) MariaDB [gosalesdw_1021]> analyze table dist_return_reason_dim ; +---------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------------------+---------+----------+----------+ | gosalesdw_1021.dist_return_reason_dim | analyze | status | OK | +---------------------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosalesdw_1021]> analyze table dist_returned_items_fact ; +-----------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------------------------------+---------+----------+----------+ | gosalesdw_1021.dist_returned_items_fact | analyze | status | OK | +-----------------------------------------+---------+----------+----------+ 1 row in set (0.014 sec) MariaDB [gosalesdw_1021]> analyze table emp_employee_dim ; +---------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------------+---------+----------+----------+ | gosalesdw_1021.emp_employee_dim | analyze | status | OK | +---------------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosalesdw_1021]> analyze table emp_expense_fact ; +---------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------------+---------+----------+----------+ | gosalesdw_1021.emp_expense_fact | analyze | status | OK | +---------------------------------+---------+----------+----------+ 1 row in set (0.067 sec) MariaDB [gosalesdw_1021]> analyze table emp_expense_plan_fact ; +--------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------------------------------+---------+----------+----------+ | gosalesdw_1021.emp_expense_plan_fact | analyze | status | OK | +--------------------------------------+---------+----------+----------+ 1 row in set (0.029 sec) MariaDB [gosalesdw_1021]> analyze table emp_expense_type_dim ; +-------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------------------------+---------+----------+----------+ | gosalesdw_1021.emp_expense_type_dim | analyze | status | OK | +-------------------------------------+---------+----------+----------+ 1 row in set (0.006 sec) MariaDB [gosalesdw_1021]> analyze table emp_expense_unit_lookup ; +----------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------------------+---------+----------+----------+ | gosalesdw_1021.emp_expense_unit_lookup | analyze | status | OK | +----------------------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosalesdw_1021]> analyze table emp_position_dim ; +---------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------------+---------+----------+----------+ | gosalesdw_1021.emp_position_dim | analyze | status | OK | +---------------------------------+---------+----------+----------+ 1 row in set (0.005 sec) MariaDB [gosalesdw_1021]> analyze table emp_position_lookup ; +------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------------------+---------+----------+----------+ | gosalesdw_1021.emp_position_lookup | analyze | status | OK | +------------------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosalesdw_1021]> analyze table emp_position_summary_fact ; +------------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------------------------+---------+----------+----------+ | gosalesdw_1021.emp_position_summary_fact | analyze | status | OK | +------------------------------------------+---------+----------+----------+ 1 row in set (0.012 sec) MariaDB [gosalesdw_1021]> analyze table emp_ranking_dim ; +--------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------------------------+---------+----------+----------+ | gosalesdw_1021.emp_ranking_dim | analyze | status | OK | +--------------------------------+---------+----------+----------+ 1 row in set (0.005 sec) MariaDB [gosalesdw_1021]> analyze table emp_ranking_fact ; +---------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------------+---------+----------+----------+ | gosalesdw_1021.emp_ranking_fact | analyze | status | OK | +---------------------------------+---------+----------+----------+ 1 row in set (0.009 sec) MariaDB [gosalesdw_1021]> analyze table emp_recruitment_dim ; +------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------------------+---------+----------+----------+ | gosalesdw_1021.emp_recruitment_dim | analyze | status | OK | +------------------------------------+---------+----------+----------+ 1 row in set (0.008 sec) MariaDB [gosalesdw_1021]> analyze table emp_recruitment_fact ; +-------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------------------------+---------+----------+----------+ | gosalesdw_1021.emp_recruitment_fact | analyze | status | OK | +-------------------------------------+---------+----------+----------+ 1 row in set (0.006 sec) MariaDB [gosalesdw_1021]> analyze table emp_recruitment_lead_fact ; +------------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------------------------+---------+----------+----------+ | gosalesdw_1021.emp_recruitment_lead_fact | analyze | status | OK | +------------------------------------------+---------+----------+----------+ 1 row in set (0.011 sec) MariaDB [gosalesdw_1021]> analyze table emp_succession_fact ; +------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------------------+---------+----------+----------+ | gosalesdw_1021.emp_succession_fact | analyze | status | OK | +------------------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosalesdw_1021]> analyze table emp_succession_status_dim ; +------------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------------------------+---------+----------+----------+ | gosalesdw_1021.emp_succession_status_dim | analyze | status | OK | +------------------------------------------+---------+----------+----------+ 1 row in set (0.005 sec) MariaDB [gosalesdw_1021]> analyze table emp_summary_fact ; +---------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------------+---------+----------+----------+ | gosalesdw_1021.emp_summary_fact | analyze | status | OK | +---------------------------------+---------+----------+----------+ 1 row in set (0.017 sec) MariaDB [gosalesdw_1021]> analyze table emp_survey_fact ; +--------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------------------------+---------+----------+----------+ | gosalesdw_1021.emp_survey_fact | analyze | status | OK | +--------------------------------+---------+----------+----------+ 1 row in set (0.010 sec) MariaDB [gosalesdw_1021]> analyze table emp_survey_targ_fact ; +-------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------------------------+---------+----------+----------+ | gosalesdw_1021.emp_survey_targ_fact | analyze | status | OK | +-------------------------------------+---------+----------+----------+ 1 row in set (0.005 sec) MariaDB [gosalesdw_1021]> analyze table emp_survey_topic_dim ; +-------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------------------------+---------+----------+----------+ | gosalesdw_1021.emp_survey_topic_dim | analyze | status | OK | +-------------------------------------+---------+----------+----------+ 1 row in set (0.006 sec) MariaDB [gosalesdw_1021]> analyze table emp_termination_lookup ; +---------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------------------+---------+----------+----------+ | gosalesdw_1021.emp_termination_lookup | analyze | status | OK | +---------------------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosalesdw_1021]> analyze table emp_training_dim ; +---------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------------+---------+----------+----------+ | gosalesdw_1021.emp_training_dim | analyze | status | OK | +---------------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosalesdw_1021]> analyze table emp_training_fact ; +----------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------------+---------+----------+----------+ | gosalesdw_1021.emp_training_fact | analyze | status | OK | +----------------------------------+---------+----------+----------+ 1 row in set (0.009 sec) MariaDB [gosalesdw_1021]> analyze table fin_account_class_lookup ; +-----------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------------------------------+---------+----------+----------+ | gosalesdw_1021.fin_account_class_lookup | analyze | status | OK | +-----------------------------------------+---------+----------+----------+ 1 row in set (0.006 sec) MariaDB [gosalesdw_1021]> analyze table fin_account_dim ; +--------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------------------------+---------+----------+----------+ | gosalesdw_1021.fin_account_dim | analyze | status | OK | +--------------------------------+---------+----------+----------+ 1 row in set (0.006 sec) MariaDB [gosalesdw_1021]> analyze table fin_account_name_lookup ; +----------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------------------+---------+----------+----------+ | gosalesdw_1021.fin_account_name_lookup | analyze | status | OK | +----------------------------------------+---------+----------+----------+ 1 row in set (0.005 sec) MariaDB [gosalesdw_1021]> analyze table fin_account_type_lookup ; +----------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------------------+---------+----------+----------+ | gosalesdw_1021.fin_account_type_lookup | analyze | status | OK | +----------------------------------------+---------+----------+----------+ 1 row in set (0.003 sec) MariaDB [gosalesdw_1021]> analyze table fin_finance_fact ; +---------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------------+---------+----------+----------+ | gosalesdw_1021.fin_finance_fact | analyze | status | OK | +---------------------------------+---------+----------+----------+ 1 row in set (0.086 sec) MariaDB [gosalesdw_1021]> analyze table fin_subm_currency_lookup ; +-----------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------------------------------+---------+----------+----------+ | gosalesdw_1021.fin_subm_currency_lookup | analyze | status | OK | +-----------------------------------------+---------+----------+----------+ 1 row in set (0.006 sec) MariaDB [gosalesdw_1021]> analyze table fin_subm_dim ; +-----------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------------------+---------+----------+----------+ | gosalesdw_1021.fin_subm_dim | analyze | status | OK | +-----------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosalesdw_1021]> analyze table fin_subm_type_lookup ; +-------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------------------------+---------+----------+----------+ | gosalesdw_1021.fin_subm_type_lookup | analyze | status | OK | +-------------------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosalesdw_1021]> analyze table go_branch_dim ; +------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------------+---------+----------+----------+ | gosalesdw_1021.go_branch_dim | analyze | status | OK | +------------------------------+---------+----------+----------+ 1 row in set (0.003 sec) MariaDB [gosalesdw_1021]> analyze table go_gender_lookup ; +---------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------------+---------+----------+----------+ | gosalesdw_1021.go_gender_lookup | analyze | status | OK | +---------------------------------+---------+----------+----------+ 1 row in set (0.005 sec) MariaDB [gosalesdw_1021]> analyze table go_org_dim ; +---------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------+---------+----------+----------+ | gosalesdw_1021.go_org_dim | analyze | status | OK | +---------------------------+---------+----------+----------+ 1 row in set (0.005 sec) MariaDB [gosalesdw_1021]> analyze table go_org_name_lookup ; +-----------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------------------------+---------+----------+----------+ | gosalesdw_1021.go_org_name_lookup | analyze | status | OK | +-----------------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosalesdw_1021]> analyze table go_region_dim ; +------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------------+---------+----------+----------+ | gosalesdw_1021.go_region_dim | analyze | status | OK | +------------------------------+---------+----------+----------+ 1 row in set (0.005 sec) MariaDB [gosalesdw_1021]> analyze table go_satisfaction_dim ; +------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------------------+---------+----------+----------+ | gosalesdw_1021.go_satisfaction_dim | analyze | status | OK | +------------------------------------+---------+----------+----------+ 1 row in set (0.005 sec) MariaDB [gosalesdw_1021]> analyze table go_time_dim ; +----------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------+---------+----------+----------+ | gosalesdw_1021.go_time_dim | analyze | status | OK | +----------------------------+---------+----------+----------+ 1 row in set (0.006 sec) MariaDB [gosalesdw_1021]> analyze table go_time_quarter_lookup ; +---------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------------------+---------+----------+----------+ | gosalesdw_1021.go_time_quarter_lookup | analyze | status | OK | +---------------------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosalesdw_1021]> analyze table mrk_activity_status_dim ; +----------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------------------+---------+----------+----------+ | gosalesdw_1021.mrk_activity_status_dim | analyze | status | OK | +----------------------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosalesdw_1021]> analyze table mrk_adv_fact ; +-----------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------------------+---------+----------+----------+ | gosalesdw_1021.mrk_adv_fact | analyze | status | OK | +-----------------------------+---------+----------+----------+ 1 row in set (0.007 sec) MariaDB [gosalesdw_1021]> analyze table mrk_bundle_group_lookup ; +----------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------------------+---------+----------+----------+ | gosalesdw_1021.mrk_bundle_group_lookup | analyze | status | OK | +----------------------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosalesdw_1021]> analyze table mrk_campaign_lookup ; +------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------------------+---------+----------+----------+ | gosalesdw_1021.mrk_campaign_lookup | analyze | status | OK | +------------------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosalesdw_1021]> analyze table mrk_prod_survey_targ_fact ; +------------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------------------------+---------+----------+----------+ | gosalesdw_1021.mrk_prod_survey_targ_fact | analyze | status | OK | +------------------------------------------+---------+----------+----------+ 1 row in set (0.008 sec) MariaDB [gosalesdw_1021]> analyze table mrk_product_survey_dim ; +---------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------------------+---------+----------+----------+ | gosalesdw_1021.mrk_product_survey_dim | analyze | status | OK | +---------------------------------------+---------+----------+----------+ 1 row in set (0.007 sec) MariaDB [gosalesdw_1021]> analyze table mrk_product_survey_fact ; +----------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------------------+---------+----------+----------+ | gosalesdw_1021.mrk_product_survey_fact | analyze | status | OK | +----------------------------------------+---------+----------+----------+ 1 row in set (0.128 sec) MariaDB [gosalesdw_1021]> analyze table mrk_promotion_dim ; +----------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------------+---------+----------+----------+ | gosalesdw_1021.mrk_promotion_dim | analyze | status | OK | +----------------------------------+---------+----------+----------+ 1 row in set (0.005 sec) MariaDB [gosalesdw_1021]> analyze table mrk_promotion_fact ; +-----------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------------------------+---------+----------+----------+ | gosalesdw_1021.mrk_promotion_fact | analyze | status | OK | +-----------------------------------+---------+----------+----------+ 1 row in set (0.018 sec) MariaDB [gosalesdw_1021]> analyze table mrk_promotion_plan_fact ; +----------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------------------+---------+----------+----------+ | gosalesdw_1021.mrk_promotion_plan_fact | analyze | status | OK | +----------------------------------------+---------+----------+----------+ 1 row in set (0.011 sec) MariaDB [gosalesdw_1021]> analyze table mrk_rtl_survey_dim ; +-----------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------------------------+---------+----------+----------+ | gosalesdw_1021.mrk_rtl_survey_dim | analyze | status | OK | +-----------------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosalesdw_1021]> analyze table mrk_rtl_survey_fact ; +------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------------------+---------+----------+----------+ | gosalesdw_1021.mrk_rtl_survey_fact | analyze | status | OK | +------------------------------------+---------+----------+----------+ 1 row in set (0.021 sec) MariaDB [gosalesdw_1021]> analyze table mrk_rtl_survey_targ_fact ; +-----------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------------------------------+---------+----------+----------+ | gosalesdw_1021.mrk_rtl_survey_targ_fact | analyze | status | OK | +-----------------------------------------+---------+----------+----------+ 1 row in set (0.005 sec) MariaDB [gosalesdw_1021]> analyze table sls_order_method_dim ; +-------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------------------------+---------+----------+----------+ | gosalesdw_1021.sls_order_method_dim | analyze | status | OK | +-------------------------------------+---------+----------+----------+ 1 row in set (0.005 sec) MariaDB [gosalesdw_1021]> analyze table sls_product_brand_lookup ; +-----------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------------------------------+---------+----------+----------+ | gosalesdw_1021.sls_product_brand_lookup | analyze | status | OK | +-----------------------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosalesdw_1021]> analyze table sls_product_color_lookup ; +-----------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------------------------------+---------+----------+----------+ | gosalesdw_1021.sls_product_color_lookup | analyze | status | OK | +-----------------------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosalesdw_1021]> analyze table sls_product_dim ; +--------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------------------------+---------+----------+----------+ | gosalesdw_1021.sls_product_dim | analyze | status | OK | +--------------------------------+---------+----------+----------+ 1 row in set (0.003 sec) MariaDB [gosalesdw_1021]> analyze table sls_product_line_lookup ; +----------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------------------+---------+----------+----------+ | gosalesdw_1021.sls_product_line_lookup | analyze | status | OK | +----------------------------------------+---------+----------+----------+ 1 row in set (0.005 sec) MariaDB [gosalesdw_1021]> analyze table sls_product_lookup ; +-----------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------------------------+---------+----------+----------+ | gosalesdw_1021.sls_product_lookup | analyze | status | OK | +-----------------------------------+---------+----------+----------+ 1 row in set (0.009 sec) MariaDB [gosalesdw_1021]> analyze table sls_product_size_lookup ; +----------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------------------+---------+----------+----------+ | gosalesdw_1021.sls_product_size_lookup | analyze | status | OK | +----------------------------------------+---------+----------+----------+ 1 row in set (0.003 sec) MariaDB [gosalesdw_1021]> analyze table sls_product_type_lookup ; +----------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------------------+---------+----------+----------+ | gosalesdw_1021.sls_product_type_lookup | analyze | status | OK | +----------------------------------------+---------+----------+----------+ 1 row in set (0.003 sec) MariaDB [gosalesdw_1021]> analyze table sls_rtl_dim ; +----------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------+---------+----------+----------+ | gosalesdw_1021.sls_rtl_dim | analyze | status | OK | +----------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosalesdw_1021]> analyze table sls_sales_fact ; +-------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------------------+---------+----------+----------+ | gosalesdw_1021.sls_sales_fact | analyze | status | OK | +-------------------------------+---------+----------+----------+ 1 row in set (0.195 sec) MariaDB [gosalesdw_1021]> analyze table sls_sales_order_dim ; +------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------------------+---------+----------+----------+ | gosalesdw_1021.sls_sales_order_dim | analyze | status | OK | +------------------------------------+---------+----------+----------+ 1 row in set (0.059 sec) MariaDB [gosalesdw_1021]> analyze table sls_sales_targ_fact ; +------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------------------+---------+----------+----------+ | gosalesdw_1021.sls_sales_targ_fact | analyze | status | OK | +------------------------------------+---------+----------+----------+ 1 row in set (0.105 sec) MariaDB [gosalesdw_1021]> analyze table xgorevdw ; +-------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------------+---------+----------+----------+ | gosalesdw_1021.xgorevdw | analyze | status | OK | +-------------------------+---------+----------+----------+ 1 row in set (0.003 sec) MariaDB [gosalesdw_1021]> MariaDB [gosalesdw_1021]> use gosaleshr_1021; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MariaDB [gosaleshr_1021]> MariaDB [gosaleshr_1021]> analyze table department_lookup ; +----------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------------+---------+----------+----------+ | gosaleshr_1021.department_lookup | analyze | status | OK | +----------------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosaleshr_1021]> analyze table employee ; +-------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------------+---------+----------+----------+ | gosaleshr_1021.employee | analyze | status | OK | +-------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosaleshr_1021]> analyze table employee_expense_detail ; +----------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------------------+---------+----------+----------+ | gosaleshr_1021.employee_expense_detail | analyze | status | OK | +----------------------------------------+---------+----------+----------+ 1 row in set (0.159 sec) MariaDB [gosaleshr_1021]> analyze table employee_expense_plan ; +--------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------------------------------+---------+----------+----------+ | gosaleshr_1021.employee_expense_plan | analyze | status | OK | +--------------------------------------+---------+----------+----------+ 1 row in set (0.050 sec) MariaDB [gosaleshr_1021]> analyze table employee_history ; +---------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------------+---------+----------+----------+ | gosaleshr_1021.employee_history | analyze | status | OK | +---------------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosaleshr_1021]> analyze table employee_summary ; +---------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------------+---------+----------+----------+ | gosaleshr_1021.employee_summary | analyze | status | OK | +---------------------------------+---------+----------+----------+ 1 row in set (0.045 sec) MariaDB [gosaleshr_1021]> analyze table employee_survey_results ; +----------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------------------+---------+----------+----------+ | gosaleshr_1021.employee_survey_results | analyze | status | OK | +----------------------------------------+---------+----------+----------+ 1 row in set (0.011 sec) MariaDB [gosaleshr_1021]> analyze table employee_survey_targets ; +----------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------------------+---------+----------+----------+ | gosaleshr_1021.employee_survey_targets | analyze | status | OK | +----------------------------------------+---------+----------+----------+ 1 row in set (0.008 sec) MariaDB [gosaleshr_1021]> analyze table employee_survey_topic ; +--------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------------------------------+---------+----------+----------+ | gosaleshr_1021.employee_survey_topic | analyze | status | OK | +--------------------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosaleshr_1021]> analyze table expense_group ; +------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------------+---------+----------+----------+ | gosaleshr_1021.expense_group | analyze | status | OK | +------------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosaleshr_1021]> analyze table expense_type ; +-----------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------------------+---------+----------+----------+ | gosaleshr_1021.expense_type | analyze | status | OK | +-----------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosaleshr_1021]> analyze table expense_unit ; +-----------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------------------+---------+----------+----------+ | gosaleshr_1021.expense_unit | analyze | status | OK | +-----------------------------+---------+----------+----------+ 1 row in set (0.003 sec) MariaDB [gosaleshr_1021]> analyze table gender_lookup ; +------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------------+---------+----------+----------+ | gosaleshr_1021.gender_lookup | analyze | status | OK | +------------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosaleshr_1021]> analyze table organization ; +-----------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------------------+---------+----------+----------+ | gosaleshr_1021.organization | analyze | status | OK | +-----------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosaleshr_1021]> analyze table position_department ; +------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------------------+---------+----------+----------+ | gosaleshr_1021.position_department | analyze | status | OK | +------------------------------------+---------+----------+----------+ 1 row in set (0.003 sec) MariaDB [gosaleshr_1021]> analyze table position_lookup ; +--------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------------------------+---------+----------+----------+ | gosaleshr_1021.position_lookup | analyze | status | OK | +--------------------------------+---------+----------+----------+ 1 row in set (0.003 sec) MariaDB [gosaleshr_1021]> analyze table position_summary ; +---------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------------+---------+----------+----------+ | gosaleshr_1021.position_summary | analyze | status | OK | +---------------------------------+---------+----------+----------+ 1 row in set (0.019 sec) MariaDB [gosaleshr_1021]> analyze table ranking ; +------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------+---------+----------+----------+ | gosaleshr_1021.ranking | analyze | status | OK | +------------------------+---------+----------+----------+ 1 row in set (0.003 sec) MariaDB [gosaleshr_1021]> analyze table ranking_results ; +--------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------------------------+---------+----------+----------+ | gosaleshr_1021.ranking_results | analyze | status | OK | +--------------------------------+---------+----------+----------+ 1 row in set (0.006 sec) MariaDB [gosaleshr_1021]> analyze table recruitment ; +----------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------+---------+----------+----------+ | gosaleshr_1021.recruitment | analyze | status | OK | +----------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosaleshr_1021]> analyze table recruitment_medium ; +-----------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------------------------+---------+----------+----------+ | gosaleshr_1021.recruitment_medium | analyze | status | OK | +-----------------------------------+---------+----------+----------+ 1 row in set (0.005 sec) MariaDB [gosaleshr_1021]> analyze table recruitment_type ; +---------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------------+---------+----------+----------+ | gosaleshr_1021.recruitment_type | analyze | status | OK | +---------------------------------+---------+----------+----------+ 1 row in set (0.005 sec) MariaDB [gosaleshr_1021]> analyze table satisfaction_index ; +-----------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------------------------+---------+----------+----------+ | gosaleshr_1021.satisfaction_index | analyze | status | OK | +-----------------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosaleshr_1021]> analyze table succession_details ; +-----------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------------------------+---------+----------+----------+ | gosaleshr_1021.succession_details | analyze | status | OK | +-----------------------------------+---------+----------+----------+ 1 row in set (0.005 sec) MariaDB [gosaleshr_1021]> analyze table successor_status ; +---------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------------+---------+----------+----------+ | gosaleshr_1021.successor_status | analyze | status | OK | +---------------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosaleshr_1021]> analyze table termination_lookup ; +-----------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------------------------+---------+----------+----------+ | gosaleshr_1021.termination_lookup | analyze | status | OK | +-----------------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosaleshr_1021]> analyze table training ; +-------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------------+---------+----------+----------+ | gosaleshr_1021.training | analyze | status | OK | +-------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosaleshr_1021]> analyze table training_details ; +---------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------------+---------+----------+----------+ | gosaleshr_1021.training_details | analyze | status | OK | +---------------------------------+---------+----------+----------+ 1 row in set (0.007 sec) MariaDB [gosaleshr_1021]> MariaDB [gosaleshr_1021]> use gosalesmr_1021; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MariaDB [gosalesmr_1021]> MariaDB [gosalesmr_1021]> analyze table product_survey_results ; +---------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------------------+---------+----------+----------+ | gosalesmr_1021.product_survey_results | analyze | status | OK | +---------------------------------------+---------+----------+----------+ 1 row in set (0.194 sec) MariaDB [gosalesmr_1021]> analyze table product_survey_targets ; +---------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------------------+---------+----------+----------+ | gosalesmr_1021.product_survey_targets | analyze | status | OK | +---------------------------------------+---------+----------+----------+ 1 row in set (0.016 sec) MariaDB [gosalesmr_1021]> analyze table product_survey_topic ; +-------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------------------------+---------+----------+----------+ | gosalesmr_1021.product_survey_topic | analyze | status | OK | +-------------------------------------+---------+----------+----------+ 1 row in set (0.008 sec) MariaDB [gosalesmr_1021]> analyze table promotion_bundle_group ; +---------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------------------+---------+----------+----------+ | gosalesmr_1021.promotion_bundle_group | analyze | status | OK | +---------------------------------------+---------+----------+----------+ 1 row in set (0.005 sec) MariaDB [gosalesmr_1021]> analyze table promotion_campaign ; +-----------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------------------------+---------+----------+----------+ | gosalesmr_1021.promotion_campaign | analyze | status | OK | +-----------------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosalesmr_1021]> analyze table promotion_plan ; +-------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------------------+---------+----------+----------+ | gosalesmr_1021.promotion_plan | analyze | status | OK | +-------------------------------+---------+----------+----------+ 1 row in set (0.018 sec) MariaDB [gosalesmr_1021]> analyze table promotions ; +---------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------+---------+----------+----------+ | gosalesmr_1021.promotions | analyze | status | OK | +---------------------------+---------+----------+----------+ 1 row in set (0.006 sec) MariaDB [gosalesmr_1021]> analyze table retailer_survey_results ; +----------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------------------+---------+----------+----------+ | gosalesmr_1021.retailer_survey_results | analyze | status | OK | +----------------------------------------+---------+----------+----------+ 1 row in set (0.025 sec) MariaDB [gosalesmr_1021]> analyze table retailer_survey_targets ; +----------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------------------+---------+----------+----------+ | gosalesmr_1021.retailer_survey_targets | analyze | status | OK | +----------------------------------------+---------+----------+----------+ 1 row in set (0.008 sec) MariaDB [gosalesmr_1021]> analyze table retailer_survey_topic ; +--------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------------------------------+---------+----------+----------+ | gosalesmr_1021.retailer_survey_topic | analyze | status | OK | +--------------------------------------+---------+----------+----------+ 1 row in set (0.006 sec) MariaDB [gosalesmr_1021]> MariaDB [gosalesmr_1021]> use gosalesrt_1021; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MariaDB [gosalesrt_1021]> MariaDB [gosalesrt_1021]> analyze table activity_status_lookup ; +---------------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------------------+---------+----------+----------+ | gosalesrt_1021.activity_status_lookup | analyze | status | OK | +---------------------------------------+---------+----------+----------+ 1 row in set (0.005 sec) MariaDB [gosalesrt_1021]> analyze table retailer ; +-------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------------+---------+----------+----------+ | gosalesrt_1021.retailer | analyze | status | OK | +-------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosalesrt_1021]> analyze table retailer_activity ; +----------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------------------+---------+----------+----------+ | gosalesrt_1021.retailer_activity | analyze | status | OK | +----------------------------------+---------+----------+----------+ 1 row in set (0.012 sec) MariaDB [gosalesrt_1021]> analyze table retailer_contact ; +---------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------------+---------+----------+----------+ | gosalesrt_1021.retailer_contact | analyze | status | OK | +---------------------------------+---------+----------+----------+ 1 row in set (0.006 sec) MariaDB [gosalesrt_1021]> analyze table retailer_site ; +------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------------+---------+----------+----------+ | gosalesrt_1021.retailer_site | analyze | status | OK | +------------------------------+---------+----------+----------+ 1 row in set (0.006 sec) MariaDB [gosalesrt_1021]> analyze table retailer_site_mb ; +---------------------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------------------+---------+----------+----------+ | gosalesrt_1021.retailer_site_mb | analyze | status | OK | +---------------------------------+---------+----------+----------+ 1 row in set (0.004 sec) MariaDB [gosalesrt_1021]> analyze table retailer_type ;