PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)|
--------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 20026 | 4928K| | 68615 (30)|
| 1 | SORT GROUP BY | | 20026 | 4928K| 10M| 28563 (0)|
|* 2 | FILTER | | | | | |
| 3 | NESTED LOOPS | | 20026 | 4928K| | 27812 (0)|
| 4 | NESTED LOOPS | | 20026 | 4498K| | 23807 (0)|
| 5 | NESTED LOOPS OUTER | | 20026 | 4224K| | 19802 (0)|
| 6 | NESTED LOOPS OUTER | | 20026 | 3911K| | 15797 (0)|
| 7 | NESTED LOOPS | | 20026 | 2151K| | 15796 (0)|
|* 8 | HASH JOIN | | 20026 | 1310K| | 11791 (0)|
| 9 | INDEX FULL SCAN | T_FEE_TYPE_IDX_003 | 106 | 636 | | 1 (0)|
|* 10 | HASH JOIN | | 20026 | 1192K| | 11789 (0)|
| 11 | TABLE ACCESS FULL | T_PAY_MODE | 25 | 525 | | 2 (0)|
|* 12 | TABLE ACCESS BY INDEX ROWID| T_POLICY_FEE | 20026 | 782K| | 11786 (0)|
|* 13 | INDEX RANGE SCAN | IDX_POLICY_FEE__RECEIV_STATUS | 1243K| | | 10188 (0)|
| 14 | TABLE ACCESS BY INDEX ROWID | T_CONTRACT_MASTER | 1 | 43 | | 2 (50)|
|* 15 | INDEX UNIQUE SCAN | PK_T_CONTRACT_MASTER | 1 | | | 1 (0)|
| 16 | TABLE ACCESS BY INDEX ROWID | T_COMPANY_CUSTOMER | 1 | 90 | | 2 (50)|
|* 17 | INDEX UNIQUE SCAN | PK_T_COMPANY_CUSTOMER | 1 | | | |
| 18 | TABLE ACCESS BY INDEX ROWID | T_CUSTOMER | 1 | 16 | | 2 (50)|
|* 19 | INDEX UNIQUE SCAN | PK_T_CUSTOMER | 1 | | | 1 (0)|
| 20 | TABLE ACCESS BY INDEX ROWID | T_POLICY_CHANGE | 1 | 14 | | 2 (50)|
|* 21 | INDEX UNIQUE SCAN | PK_T_POLICY_CHANGE | 1 | | | 1 (0)|
| 22 | TABLE ACCESS BY INDEX ROWID | T_CONTRACT_MASTER | 1 | 22 | | 2 (50)|
|* 23 | INDEX UNIQUE SCAN | PK_T_CONTRACT_MASTER | 1 | | | 1 (0)|
|* 24 | FILTER | | | | | |
|* 25 | CONNECT BY WITH FILTER