|* 9 | HASH JOIN | | 400K| 39M| 27M| 26943 (0)|
|* 10 | HASH JOIN | | 400K| 23M| | 16111 (0)|
| 11 | TABLE ACCESS FULL | T_PAY_MODE | 25 | 525 | | 2 (0)|
|* 12 | TABLE ACCESS FULL | T_POLICY_FEE | 400K| 15M| | 16107 (0)|
| 13 | TABLE ACCESS FULL | T_CONTRACT_MASTER | 1136K| 46M| | 9437 (0)|
| 14 | VIEW | index_join_007 | 2028K| 30M| | |
|* 15 | HASH JOIN | | 400K| 45M| 44M| 32315 (1)|
| 16 | INDEX FAST FULL SCAN | PK_T_CUSTOMER | 2028K| 30M| | 548 (0)|
| 17 | INDEX FAST FULL SCAN | IDX_CUSTOMER__BIR_REAL_GEN | 2028K| 30M| | 548 (0)|
| 18 | VIEW | VW_NSO_1 | 7 | 42 | | |
|* 19 | CONNECT BY WITH FILTERING | | | | | |
| 20 | NESTED LOOPS | | | | | |
|* 21 | INDEX UNIQUE SCAN | PK_T_COMPANY_ORGAN | 1 | 6 | | |
| 22 | TABLE ACCESS BY USER ROWID| T_COMPANY_ORGAN | | | | |
| 23 | NESTED LOOPS | | | | | |
| 24 | BUFFER SORT | | 7 | 70 | | |
| 25 | CONNECT BY PUMP | | | | | |
|* 26 | INDEX RANGE SCAN | T_COMPANY_ORGAN_IDX_002 | 7 | 70 | | 1 (0)|
| 27 | TABLE ACCESS BY INDEX ROWID | T_POLICY_CHANGE | 1 | 14 | | 2 (50)|
|* 28 | INDEX UNIQUE SCAN | PK_T_POLICY_CHANGE | 1 | | | 1 (0)|
| 29 | INDEX FAST FULL SCAN | IDX1_ACCEPT_DATE | 1136K| 23M| | 899 (0)|
| 30 | TABLE ACCESS BY INDEX ROWID | T_COMPANY_CUSTOMER | 1 | 90 | | 2 (50)|
|* 31 | INDEX UNIQUE SCAN | PK_T_COMPANY_CUSTOMER | 1 | | | |
----------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
2 - access("TPF"."FEE_TYPE"="C"."TYPE_ID")
5 - access("TCM"."POLICY_ID"="TPC"."POLICY_ID")
7 - access("TPF"."ORGAN_ID"="VW_NSO_1"."$nso_col_1")
8 - access("D"."APPLICANT_ID"="F"."CUSTOMER_ID"(+))
9 - access("TPF"."POLICY_ID"="D"."POLICY_ID")
10 - access("TPF"."PAY_MODE"="G"."MODE_ID")
12 - filter("TPF"."CHANGE_ID" IS NOT NULL AND TO_NUMBER("TPF"."RECEIV_STATUS")=1 AND "TPF"."FEE_STATUS"=1 AND
"TPF"."P