안녕하세요. 아래 쿼리가 데이터가 많아질수록 너무 느려져서 튜닝을 하려고하는데, 어디부터 손을 봐야할지 
감이 안와서...확인 좀 부탁드립니다....
최대한 줄이기는 했는데...아직도 1분이 넘게 걸리네요..

SHPDR(5천건정도) 이 테이블이 DISTINCT를 할때 10초정도 걸리는데, 그룹바이로 바꿔도 2초정도 차이나는거같습니다...
			SELECT   
			    S.WORKNM||SR.CARNUM||S.SDIFKY||SR.SHIPSQ  AS SEARCHKEY,  
			    SDIFKY AS SDIFKY,   
			    SDIFIT AS SDIFIT,         
			    S.LOCASR AS LOCASR ,   
			    LM.SHORTX AS LOCAKYNM,  
			    S.SKUKEY AS SKUKEY,  
			    SM.DESC01 AS DESC01,  
			    SM.DESC02 AS DESC02,  
			    DECODE(SUM(S.QTCOMP), 0, SUM(S.QTTAOR-S.QTCOMP) , SUM(S.QTTAOR) ) QTTAOR,  
			    SUM(S.QTTAOR-S.QTCOMP) AS QTCOMP,  
			    NVL(SM.QTYSTD,0) AS PLIQTY,  
			    NVL(SM.QTDUOM,0) AS BXIQTY,  
			    NVL(  TRUNC( SUM(S.QTTAOR-S.QTCOMP) / DECODE(SM.QTDUOM, 0, NULL,SM.QTDUOM) ) ,0) AS BOXQTY,         
			    NVL(  TRUNC( SUM(S.QTTAOR-S.QTCOMP) / DECODE(SM.QTYSTD, 0, NULL,SM.QTYSTD) ) ,0) AS PLTQTY,         
			    NVL(MOD( SUM(S.QTTAOR) , DECODE(SM.QTDUOM, NULL,0,SM.QTDUOM)),0) AS REMQTY,  
			    NVL(SM.GRSWGT,0) * (SUM(S.QTTAOR-S.QTCOMP))  AS GRSWGT,  
			    NVL(SM.GRSWGT,0)   AS GRSWGTCNT,  
			    DECODE(SUM(S.QTTAOR-S.QTCOMP) , 0 , 'FPC',  'NEW') STATIT,  
			    S.TASKKY  AS TASKKY,  
			    S.TASKIT  AS TASKIT  
			FROM TASDH  
	  INNER JOIN TASDI S  
	          ON TASDH.TASKKY = S.TASKKY  
       LEFT JOIN ( 
				    SELECT L.LOCAKY, Z.SHORTX  
				      FROM ZONMA Z  
			    INNER JOIN LOCMA L  
				        ON L.WAREKY = Z.WAREKY AND L.TKZONE = Z.ZONEKY 
				) LM  
              ON LM.LOCAKY = S.LOCASR  
      INNER JOIN SKUMA SM  
              ON SM.OWNRKY = S.OWNRKY AND SM.SKUKEY = S.SKUKEY  
       LEFT JOIN ( 
			    SELECT DISTINCT SHPOKY
			         , SHPOIT
			         , ARRIVA
			         , CARDAT
			         , CARNUM
			         , SHIPSQ
			         , SORTSQ
			         , DRIVER
			         , RECAYN
			         , TASKKY  
			      FROM SHPDR   
			     WHERE RECAYN = 'N'   
			       AND TASKKY != ' '  
			       AND CARNUM != ' ' 
			    )  SR  
               ON SR.SHPOKY = S.SHPOKY AND SR.SHPOIT = S.SHPOIT                
        LEFT JOIN SHPDI  
               ON SHPDI.SHPOKY = S.SHPOKY AND SHPDI.SHPOIT = S.SHPOIT  
        LEFT JOIN SHPDH 
               ON SHPDH.SHPOKY = S.SHPOKY  
            WHERE 1=1  
			  AND SR.TASKKY != ' '   
		      AND  S.LOCASR != 'DOCLOC'  
			  AND  SHPDH.DRELIN = 'V'  
              AND (  (  ( TASDH.DOCDAT = '20240321' )  )  AND (  ( SR.CARDAT = '20240322' )  )  AND (  ( SR.SHIPSQ = '101' )  OR  ( SR.SHIPSQ = '102' )  )  AND (  ( TASDH.TASOTY = '210' )  OR  ( TASDH.TASOTY = '208' )  )  )   
			  AND SDIFKY = NVL(' ', ' ')  
			  AND SDIFIT = NVL(' ', ' ')  
			  AND LOCASR = '1J01101'  
			  AND S.SKUKEY = '103634'  
			  AND S.WORKNM||SR.CARNUM||S.SDIFKY||SR.SHIPSQ||SR.CARDAT = '제주하치장C002 10220240322'  
			  AND TASDH.DOCDAT > TO_CHAR(SYSDATE - 60, 'YYYYMMDD')  
			  AND SHPDH.DOCDAT > TO_CHAR(SYSDATE - 60, 'YYYYMMDD')  
         GROUP BY S.WORKNM||SR.CARNUM||S.SDIFKY||SR.SHIPSQ,  
		          S.LOCASR,   
		          SDIFKY,  
		          SDIFIT,  
		          S.SKUKEY,  
		          NVL(SM.QTYSTD,0),  
		          NVL(SM.QTDUOM,0),  
		          NVL(SM.GRSWGT,0),  
		          SM.QTYSTD,  
		          SM.QTDUOM,  
		          SM.GRSWGT,  
		          LM.SHORTX,  
		          SM.DESC01,  
		          SM.DESC02,  
		          S.TASKKY,  
		          S.TASKIT  
	    ORDER BY S.SKUKEY