Mysql 效率left join 与inner join 问题

最新推荐文章于 2024-08-23 10:05:44 发布

Leroyy

最新推荐文章于 2024-08-23 10:05:44 发布

阅读量1.1k

点赞数

分类专栏： Mysql 文章标签： sql join

本文链接：https://blog.csdn.net/Leroyy/article/details/81948814

版权

Mysql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

    SELECT
		tod.id AS "id",
		tod.user_id AS "fromUserId",
		tod. STATUS AS "odStatus",
		tod.created_at AS "createdAt",
		tod.amount AS "amount",
		tor.type AS "type",
		tor. STATUS AS "orStatus",
		tor.duration AS "duration"
	FROM
		t_order tod
	Left JOIN t_order_request tor 
    ON 
        tor.id = tod.id
	ORDER BY
		tod.created_at DESC
	LIMIT 20 OFFSET 0

上面就LEFT 改成 INNER 效率会提升很多？？？

left 0.5s左右，inner :5s左右，为什么？？？