//请在服务器上依次逐条执行如下sql语句（数据量低于1万可以分别批量执行删除索引语句和添加索引语句）。

//如果修改了表前缀请把wm修改为你的前缀。

//如果执行报错请联系客服。

//删除旧的索引

ALTER TABLE `wm_novel_novel` DROP INDEX `tid_uptime`; 

ALTER TABLE `wm_novel_novel` DROP INDEX `IndexName`; 

ALTER TABLE `wm_novel_rec` DROP INDEX `nid_index`; 

ALTER TABLE `wm_novel_rec` DROP INDEX `rec_index`; 

ALTER TABLE `wm_novel_chapter` DROP INDEX `nid_vid_time_Index`; 

ALTER TABLE `wm_novel_chapter` DROP INDEX `nid_time_Index`; 

ALTER TABLE `wm_novel_chapter` DROP INDEX `nid_index`; 

ALTER TABLE `wm_novel_chapter` DROP INDEX `time_index`; 

ALTER TABLE `wm_novel_chapter` DROP INDEX `cid_index`; 

ALTER TABLE `wm_novel_chapter` DROP INDEX `status_index`; 

ALTER TABLE `wm_novel_chapter` DROP INDEX `order_index`; 

//添加新的索引

ALTER TABLE `wm_novel_rec` ADD INDEX `NID_INDEX` (`rec_nid`); 

ALTER TABLE `wm_novel_rec` ADD INDEX `REC_INDEX` (`rec_rt`,`rec_icr`,`rec_ibr`,`rec_ir`,`rec_ccr`,`rec_cbr`,`rec_cr`); 

ALTER TABLE `wm_novel_timelimit` ADD INDEX `NID_INDEX` (`timelimit_nid`); 

ALTER TABLE `wm_novel_chapter` ADD INDEX `NID_INDEX` (`chapter_nid`); 

ALTER TABLE `wm_novel_chapter` ADD INDEX `VID_INDEX` (`chapter_vid`); 

ALTER TABLE `wm_novel_chapter` ADD INDEX `TIME_INDEX` (`chapter_time`); 

ALTER TABLE `wm_novel_chapter` ADD INDEX `CID_INDEX` (`chapter_cid`); 

ALTER TABLE `wm_novel_chapter` ADD INDEX `STATUS_INDEX` (`chapter_status`); 

ALTER TABLE `wm_novel_chapter` ADD INDEX `ORDER_INDEX` (`chapter_order`); 

ALTER TABLE `wm_novel_chapter` ADD INDEX `NID_TIME_INDEX` (`chapter_nid`, `chapter_time`);

ALTER TABLE `wm_novel_chapter` ADD INDEX `NID_VID_TIME_INDEX` (`chapter_nid`, `chapter_vid`,`chapter_time`);

ALTER TABLE `wm_novel_novel` ADD INDEX `AUTHOR_INDEX` (`novel_author`); 

ALTER TABLE `wm_novel_novel` ADD INDEX `UPTIME_INDEX` (`novel_uptime`); 

ALTER TABLE `wm_novel_novel` ADD INDEX `LIST_INDEX` (`novel_status`, `type_id`);

ALTER TABLE `wm_novel_novel` ADD INDEX `PRE_NEXT_INDEX` (`type_id`, `novel_id`); 

ALTER TABLE `wm_novel_novel` ADD INDEX `PINYIN_INDEX` (`novel_pinyin`); 

ALTER TABLE `wm_novel_novel` ADD INDEX `STATUS_INDEX` (`novel_status`); 

ALTER TABLE `wm_novel_novel` ADD INDEX `REPLAY_INDEX` (`novel_replay`); 

ALTER TABLE `wm_novel_novel` ADD INDEX `TYPE_INDEX` (`type_id`); 

ALTER TABLE `wm_novel_novel` ADD INDEX `SOCRE_INDEX` (`novel_score`); 

ALTER TABLE `wm_novel_novel` ADD INDEX `CREATETIME_INDEX` (`novel_createtime`); 

ALTER TABLE `wm_novel_novel` ADD INDEX `WORDNUMBER_INDEX` (`novel_wordnumber`); 

ALTER TABLE `wm_novel_novel` ADD INDEX `DING_INDEX` (`novel_ding`); 

ALTER TABLE `wm_novel_novel` ADD INDEX `CAI_INDEX` (`novel_cai`); 

ALTER TABLE `wm_novel_novel` ADD INDEX `ALLCLICK_INDEX` (`novel_allclick`); 

ALTER TABLE `wm_novel_novel` ADD INDEX `YEARCLICK_INDEX` (`novel_yearclick`); 

ALTER TABLE `wm_novel_novel` ADD INDEX `MONTHCLICK_INDEX` (`novel_monthclick`); 

ALTER TABLE `wm_novel_novel` ADD INDEX `WEEKCLICK_INDEX` (`novel_weekclick`); 

ALTER TABLE `wm_novel_novel` ADD INDEX `TODAYCLICK_INDEX` (`novel_todayclick`); 

ALTER TABLE `wm_novel_novel` ADD INDEX `ALLREC_INDEX` (`novel_allrec`); 

ALTER TABLE `wm_novel_novel` ADD INDEX `YEARREC_INDEX` (`novel_yearrec`); 

ALTER TABLE `wm_novel_novel` ADD INDEX `MONTHREC_INDEX` (`novel_monthrec`); 

ALTER TABLE `wm_novel_novel` ADD INDEX `WEEKREC_INDEX` (`novel_weekrec`); 

ALTER TABLE `wm_novel_novel` ADD INDEX `TODAYREC_INDEX` (`novel_todayrec`); 

ALTER TABLE `wm_novel_novel` ADD INDEX `ALLCOLL_INDEX` (`novel_allcoll`); 

ALTER TABLE `wm_novel_novel` ADD INDEX `YEARCOLL_INDEX` (`novel_yearcoll`); 

ALTER TABLE `wm_novel_novel` ADD INDEX `MONTHCOLL_INDEX` (`novel_monthcoll`); 

ALTER TABLE `wm_novel_novel` ADD INDEX `WEEKCOLL_INDEX` (`novel_weekcoll`); 

ALTER TABLE `wm_novel_novel` ADD INDEX `TODAYCOLL_INDEX` (`novel_todaycoll`);