WITH ORG_TREE AS
(
SELECT D.ORG_NAME ,
D.ORG_ID ,
D.UP_ORG_ID ,
CONVERT(VARCHAR(100), ORG_NAME) AS FULL_ORG ,
1 lvl
FROM ORGANIZATION D
WHERE D.ORDER_NO = 1
UNION ALL
SELECT E.ORG_NAME ,
E.ORG_ID ,
E.UP_ORG_ID ,
CONVERT(VARCHAR(100), OT.FULL_ORG + ' > ' + E.ORG_NAME) AS FULL_ORG ,
lvl + 1 lvl
FROM ORGANIZATION E
INNER JOIN ORG_TREE OT
ON E.UP_ORG_ID = OT.ORG_ID
)

WITH ORG_TREE_SEAR AS (

SELECT D.ORG_ID
FROM ORGANIZATION D
WHERE D.ORG_ID = #{orgId}
UNION ALL
SELECT E.ORG_ID
FROM ORGANIZATION E
INNER JOIN ORG_TREE_SEAR OT ON E.UP_ORG_ID = OT.ORG_ID
)
SELECT A.USER_ID
, B.USER_NAME
, C.ORG_NAME
, CONVERT(VARCHAR, A.CONNECT_DATE, 120) AS CONNECT_DATE
, A.USER_TYPE
, A.USER_IP
, A.SSO_ID
, G.FULL_ORG
FROM CONNECT_STAT A
LEFT OUTER JOIN USER B
ON A.USER_ID = B.USER_ID
LEFT OUTER JOIN ORGANIZATION C
ON B.ORG_ID = C.ORG_ID
LEFT OUTER JOIN ORG_TREE G
ON C.ORG_ID = G.ORG_ID
WHERE 1 = 1

AND (
A.CONNECT_DATE BETWEEN CONVERT(datetime, #{searchStDate} + ' 00:00:00', 120)
AND CONVERT(datetime, #{searchEnDate} + ' 23:59:59', 120)
)
ORDER BY CONNECT_DATE DESC
OFFSET 0 ROWS FETCH NEXT 91256 ROWS ONLY;

우선 쿼리는 이렇구요

로컬컴퓨터에서 실행했을 때는 실행속도가 얼마 안 걸렸습니다.

근데 운영 리눅스 서버에서 실행하니 실행속도가 3분이 넘어가더라구요

이 쿼리를 속도를 향상시킬 수 있는 방법이 있을까요?? ㅠ