![mysql:添加索引 mysql:添加索引](https://image.shishitao.com:8440/aHR0cHM6Ly9ia3FzaW1nLmlrYWZhbi5jb20vdXBsb2FkL2NoYXRncHQtcy5wbmc%2FIQ%3D%3D.png?!?w=700&webp=1)
ALTER TABLE tb_user_type ADD INDEX user_type_index3 (report_type_id)
ALTER TABLE tb_user_type ADD INDEX user_type_index2 (user_id)
ALTER TABLE tb_user_type ADD INDEX user_type_index1 (id)
ALTER TABLE tb_net_user ADD INDEX net_user_index2 (net_id)
ALTER TABLE tb_net_user ADD INDEX net_user_index1 (user_id)
ALTER TABLE tb_net_user ADD INDEX net_user_index1 (user_id)
ALTER TABLE tb_dept_type ADD INDEX dept_type_index2 (REPORT_TYPE_ID)
ALTER TABLE tb_dept_type ADD INDEX dept_type_index1 (DEPT_ID)
ALTER TABLE tb_dept_type ADD INDEX dept_type_index1 (DEPT_ID)