SQL优化

编程Tag： 优化 select id SQL user limit pageSize currIndex

SELECT
	d.NAME,
	v.phone 
FROM
	( SELECT d.* FROM tablea d LIMIT #{currIndex} , #{pageSize}
	) AS d
	LEFT JOIN tableb v ON v.user_id = d.user_id 
WHERE
	v.del_flag = '0' 
ORDER BY
	d.add_time DESC