-- 查看表索引
show index from lredor ;
-- 創(chuàng)建單個索引 lredor表名艳狐；index_liabilitycode新建索引名；liabilitycode表字段名
ALTER TABLE lredor ADD INDEX index_liabilitycode (liabilitycode);
-- 創(chuàng)建聯(lián)合索引 index_All聯(lián)合索引名陶因；括號是所有見索引的字段
ALTER TABLE lredor ADD INDEX index_All (grppolicyno,policyno,productno,productcode,liabilitycode,reinsurercode);
