MySQL索引

-- 查看表索引

show index from lredor ;

-- 创建单个索引 lredor表名；index_liabilitycode新建索引名；liabilitycode表字段名

ALTER TABLE lredor ADD INDEX index_liabilitycode (liabilitycode);

-- 创建联合索引 index_All联合索引名；括号是所有见索引的字段

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