질문있습니다.
오라클에서 쓰는것처럼 select 나 update , insert 할때 parallel 쿼리를 만들 수 있나요?
다음 쿼리를 쓰고 있는데요.
이걸 alti에서도 그대로 쓸 수 있는 지 알려 주시면 좋겠습니다.
SELECT DECODE(GID,31,'GDS_FND_CD',47,'STMT_TYP_CD',55,'SVNG_CCD',59,'TLZTN_TYP_CD',61,'TXTN_CCD',62,'THS_CMPNY_MKTO_B_F'),
DECODE(GID,31,GDS_FND_CD,47,STMT_TYP_CD,55,SVNG_CCD,59,TLZTN_TYP_CD,61,TXTN_CCD,62,THS_CMPNY_MKTO_B_F),
CNT
FROM (
SELECT /*+ FULL(SWW01B) PARALLEL (SWW01B, 16) */
GROUPING_ID(GDS_FND_CD,STMT_TYP_CD,SVNG_CCD,TLZTN_TYP_CD,TXTN_CCD,THS_CMPNY_MKTO_B_F) GID,
GDS_FND_CD,STMT_TYP_CD,SVNG_CCD,TLZTN_TYP_CD,TXTN_CCD,THS_CMPNY_MKTO_B_F,
COUNT(*) CNT
FROM TAB_A1001
WHERE DL_DT > '20061231' AND DL_DT <= '#END_DATE$'
GROUP BY CUBE(GDS_FND_CD,STMT_TYP_CD,SVNG_CCD,TLZTN_TYP_CD,TXTN_CCD,THS_CMPNY_MKTO_B_F)
HAVING GROUPING_ID(GDS_FND_CD,STMT_TYP_CD,SVNG_CCD,TLZTN_TYP_CD,TXTN_CCD,THS_CMPNY_MKTO_B_F)
IN (31,47,55,59,61,62))
ORDER BY 1,2 |