56,679
社区成员
发帖
与我相关
我的任务
分享
SELECT *
FROM mis_sales_collection msc ,
mis_gen_customers gc
WHERE msc.customer_num = gc.customer_num
AND msc.received_year = 2017
[/quote]
用了3分半钟。[/quote]
是一个表的数量大一个表的数据量小吗?SELECT *
FROM mis_sales_collection msc ,
mis_gen_customers gc
WHERE msc.customer_num = gc.customer_num
AND msc.received_year = 2017
[/quote]SELECT *
FROM mis_sales_collection msc ,
mis_gen_customers gc
WHERE msc.customer_num = gc.customer_num
AND msc.received_year = 2017
SELECT *
FROM mis_sales_collection msc ,
mis_gen_customers gc
WHERE msc.customer_num = gc.customer_num
AND msc.received_year = 2017
[/quote]
用了3分半钟。[/quote]
是一个表的数量大一个表的数据量小吗?[/quote]
explain看一下。。应该没有走索引,或者索引不理想