WITH CATEGORY_TREE AS (
		SELECT
		CONVERT(VARCHAR,A1.CATEGORY_NAME) AS CATEGORY_DEPTH ,
		A1.CATEGORY_SEQ ,
		A1.CATEGORY_ORDER ,
		A1.CATEGORY_USE ,
		A1.UP_CATEGORY_SEQ ,
		A1.CATEGORY_NAME ,
		A1.CATEGORY_NAME AS D1 ,
		A1.CATEGORY_NAME AS D2
		FROM
		CATEGORY A1 WITH(NOLOCK)
		WHERE
		A1.UP_CATEGORY_SEQ = '1'
		UNION ALL
		SELECT
		CONVERT(VARCHAR,CONCAT(CT.CATEGORY_NAME, '>', A2.CATEGORY_NAME)) AS CATEGORY_DEPTH ,
		A2.CATEGORY_SEQ ,
		A2.CATEGORY_ORDER ,
		A2.CATEGORY_USE ,
		A2.UP_CATEGORY_SEQ ,
		A2.CATEGORY_NAME ,
		CT.D1 AS D1 ,
		A2.CATEGORY_NAME AS D2
		FROM
		CATEGORY A2 WITH(NOLOCK)
		INNER JOIN CATEGORY_TREE CT ON
		CT.CATEGORY_SEQ = A2.UP_CATEGORY_SEQ
		)
		SELECT
		m1.UPLOAD_TYPE AS UPLOAD_TYPE,
		m1.CONTENTS_ID AS CONTENTS_ID,
		m1.CATEGORY_CD AS CATEGORY_CD,
		CASE
		WHEN m2.CATEGORY_DEPTH IS NULL THEN '-'
		ELSE m2.CATEGORY_DEPTH
		END AS CATEGORY_DEPTH,
		m1.CONTENTS_TITLE AS CONTENTS_TITLE,
		m1.CORPORATE,
		(SELECT COUNT(P.CONTENTS_ID) FROM SCRAP P WITH(NOLOCK) WHERE P.CONTENTS_ID = m1.CONTENTS_ID
		<include refid="evtType_scrap"/>
		) AS SCRAP_CNT,
		RANK() OVER(ORDER BY (SELECT COUNT(P.CONTENTS_ID) FROM SCRAP P WITH(NOLOCK) WHERE P.CONTENTS_ID = m1.CONTENTS_ID
		<include refid="evtType_scrap"/>
		) DESC) AS RANK,
		(SELECT MAX(P.SCRAP_DATE) FROM SCRAP P WITH(NOLOCK) WHERE P.CONTENTS_ID = m1.CONTENTS_ID
		<include refid="evtType_scrap"/>
		) AS SCRAP_DATE ,
		D1 ,
		(
		CASE
		WHEN D1 = D2 THEN ''
		ELSE D2
		END
		) AS D2
		FROM
		(
		SELECT
		CONTENTS_ID,
		UPLOAD_TYPE,
		CONTENTS_TITLE,
		CATEGORY_CD,
		VIEW_CNT,
		REG_DATE,
		CORPORATE
		FROM CONTENTS WITH(NOLOCK)
		) m1
		LEFT OUTER JOIN CATEGORY_TREE m2 ON m1.CATEGORY_CD = m2.CATEGORY_SEQ
		WHERE 1 = 1
		AND   (
		SELECT
		CATEGORY_USE
		FROM CATEGORY WITH(NOLOCK)
		WHERE CATEGORY_SEQ = m1.CATEGORY_CD
		) = 'Y'
		AND EXISTS (
		SELECT P.CONTENTS_ID
		FROM SCRAP P WITH(NOLOCK)
		WHERE P.CONTENTS_ID = m1.CONTENTS_ID
		<include refid="evtType_scrap"/>
		)
		<if test="userCorporationSeq != 1">
			AND (
			( TRY_CAST(SUBSTRING(CORPORATE, 1, CHARINDEX(',', CORPORATE + ',') - 1) AS BIGINT) = TRY_CAST(#{userCorporationSeq} AS BIGINT)
			OR TRY_CAST(SUBSTRING(CORPORATE, CHARINDEX(',', CORPORATE + ',') + 1, LEN(CORPORATE)) AS BIGINT) = TRY_CAST(#{userCorporationSeq} AS BIGINT))
			OR ( CORPORATE = 'ALL' )
			)
		</if>
		ORDER BY SCRAP_CNT DESC, SCRAP_DATE, CONTENTS_ID DESC
		<if test="offset != 0">
			OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY
		</if>

안녕하세요 이렇게 스크랩한 개수를 카테고리를 WITH절로 구성을 했는데 이게 속도가 많이 저하 된다 하더라구요

그래서 WITH절을 사용하지 않고 조회를 해야 하는데 어디부터 건드려야 할 지 모르겠네요....