关于子查询与left join查询数据的小实验

数据库共20W条数据(无索引)

链接查询:

SELECT
	api.*,
	uu.user_name 
FROM
	apl_application api
	LEFT JOIN uas_use uu ON uu.user_id = api.cust_manager_id;

子查询:

SELECT
	*,
	( SELECT uu.user_name FROM uas_use uu WHERE uu.user_id = api.cust_manager_id ) 
FROM
	apl_application api;