针对这条SQL, TiDB 的查询速度较慢，是什么引起的？

等一分钟 · 2023 年11 月 8 日 01:20

	SELECT c.PERSONID,count(CALENDARDATE) AS ‘workdays’
	FROM ATDADJUSTTIMEORDER c
	INNER JOIN (select * from AtdTimeOrderCalendar where CALENDARDATE BETWEEN ‘2023-07-01’ AND ‘2023-09-30’) d ON d.TIMEORDERID=c.TIMEORDERID
	INNER JOIN psnaccount p3 ON p3.PERSONID=c.PERSONID
	WHERE d.CALENDARDATE>=p3.attendondate
	AND BEGINDATE <= ‘2023-07-01’ AND c.ENDDATE>= ‘2023-09-30’
	AND d.CALENDARDATE<=p3.DIMISSIONDATE
	AND d.CALENDARTYPE=1
	GROUP BY personid