例子:
alter table R_DIRECTOR_INFOMATION
(表名称)
add index DIRECTOR_INFO_key(INFOMATION_ID,DIRECTOR_ID);---建普通索引
//alter table BUSINESS_INFOMATION add index USER_ID_key(USER_ID);
alter table AP_BUSINESS_INFOMATION add index SHOP_ID_key(SHOP_ID);
alter table AP_BUSINESS_INFOMATION add index DIRECTOR_ID_key(DIRECTOR_ID);
alter table R_DIRECTOR_INFOMATION add constraint id_fk(外键别名) foreign key (INFOMATION_ID) references BUSINESS_INFOMATION (id);---建外键
alter table R_DIRECTOR_INFOMATION drop foreign key id_fk;------删除索引
alter table R_DIRECTOR_INFOMATION drop index shop_id_key;-----删除索引
//alter table BUSINESS_INFOMATION add index USER_ID_key(USER_ID);
alter table AP_BUSINESS_INFOMATION add index SHOP_ID_key(SHOP_ID);
alter table AP_BUSINESS_INFOMATION add index DIRECTOR_ID_key(DIRECTOR_ID);
alter table R_DIRECTOR_INFOMATION add constraint id_fk(外键别名) foreign key (INFOMATION_ID) references BUSINESS_INFOMATION (id);---建外键
alter table R_DIRECTOR_INFOMATION drop foreign key id_fk;------删除索引
alter table R_DIRECTOR_INFOMATION drop index shop_id_key;-----删除索引
建完之后,运行
Explain+sql语句,看执行结果中的type和rows行数
type参数值参考: