深圳智汇创想科技有限公司

需求内容：
1、重构索引
2、凤凰计划查询优化：
针对以下条件做内存过滤 ：在线状态，商户号，是否智能刊登标识，销量
强制指定索引：针对 有 店铺id，翻页id，站点，刊登时间 强制指定索引 查询
ALTER TABLE `irobotbox_marketpublish`.`m_ebay_listing`
DROP INDEX `idx_ordersourcecountry`,
DROP INDEX `idx_LastModificationTime_OnlineStatus`,
DROP INDEX `idx_ordersourceid_productid`;

ALTER TABLE `irobotbox_marketpublish`.`m_ebay_listing`
ADD UNIQUE INDEX `uidx_productid_ordersourceid_siteid_customerid`(`ProductId` ASC, `OrderSourceId` ASC, `SiteId` ASC, `CustomerId` ASC) USING BTREE;

ALTER TABLE `irobotbox_marketpublish`.`m_ebay_listing`
DROP INDEX `uidx_customerid_ordersourceid_siteid_productid`,
DROP INDEX `idx_productid`,
DROP INDEX `idx_customerid_ordersourceid_productid_onlinestatus`,
DROP INDEX `idx_customerid_ordersourceid_productid_sku`;

ALTER TABLE `irobotbox_marketpublish`.`m_ebay_listing`
ADD INDEX `idx_OrderSourceId_SiteCode_Id_PublishTime_QuantitySold`(`OrderSourceId` ASC,`SiteCode` ASC, `Id` ASC, `PublishTime` ASC, `QuantitySold` DESC) USING BTREE;

ALTER TABLE `irobotbox_marketpublish`.`m_ebay_listing`
DROP INDEX `idx_customerid_ordersourceid_sellersku`,
ADD INDEX `idx_sellersku_ordersourceid`(`SellerSku` ASC, `OrderSourceId` ASC) USING BTREE;

ALTER TABLE `irobotbox_marketpublish`.`m_ebay_listing`
DROP INDEX `idx_Sku_CustomerId_OrderSourceId_SiteCode`,
ADD INDEX `idx_Sku_OrderSourceId_SiteCode`(`Sku` ASC, `OrderSourceId` ASC, `SiteCode` ASC) USING BTREE;

ALTER TABLE `irobotbox_marketpublish`.`m_ebay_listing`
DROP INDEX `idx_OrderSourceId_OnlineStatus_CustomerId_Id_Sku_PublishTime`;

数据库表性能优化，解决由于sql效率影响策略执行的问题。