智能刊登gaussdb 慢sql top 10
2.解决方案
发现未使用`ORDER BY`的`GROUP BY`查询`GROUP BY StrategyId`，该用法会导致无谓的排序产生，如果不需要排序建议添加`ORDER BY NULL`。
发现别名'Id AS StrategyId'与已存在的列名'StrategyId'相同，可能引起歧义，建议替换。
3.原sql
SELECT MarketId, Id AS StrategyId
FROM pp_phoenixplan_strategy
WHERE Id NOT IN (SELECT StrategyId
FROM sys_phoenixplandata_detail
WHERE CustomerId = 1
AND MarketId = 2
AND Time > '2022-07-29 12:05:05'
GROUP BY StrategyId)
AND CustomerId = 1
AND IsEnabled = 1
AND IsDeleted = 0
AND Id NOT IN (SELECT StrategyId
FROM pp_phoenixplan_Ebay_queue
WHERE CustomerId = 1
AND MarketId = 2
AND Time > '2022-07-29 12:05:05'
GROUP BY StrategyId)