mysql using issue

sql1 数据量14

select t1.orderId,count(1) from xishiqu.xsq_order t1
join xishiqu.xsq_event t2 on t1.eventId=t2.eventId
where date(t1.pubTime)='2017-12-18'
group by t1.orderId
order by 2 desc

sql2 数据量1138806

select t1.orderId,count(1) from xishiqu.xsq_order t1
join xishiqu.xsq_event t2 on using(eventId)
where date(t1.pubTime)='2017-12-18'
group by t1.orderId
order by 2 desc

我一定是用了假的mysql

©著作权归作者所有,转载或内容合作请联系作者
平台声明：文章内容（如有图片或视频亦包括在内）由作者上传并发布，文章内容仅代表作者本人观点，简书系信息发布平台，仅提供信息存储服务。

推荐阅读更多精彩内容