同时有COUNT(DISTINCT)和GROUP BY的慢查询sql优化实例
项目中碰到一个慢查询,里面既有COUNT(DISTINCT),又有GROUP BY,查询性能很差,26万条数据查询下来需要18秒,sql如下SELECT a.channel_code AS channelCode, a.channel_name AS channelName, DATE_FORMAT(a.create_date, '%Y') AS orderDate, COUNT(DIST...
原创
2018-04-04 12:01:23 ·
10930 阅读 ·
0 评论