-- 查看表索引

show index from lredor ;

-- 創(chuàng)建單個(gè)索引 lredor表名；index_liabilitycode新建索引名；liabilitycode表字段名

ALTER TABLE lredor ADD INDEX index_liabilitycode (liabilitycode);

-- 創(chuàng)建聯(lián)合索引 index_All聯(lián)合索引名；括號(hào)是所有見索引的字段

ALTER TABLE lredor ADD INDEX index_All (grppolicyno,policyno,productno,productcode,liabilitycode,reinsurercode);