PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------
Plan hash value: 2802302807

--------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 18 | 3942 | 96005 (1)| 00:19:13 |
| 1 | SORT ORDER BY | | 18 | 3942 | 96005 (1)| 00:19:13 |
|* 2 | HASH JOIN | | 18 | 3942 | 96004 (1)| 00:19:13 |
|* 3 | HASH JOIN | | 19 | 1976 | 8035 (1)| 00:01:37 |
| 4 | NESTED LOOPS | | 2 | 124 | 858 (1)| 00:00:11 |
| 5 | NESTED LOOPS | | 3 | 124 | 858 (1)| 00:00:11 |
|* 6 | HASH JOIN | | 3 | 117 | 855 (1)| 00:00:11 |
|* 7 | TABLE ACCESS FULL | CUSTOMER | 1 | 24 | 205 (1)| 00:00:03 |
| 8 | TABLE ACCESS FULL | ACCOUNT | 173K| 2545K| 650 (1)| 00:00:08 |
|* 9 | INDEX UNIQUE SCAN | SYS_C0021222 | 1 | | 0 (0)| 00:00:01 |
|* 10 | TABLE ACCESS BY INDEX ROWID| INSU_SLIP | 1 | 23 | 1 (0)| 00:00:01 |
| 11 | TABLE ACCESS FULL | INSU_ACCOUNT_CHANGE_DETAIL | 1840K| 73M| 7172 (1)| 00:01:27 |
| 12 | TABLE ACCESS FULL | BUSI_TRANS | 1746K| 191M| 87965 (1)| 00:17:36 |
--------------------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

2 - access("ACCCHANGE"."CHANGED_CHANGECODE"="TRANS"."TRANS_ACCCHANGECODE")
3 - access("ACC"."ID"="ACCCHANGE"."CHANGED_ACCOUNT_ID")
6 - access("CUSTOMER"."ID"="ACC"."CUSTOMER_ID")
7 - filter("CUSTOMER"."CERTIFICATE"='433022197502160526')
9 - access("ACC"."SLIP_ID"="SLIP"."SLIP_ID")
10 - filter("SLIP"."SLIP_CODE"='190G171EH64001E' OR "SLIP"."SLIP_CODE"='190G171EH64001E-202007' OR
"SLIP"."SLIP_CODE"='190G171EH64001F' OR "SLIP"."SLIP_CODE"='190G171EH64001F2021' OR
"SLIP"."SLIP_CODE"='2020430102DDD400348771' OR "SLIP"."SLIP_CODE"='2020430102DDD400348772' OR
"SLIP"."SLIP_CODE"='GSGWHNS20210101' OR "SLIP"."SLIP_CODE"='ZGRSGWHN2020010701' OR
"SLIP"."SLIP_CODE"='ZGRSGWHN2020010702' OR "SLIP"."SLIP_CODE"='ZGRSGWHN2020010703' OR
"SLIP"."SLIP_CODE"='ZGRSGWHN2020010704' OR "SLIP"."SLIP_CODE"='ZGRSGWHN2020010705' OR
"SLIP"."SLIP_CODE"='ZGRSGWHN2020010706' OR "SLIP"."SLIP_CODE"='ZGRSGWHN2020010707' OR
"SLIP"."SLIP_CODE"='ZGRSGWHN2020010708' OR "SLIP"."SLIP_CODE"='ZGRSGWHN2020010709' OR
"SLIP"."SLIP_CODE"='ZGRSGWHN2020010710' OR "SLIP"."SLIP_CODE"='ZGRSGWHN2020010711' OR
"SLIP"."SLIP_CODE"='ZGRSGWHN2020010712' OR "SLIP"."SLIP_CODE"='ZGRSGWHN2020010713' OR
"SLIP"."SLIP_CODE"='ZGRSGWHN2020010714' OR "SLIP"."SLIP_CODE"='ZGRSGWHN2020010715' OR
"SLIP"."SLIP_CODE"='ZGRSGWHN2020010716' OR "SLIP"."SLIP_CODE"='ZGRSGWHN2020010717' OR
"SLIP"."SLIP_CODE"='ZGRSGWHN2020010718' OR "SLIP"."SLIP_CODE"='ZGRSGWHN2020010719' OR
"SLIP"."SLIP_CODE"='ZGRSGWHN2020010720' OR "SLIP"."SLIP_CODE"='ZGRSGWHN2020010721' OR
"SLIP"."SLIP_CODE"='ZGRSGWHN2020010722' OR "SLIP"."SLIP_CODE"='ZGRSGWHN2020010723' OR
"SLIP"."SLIP_CODE"='ZGRSGWHN2020010724')