17,075
社区成员
发帖
与我相关
我的任务
分享
SELECT
cli_id,
co_id,
rel_sys_id,
rel_sys_ref_id,
rel_typ_cd,
MAX(INSERTDATE) INSERTDATE
FROM KPIODS.ODS_TRL_ING B
WHERE B.INSERTDATE < DATE'2012-8-7'
AND cli_id || co_id || rel_sys_id || rel_sys_ref_id || rel_typ_cd IN
(SELECT cli_id || co_id || rel_sys_id || rel_sys_ref_id ||
rel_typ_cd
FROM KPIODS.ODS_TRL_ING B
WHERE B.INSERTDATE >=DATE'2012-8-7'
and B.INSERTDATE <= DATE'2012-8-8')
GROUP BY cli_id, co_id, rel_sys_id, rel_sys_ref_id, rel_typ_cd
SELECT STATEMENT, GOAL = ALL_ROWS 6633362 339223431 28494768204 575484025529 6607856
HASH GROUP BY 6633362 339223431 28494768204 575484025529 6607856 34307646000
HASH JOIN 14752 339223431 28494768204 37019067111 13111
TABLE ACCESS BY INDEX ROWID KPIODS ODS_TRL_ING 66 4596 193032 2778275 66
INDEX RANGE SCAN KPIODS IDX_TRL_INSERTDATE 15 4525 1012022 15
TABLE ACCESS FULL KPIODS ODS_TRL_ING 13182 7381513 310023546 3081974783 13045
SELECT
cli_id,
co_id,
rel_sys_id,
rel_sys_ref_id,
rel_typ_cd,
MAX(INSERTDATE) INSERTDATE
FROM KPIODS.ODS_TRL_ING B
WHERE B.INSERTDATE < DATE'2012-8-7'
AND cli_id /*|| co_id || rel_sys_id || rel_sys_ref_id || rel_typ_cd*/ IN
(SELECT cli_id || co_id || rel_sys_id || rel_sys_ref_id ||
rel_typ_cd
FROM KPIODS.ODS_TRL_ING B
WHERE B.INSERTDATE >=DATE'2012-8-7'
and B.INSERTDATE <= DATE'2012-8-8')
GROUP BY cli_id, co_id, rel_sys_id, rel_sys_ref_id, rel_typ_cd
SELECT STATEMENT, GOAL = ALL_ROWS 14472 60920 5117280 3920002183 14298
HASH GROUP BY 14472 60920 5117280 3920002183 14298 6177000
HASH JOIN 13281 60920 5117280 3834875311 13111
TABLE ACCESS BY INDEX ROWID KPIODS ODS_TRL_ING 66 4596 193032 2778275 66
INDEX RANGE SCAN KPIODS IDX_TRL_INSERTDATE 15 4525 1012022 15
TABLE ACCESS FULL KPIODS ODS_TRL_ING 13182 7381513 310023546 3081974783 13045
SELECT STATEMENT, GOAL = ALL_ROWS 13282 4596 386064 3859957675 13111
HASH GROUP BY 13282 4596 386064 3859957675 13111
HASH JOIN 13281 4596 386064 3834875311 13111
TABLE ACCESS BY INDEX ROWID KPIODS ODS_TRL_ING 66 4596 193032 2778275 66
INDEX RANGE SCAN KPIODS IDX_TRL_INSERTDATE 15 4525 1012022 15
TABLE ACCESS FULL KPIODS ODS_TRL_ING 13182 7381513 310023546 3081974783 13045
SELECT CLI_ID,
CO_ID,
REL_SYS_ID,
REL_SYS_REF_ID,
REL_TYP_CD,
MAX(INSERTDATE) INSERTDATE
FROM KPIODS.ODS_TRL_ING B
WHERE B.INSERTDATE < DATE '2012-8-7'
AND (CLI_ID, CO_ID, REL_SYS_ID, REL_SYS_REF_ID, REL_TYP_CD) IN
(SELECT CLI_ID, CO_ID, REL_SYS_ID, REL_SYS_REF_ID, REL_TYP_CD
FROM KPIODS.ODS_TRL_ING B
WHERE B.INSERTDATE >= DATE '2012-8-7'
AND B.INSERTDATE <= DATE '2012-8-8')
GROUP BY CLI_ID, CO_ID, REL_SYS_ID, REL_SYS_REF_ID, REL_TYP_CD