查询SQL：

SELECT TRANS_DATETIME as transDatetime, TRANS_CODE as transCode, TRANS_MERCHANTNAME as transMerchantName, TRANS_AMT as transAmount, TRANS_TYPE as transType FROM CORE_SCHEMA.BUSI_TRANS trans LEFT JOIN CORE_SCHEMA.INSU_ACCOUNT_CHANGE_DETAIL accChange ON accChange.CHANGED_CHANGECODE = trans.TRANS_ACCCHANGECODE LEFT JOIN CORE_SCHEMA.ACCOUNT acc ON acc."ID" = accChange.CHANGED_ACCOUNT_ID LEFT JOIN CORE_SCHEMA.CUSTOMER customer ON customer."ID" = acc.CUSTOMER_ID LEFT JOIN CORE_SCHEMA.INSU_SLIP slip ON acc.SLIP_ID = slip.SLIP_ID WHERE slip.SLIP_CODE in ('ZGRSGWHN2020010701','ZGRSGWHN2020010702', 'ZGRSGWHN2020010703', 'ZGRSGWHN2020010704', 'ZGRSGWHN2020010705', 'ZGRSGWHN2020010706', 'ZGRSGWHN2020010707', 'ZGRSGWHN2020010708', 'ZGRSGWHN2020010709', 'ZGRSGWHN2020010710', 'ZGRSGWHN2020010711', 'ZGRSGWHN2020010712', 'ZGRSGWHN2020010713', 'ZGRSGWHN2020010714', 'ZGRSGWHN2020010715', 'ZGRSGWHN2020010716', 'ZGRSGWHN2020010717', 'ZGRSGWHN2020010718', 'ZGRSGWHN2020010719', 'ZGRSGWHN2020010720', 'ZGRSGWHN2020010721', 'ZGRSGWHN2020010722', 'ZGRSGWHN2020010723', 'ZGRSGWHN2020010724', '190G171EH64001F', '190G171EH64001E', '190G171EH64001E-202007', '2020430102DDD400348772', '2020430102DDD400348771', '190G171EH64001F2021', 'GSGWHNS20210101') and customer.CERTIFICATE = '433022197502160526' ORDER BY TRANS_DATETIME DESC;

执行计划：

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')