+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Query Plan | +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | =============================================================== | | |ID|OPERATOR |NAME |EST.ROWS|EST.TIME(us)| | | --------------------------------------------------------------- | | |0 |HASH JOIN | |3408806 |9253025 | | | |1 |├─HASH JOIN | |521486 |498811 | | | |2 |│ ├─TABLE FULL SCAN |PC |165 |31 | | | |3 |│ └─TABLE FULL SCAN |O |521486 |330297 | | | |4 |└─PX COORDINATOR | |3302306 |7173248 | | | |5 | └─EXCHANGE OUT DISTR |:EX10000|3302306 |5010342 | | | |6 | └─PX PARTITION ITERATOR| |3302306 |151290 | | | |7 | └─TABLE FULL SCAN |CI(tt) |3302306 |151290 | | | =============================================================== | | Outputs & filters: | | ------------------------------------- | | 0 - output([O.CRDT_CONTRACT_NO], [O.CUSTOMER_NO], [O.CUSTOMER_NM], [O.PROD_NO], [O.OCCR_TYPE_CD], [O.BUSI_CCY_CD], [O.CONTRACT_AMT], [O.CONTRACT_BAL], | | [O.OVERDUE_AMT], [O.FIX_RATE], [O.EXE_RATE], [O.START_DT], [O.MAT_DT], [O.BFCHG_MAJOR_GATMHD_CD], [O.RISK_CLASSIFY_CD], [O.OPTR_NO], [O.HNDL_ORG_NO], [O.HNDL_DT], | | [O.AFRNWL_CONTRACT_EPDAY], [CI.DCMTP_CD], [CI.DOCUMENT_NO]), filter(nil), rowset=256 | | equal_conds([O.CUSTOMER_NO = cast(CI.CUSTOMER_NO, VARCHAR(1048576))]), other_conds(nil) | | 1 - output([O.CRDT_CONTRACT_NO], [O.CUSTOMER_NO], [O.CUSTOMER_NM], [O.PROD_NO], [O.OCCR_TYPE_CD], [O.BUSI_CCY_CD], [O.CONTRACT_AMT], [O.CONTRACT_BAL], | | [O.OVERDUE_AMT], [O.FIX_RATE], [O.EXE_RATE], [O.START_DT], [O.MAT_DT], [O.BFCHG_MAJOR_GATMHD_CD], [O.RISK_CLASSIFY_CD], [O.OPTR_NO], [O.HNDL_ORG_NO], [O.HNDL_DT], | | [O.AFRNWL_CONTRACT_EPDAY]), filter(nil), rowset=256 | | equal_conds([O.PROD_NO = PC.PROD_NO]), other_conds(nil) | | 2 - output([PC.PROD_NO]), filter([PC.ONBS_OFBS_IND = cast('01', VARCHAR(1048576))]), rowset=256 | | access([PC.PROD_NO], [PC.ONBS_OFBS_IND]), partitions(p0) | | is_index_back=false, is_global_index=false, filter_before_indexback[false], | | range_key([PC.PROD_NO]), range(MIN ; MAX)always true | | 3 - output([O.CRDT_CONTRACT_NO], [O.CUSTOMER_NO], [O.PROD_NO], [O.OPTR_NO], [O.HNDL_ORG_NO], [O.CUSTOMER_NM], [O.OCCR_TYPE_CD], [O.BUSI_CCY_CD], [O.CONTRACT_AMT], | | [O.CONTRACT_BAL], [O.OVERDUE_AMT], [O.FIX_RATE], [O.EXE_RATE], [O.START_DT], [O.MAT_DT], [O.BFCHG_MAJOR_GATMHD_CD], [O.RISK_CLASSIFY_CD], [O.HNDL_DT], | | [O.AFRNWL_CONTRACT_EPDAY]), filter([O.CONTRACT_STATUS IN (cast('320', VARCHAR(1048576)), cast('380', VARCHAR(1048576)))], [O.HNDL_ORG_NO = cast('0011', | | VARCHAR(1048576))], [O.OPTR_NO = cast('3954', VARCHAR(1048576))]), rowset=256 | | access([O.CRDT_CONTRACT_NO], [O.CUSTOMER_NO], [O.PROD_NO], [O.CONTRACT_STATUS], [O.OPTR_NO], [O.HNDL_ORG_NO], [O.CUSTOMER_NM], [O.OCCR_TYPE_CD], [O.BUSI_CCY_CD], | | [O.CONTRACT_AMT], [O.CONTRACT_BAL], [O.OVERDUE_AMT], [O.FIX_RATE], [O.EXE_RATE], [O.START_DT], [O.MAT_DT], [O.BFCHG_MAJOR_GATMHD_CD], [O.RISK_CLASSIFY_CD], | | [O.HNDL_DT], [O.AFRNWL_CONTRACT_EPDAY]), partitions(p0) | | is_index_back=false, is_global_index=false, filter_before_indexback[false,false,false], | | range_key([O.CRDT_CONTRACT_NO]), range(MIN ; MAX)always true | | 4 - output([CI.DCMTP_CD], [CI.DOCUMENT_NO], [CI.CUSTOMER_NO]), filter(nil), rowset=256 | | 5 - output([CI.DCMTP_CD], [CI.DOCUMENT_NO], [CI.CUSTOMER_NO]), filter(nil), rowset=256 | | dop=1 | | 6 - output([CI.CUSTOMER_NO], [CI.DCMTP_CD], [CI.DOCUMENT_NO]), filter(nil), rowset=256 | | force partition granule | | 7 - output([CI.CUSTOMER_NO], [CI.DCMTP_CD], [CI.DOCUMENT_NO]), filter(nil), rowset=256 | | access([CI.CUSTOMER_NO], [CI.DCMTP_CD], [CI.DOCUMENT_NO]), partitions(p[0-255]) | | is_index_back=false, is_global_index=false, | | range_key([CI.CUSTOMER_NO], [CI.DCMTP_CD], [CI.DOCUMENT_NO]), range(MIN,MIN,MIN ; MAX,MAX,MAX)always true | +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 44 rows in set (0.011 sec)