ALTER TABLE h_acti ADD INDEX i_acti_date (date);
ALTER TABLE h_aler ADD INDEX i_aler_emai (emai);
ALTER TABLE h_arch_tick ADD INDEX i_arch_tick_tick_id (tick_id);
ALTER TABLE h_arch_tick ADD INDEX i_arch_tick_effe_scop (effe_scop);
ALTER TABLE h_arch_tick ADD INDEX i_arch_tick_crea_date (crea_date);
ALTER TABLE h_arch_tick ADD INDEX i_arch_tick_arch_date (arch_date);
ALTER TABLE h_cate ADD INDEX i_cate_orde (depa_id, pare_id, orde);
ALTER TABLE h_cate_memb ADD INDEX i_cate_memb_orde (cate_id, orde);
ALTER TABLE h_depa ADD INDEX i_depa_orde (orde);
ALTER TABLE h_depa_mana ADD INDEX i_depa_mana_orde (depa_id, orde);
ALTER TABLE h_depa_sele_conf ADD INDEX i_depa_sele_conf_date (date);
ALTER TABLE h_faq2 ADD INDEX i_faq2_effe_scop (effe_scop);
ALTER TABLE h_faq2 ADD INDEX i_faq2_orde (depa_id, pare_id, orde);
ALTER TABLE h_faq_link ADD INDEX i_faq_link_orde (depa_id, cate_id, faq, orde);
ALTER TABLE h_icon ADD INDEX i_icon_name (name);
ALTER TABLE h_tick ADD INDEX i_tick_stat (stat);
ALTER TABLE h_tick ADD INDEX i_tick_effe_scop (effe_scop);
ALTER TABLE h_tick ADD INDEX i_tick_crea_date (crea_date);
ALTER TABLE h_tick ADD INDEX i_tick_last_acti_date (last_acti_date); |