谓词推入的优化案例"/>
谓词推入的优化案例
案例很简单,主要就是长……
Sql文本:
select count(*)from VIEW_SB_UUUUUUUUUUUUUUUUUwhere 1 = 1and (KKKKID in (SELECT orgnoFROM PP_OOOWHERE PARENTORGNO = '1100000784'or orgno = '1100000784'));原耗时、执行计划及资源消耗:
Elapsed: 00:00:45.71Execution Plan
----------------------------------------------------------
Plan hash value: 3484991639-----------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time |
-----------------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 29 | | 169K (1)| 00:33:50 |
| 1 | SORT AGGREGATE | | 1 | 29 | | | |
|* 2 | HASH JOIN | | 141K| 3996K| | 169K (1)| 00:33:50 |
| 3 | TABLE ACCESS BY INDEX ROWID | PP_OOO | 5 | 110 | | 3 (0)| 00:00:01 |
| 4 | BITMAP CONVERSION TO ROWIDS | | | | | | |
| 5 | BITMAP OR | | | | | | |
| 6 | BITMAP CONVERSION FROM ROWIDS | | | | | | |
|* 7 | INDEX RANGE SCAN | IND_PPPPP_PGO | | | | 1 (0)| 00:00:01 |
| 8 | BITMAP CONVERSION FROM ROWIDS | | | | | | |
|* 9 | INDEX RANGE SCAN | PK_PPPPP_KEY | | | | 1 (0)| 00:00:01 |
| 10 | VIEW | VIEW_SB_UUUUUUUUUUUUUUUUU | 141K| 965K| | 169K (1)| 00:33:50 |
| 11 | UNION-ALL | | | | | | |
| 12 | VIEW | | 1194 | 8358 | | 17116 (1)| 00:03:26 |
| 13 | UNION-ALL | | | | | | |
| 14 | NESTED LOOPS OUTER | | 1193 | 270K| | 17115 (1)| 00:03:26 |
| 15 | VIEW | | 1193 | 242K| | 14728 (1)| 00:02:57 |
| 16 | UNION-ALL | | | | | | |
| 17 | HASH UNIQUE | | 281 | 42150 | | 6186 (1)| 00:01:15 |
| 18 | NESTED LOOPS OUTER | | 281 | 42150 | | 6185 (1)| 00:01:15 |
|* 19 | TABLE ACCESS FULL | SB_SSSSSSS | 281 | 34001 | | 6184 (1)| 00:01:15 |
| 20 | TABLE ACCESS BY INDEX ROWID | SB_SSSSSSS_SBXX | 1 | 29 | | 1 (0)| 00:00:01 |
|* 21 | INDEX RANGE SCAN | INX_SSSRRRRXXXXRNO | 1 | | | 0 (0)| 00:00:01 |
| 22 | HASH UNIQUE | | 24 | 3720 | | 425 (1)| 00:00:06 |
| 23 | NESTED LOOPS OUTER | | 24 | 3720 | | 424 (1)| 00:00:06 |
|* 24 | TABLE ACCESS FULL | SB_CKKKKKK_JNSR | 23 | 2898 | | 378 (1)| 00:00:05 |
| 25 | TABLE ACCESS BY INDEX ROWID | SB_CKKKKKK_JN_HXXX | 1 | 29 | | 2 (0)| 00:00:01 |
|* 26 | INDEX RANGE SCAN | INX_CKKKKKKJNHXXXR | 1 | | | 1 (0)| 00:00:01 |
| 27 | HASH UNIQUE | | 228 | 40128 | | 2643 (1)| 00:00:32 |
| 28 | NESTED LOOPS OUTER | | 228 | 40128 | | 2642 (1)| 00:00:32 |
| 29 | NESTED LOOPS OUTER | | 228 | 33516 | | 2641 (1)| 00:00:32 |
|* 30 | TABLE ACCESS FULL | SB_JWWWW | 228 | 26904 | | 2640 (1)| 00:00:32 |
| 31 | TABLE ACCESS BY INDEX ROWID | SB_JWWWW_HXXX | 1 | 29 | | 1 (0)| 00:00:01 |
|* 32 | INDEX RANGE SCAN | INX_JWWWWQSHXXXRNO | 1 | | | 0 (0)| 00:00:01 |
| 33 | TABLE ACCESS BY INDEX ROWID | SB_JWWWW_SBXX | 1 | 29 | | 1 (0)| 00:00:01 |
|* 34 | INDEX RANGE SCAN | INX_JWWWWQSSBXXRNO | 1 | | | 0 (0)| 00:00:01 |
| 35 | HASH UNIQUE | | 63 | 9702 | | 963 (1)| 00:00:12 |
| 36 | NESTED LOOPS OUTER | | 63 | 9702 | | 962 (1)| 00:00:12 |
|* 37 | TABLE ACCESS FULL | SB_JNNNN | 63 | 7875 | | 961 (1)| 00:00:12 |
| 38 | TABLE ACCESS BY INDEX ROWID | SB_JNNNN_HXXX | 1 | 29 | | 1 (0)| 00:00:01 |
|* 39 | INDEX RANGE SCAN | INX_JNNNNQSHXXXRNO | 1 | | | 0 (0)| 00:00:01 |
| 40 | HASH UNIQUE | | 97 | 17751 | | 896 (1)| 00:00:11 |
| 41 | NESTED LOOPS OUTER | | 97 | 17751 | | 895 (1)| 00:00:11 |
| 42 | NESTED LOOPS OUTER | | 97 | 14938 | | 894 (1)| 00:00:11 |
|* 43 | TABLE ACCESS FULL | SB_DDDDDDTTS | 97 | 12125 | | 893 (1)| 00:00:11 |
| 44 | TABLE ACCESS BY INDEX ROWID | SB_DWWWWWTZS_HXXX | 1 | 29 | | 1 (0)| 00:00:01 |
|* 45 | INDEX RANGE SCAN | INX_DWWWWWWWWWWWNO | 1 | | | 0 (0)| 00:00:01 |
| 46 | TABLE ACCESS BY INDEX ROWID | SB_DWWWWWTZS_SBXX | 1 | 29 | | 1 (0)| 00:00:01 |
|* 47 | INDEX RANGE SCAN | INX_DWDDDDDDDDDDNO | 1 | | | 0 (0)| 00:00:01 |
| 48 | HASH UNIQUE | | 7 | 1078 | | 105 (1)| 00:00:02 |
| 49 | NESTED LOOPS OUTER | | 7 | 1078 | | 104 (0)| 00:00:02 |
|* 50 | TABLE ACCESS FULL | SB_JNFFFFFFS | 7 | 875 | | 103 (0)| 00:00:02 |
| 51 | TABLE ACCESS BY INDEX ROWID | SB_DDDDDDTZS_HXXX | 1 | 29 | | 1 (0)| 00:00:01 |
|* 52 | INDEX RANGE SCAN | INX_DNNNNNNNNNNNNO | 1 | | | 0 (0)| 00:00:01 |
| 53 | HASH UNIQUE | | 234 | 35334 | | 3058 (1)| 00:00:37 |
| 54 | NESTED LOOPS OUTER | | 234 | 35334 | | 3057 (1)| 00:00:37 |
|* 55 | TABLE ACCESS FULL | SB_ZZZZ | 234 | 28548 | | 3056 (1)| 00:00:37 |
| 56 | TABLE ACCESS BY INDEX ROWID | SB_ZZZZ_GLXX | 1 | 29 | | 1 (0)| 00:00:01 |
|* 57 | INDEX RANGE SCAN | PK_SB_ZZZZ_GLXX_RPTNO | 1 | | | 0 (0)| 00:00:01 |
| 58 | HASH UNIQUE | | 259 | 39627 | | 450 (1)| 00:00:06 |
| 59 | NESTED LOOPS OUTER | | 259 | 39627 | | 449 (1)| 00:00:06 |
|* 60 | TABLE ACCESS FULL | SB_ZHHH | 259 | 32116 | | 448 (1)| 00:00:06 |
| 61 | TABLE ACCESS BY INDEX ROWID | SB_ZHHH_GLXX | 1 | 29 | | 1 (0)| 00:00:01 |
|* 62 | INDEX RANGE SCAN | PK_SB_ZHHH_GLXX_RPTNO | 1 | | | 0 (0)| 00:00:01 |
| 63 | TABLE ACCESS BY INDEX ROWID | BU_TTTTTTTTTTTINFO | 1 | 24 | | 2 (0)| 00:00:01 |
|* 64 | INDEX UNIQUE SCAN | PK_BRRRRRRRRD_KEY | 1 | | | 1 (0)| 00:00:01 |
| 65 | HASH UNIQUE | | 1 | 128 | | 1 (100)| 00:00:01 |
|* 66 | FILTER | | | | | | |
| 67 | NESTED LOOPS OUTER | | 809 | 101K| | 57694 (1)| 00:11:33 |
|* 68 | HASH JOIN ANTI | | 809 | 78473 | 7272K| 56960 (1)| 00:11:24 |
|* 69 | TABLE ACCESS FULL | BU_TTTTTTTTTTTINFO | 80863 | 6317K| | 40037 (1)| 00:08:01 |
| 70 | VIEW | | 1398K| 22M| | 14639 (1)| 00:02:56 |
| 71 | UNION-ALL | | | | | | |
| 72 | TABLE ACCESS FULL | SB_SSSSSSS | 607K| 9M| | 6174 (1)| 00:01:15 |
| 73 | TABLE ACCESS FULL | SB_CKKKKKK_JNSR | 35512 | 589K| | 378 (1)| 00:00:05 |
| 74 | TABLE ACCESS FULL | SB_JWWWW | 261K| 4348K| | 2635 (1)| 00:00:32 |
| 75 | TABLE ACCESS FULL | SB_JNNNN | 64426 | 1069K| | 960 (1)| 00:00:12 |
| 76 | TABLE ACCESS FULL | SB_DDDDDDTTS | 76194 | 1264K| | 892 (1)| 00:00:11 |
| 77 | TABLE ACCESS FULL | SB_JNFFFFFFS | 4688 | 79696 | | 103 (0)| 00:00:02 |
| 78 | TABLE ACCESS FULL | SB_ZZZZ | 304K| 5055K| | 3051 (1)| 00:00:37 |
| 79 | TABLE ACCESS FULL | SB_ZHHH | 43465 | 721K| | 447 (1)| 00:00:06 |
| 80 | TABLE ACCESS BY INDEX ROWID | PA_CCCC | 1 | 31 | | 1 (0)| 00:00:01 |
|* 81 | INDEX UNIQUE SCAN | PK_PACCCC_KEY | 1 | | | 0 (0)| 00:00:01 |
| 82 | VIEW | | 69988 | 478K| | 55844 (1)| 00:11:11 |
| 83 | UNION-ALL | | | | | | |
|* 84 | HASH JOIN OUTER | | 69987 | 15M| 14M| 55843 (1)| 00:11:11 |
| 85 | VIEW | | 69987 | 13M| | 17027 (1)| 00:03:25 |
| 86 | UNION-ALL | | | | | | |
| 87 | HASH UNIQUE | | 30366 | 4448K| 4968K| 7218 (1)| 00:01:27 |
|* 88 | FILTER | | | | | | |
| 89 | NESTED LOOPS OUTER | | 30366 | 4448K| | 6210 (1)| 00:01:15 |
|* 90 | TABLE ACCESS FULL | SB_SSSSSSS | 30366 | 3588K| | 6208 (1)| 00:01:15 |
| 91 | TABLE ACCESS BY INDEX ROWID | SB_SSSSSSS_SBXX | 1 | 29 | | 1 (0)| 00:00:01 |
|* 92 | INDEX RANGE SCAN | INX_SSSRRRRXXXXRNO | 1 | | | 0 (0)| 00:00:01 |
| 93 | HASH UNIQUE | | 1861 | 281K| | 640 (2)| 00:00:08 |
|* 94 | FILTER | | | | | | |
|* 95 | HASH JOIN OUTER | | 1861 | 281K| | 639 (1)| 00:00:08 |
|* 96 | TABLE ACCESS FULL | SB_CKKKKKK_JNSR | 1776 | 218K| | 380 (2)| 00:00:05 |
| 97 | TABLE ACCESS FULL | SB_CKKKKKK_JN_HXXX | 34954 | 989K| | 258 (1)| 00:00:04 |
| 98 | HASH UNIQUE | | 13095 | 2250K| 2448K| 3165 (1)| 00:00:38 |
|* 99 | FILTER | | | | | | |
|*100 | HASH JOIN RIGHT OUTER | | 13095 | 2250K| | 2657 (1)| 00:00:32 |
| 101 | TABLE ACCESS FULL | SB_JWWWW_SBXX | 123 | 3567 | | 3 (0)| 00:00:01 |
|*102 | HASH JOIN RIGHT OUTER | | 13095 | 1879K| | 2654 (1)| 00:00:32 |
| 103 | TABLE ACCESS FULL | SB_JWWWW_HXXX | 123 | 3567 | | 3 (0)| 00:00:01 |
|*104 | TABLE ACCESS FULL | SB_JWWWW | 13095 | 1508K| | 2650 (1)| 00:00:32 |
| 105 | HASH UNIQUE | | 3221 | 484K| | 966 (1)| 00:00:12 |
|*106 | FILTER | | | | | | |
| 107 | NESTED LOOPS OUTER | | 3221 | 484K| | 965 (1)| 00:00:12 |
|*108 | TABLE ACCESS FULL | SB_JNNNN | 3221 | 393K| | 964 (1)| 00:00:12 |
| 109 | TABLE ACCESS BY INDEX ROWID | SB_JNNNN_HXXX | 1 | 29 | | 1 (0)| 00:00:01 |
|*110 | INDEX RANGE SCAN | INX_JNNNNQSHXXXRNO | 1 | | | 0 (0)| 00:00:01 |
| 111 | HASH UNIQUE | | 3810 | 680K| | 900 (2)| 00:00:11 |
|*112 | FILTER | | | | | | |
| 113 | NESTED LOOPS OUTER | | 3810 | 680K| | 898 (1)| 00:00:11 |
| 114 | NESTED LOOPS OUTER | | 3810 | 572K| | 897 (1)| 00:00:11 |
|*115 | TABLE ACCESS FULL | SB_DDDDDDTTS | 3810 | 465K| | 896 (1)| 00:00:11 |
| 116 | TABLE ACCESS BY INDEX ROWID | SB_DWWWWWTZS_HXXX | 1 | 29 | | 1 (0)| 00:00:01 |
|*117 | INDEX RANGE SCAN | INX_DWWWWWWWWWWWNO | 1 | | | 0 (0)| 00:00:01 |
| 118 | TABLE ACCESS BY INDEX ROWID | SB_DWWWWWTZS_SBXX | 1 | 29 | | 1 (0)| 00:00:01 |
|*119 | INDEX RANGE SCAN | INX_DWDDDDDDDDDDNO | 1 | | | 0 (0)| 00:00:01 |
| 120 | HASH UNIQUE | | 234 | 36036 | | 106 (2)| 00:00:02 |
|*121 | FILTER | | | | | | |
| 122 | NESTED LOOPS OUTER | | 234 | 36036 | | 105 (1)| 00:00:02 |
|*123 | TABLE ACCESS FULL | SB_JNFFFFFFS | 234 | 29250 | | 104 (1)| 00:00:02 |
| 124 | TABLE ACCESS BY INDEX ROWID | SB_DDDDDDTZS_HXXX | 1 | 29 | | 1 (0)| 00:00:01 |
|*125 | INDEX RANGE SCAN | INX_DNNNNNNNNNNNNO | 1 | | | 0 (0)| 00:00:01 |
| 126 | HASH UNIQUE | | 15227 | 2245K| 2496K| 3582 (1)| 00:00:43 |
|*127 | FILTER | | | | | | |
| 128 | NESTED LOOPS OUTER | | 15227 | 2245K| | 3070 (1)| 00:00:37 |
|*129 | TABLE ACCESS FULL | SB_ZZZZ | 15227 | 1814K| | 3068 (1)| 00:00:37 |
| 130 | TABLE ACCESS BY INDEX ROWID | SB_ZZZZ_GLXX | 1 | 29 | | 1 (0)| 00:00:01 |
|*131 | INDEX RANGE SCAN | PK_SB_ZZZZ_GLXX_RPTNO | 1 | | | 0 (0)| 00:00:01 |
| 132 | HASH UNIQUE | | 2173 | 324K| | 451 (2)| 00:00:06 |
|*133 | FILTER | | | | | | |
| 134 | NESTED LOOPS OUTER | | 2173 | 324K| | 450 (1)| 00:00:06 |
|*135 | TABLE ACCESS FULL | SB_ZHHH | 2173 | 263K| | 449 (1)| 00:00:06 |
| 136 | TABLE ACCESS BY INDEX ROWID | SB_ZHHH_GLXX | 1 | 29 | | 1 (0)| 00:00:01 |
|*137 | INDEX RANGE SCAN | PK_SB_ZHHH_GLXX_RPTNO | 1 | | | 0 (0)| 00:00:01 |
| 138 | VIEW | index$_join$_096 | 3018K| 69M| | 32919 (1)| 00:06:36 |
|*139 | HASH JOIN | | | | | | |
| 140 | INDEX FAST FULL SCAN | IDX_BU_TTTTTTTTTTTINFO_TDNOFI | 3018K| 69M| | 14661 (1)| 00:02:56 |
| 141 | INDEX FAST FULL SCAN | PK_BRRRRRRRRD_KEY | 3018K| 69M| | 14293 (1)| 00:02:52 |
| 142 | HASH UNIQUE | | 1 | 128 | | 1 (100)| 00:00:01 |
|*143 | FILTER | | | | | | |
| 144 | NESTED LOOPS OUTER | | 809 | 101K| | 57694 (1)| 00:11:33 |
|*145 | HASH JOIN ANTI | | 809 | 78473 | 7272K| 56960 (1)| 00:11:24 |
|*146 | TABLE ACCESS FULL | BU_TTTTTTTTTTTINFO | 80863 | 6317K| | 40037 (1)| 00:08:01 |
| 147 | VIEW | | 1398K| 22M| | 14639 (1)| 00:02:56 |
| 148 | UNION-ALL | | | | | | |
| 149 | TABLE ACCESS FULL | SB_SSSSSSS | 607K| 9M| | 6174 (1)| 00:01:15 |
| 150 | TABLE ACCESS FULL | SB_CKKKKKK_JNSR | 35512 | 589K| | 378 (1)| 00:00:05 |
| 151 | TABLE ACCESS FULL | SB_JWWWW | 261K| 4348K| | 2635 (1)| 00:00:32 |
| 152 | TABLE ACCESS FULL | SB_JNNNN | 64426 | 1069K| | 960 (1)| 00:00:12 |
| 153 | TABLE ACCESS FULL | SB_DDDDDDTTS | 76194 | 1264K| | 892 (1)| 00:00:11 |
| 154 | TABLE ACCESS FULL | SB_JNFFFFFFS | 4688 | 79696 | | 103 (0)| 00:00:02 |
| 155 | TABLE ACCESS FULL | SB_ZZZZ | 304K| 5055K| | 3051 (1)| 00:00:37 |
| 156 | TABLE ACCESS FULL | SB_ZHHH | 43465 | 721K| | 447 (1)| 00:00:06 |
| 157 | TABLE ACCESS BY INDEX ROWID | PA_CCCC | 1 | 31 | | 1 (0)| 00:00:01 |
|*158 | INDEX UNIQUE SCAN | PK_PACCCC_KEY | 1 | | | 0 (0)| 00:00:01 |
|*159 | HASH JOIN RIGHT SEMI | | 69994 | 3144K| | 96157 (1)| 00:19:14 |
|*160 | TABLE ACCESS FULL | SB_DEEEEEEERR | 7205 | 182K| | 139 (1)| 00:00:02 |
| 161 | VIEW | | 69994 | 1367K| | 96017 (1)| 00:19:13 |
| 162 | UNION-ALL | | | | | | |
|*163 | HASH JOIN OUTER | | 69987 | 15M| 14M| 55843 (1)| 00:11:11 |
|*164 | VIEW | | 69987 | 13M| | 17027 (1)| 00:03:25 |
| 165 | UNION-ALL | | | | | | |
| 166 | HASH UNIQUE | | 30366 | 4448K| 4968K| 7218 (1)| 00:01:27 |
|*167 | FILTER | | | | | | |
| 168 | NESTED LOOPS OUTER | | 30366 | 4448K| | 6210 (1)| 00:01:15 |
|*169 | TABLE ACCESS FULL | SB_SSSSSSS | 30366 | 3588K| | 6208 (1)| 00:01:15 |
| 170 | TABLE ACCESS BY INDEX ROWID | SB_SSSSSSS_SBXX | 1 | 29 | | 1 (0)| 00:00:01 |
|*171 | INDEX RANGE SCAN | INX_SSSRRRRXXXXRNO | 1 | | | 0 (0)| 00:00:01 |
| 172 | HASH UNIQUE | | 1861 | 281K| | 640 (2)| 00:00:08 |
|*173 | FILTER | | | | | | |
|*174 | HASH JOIN OUTER | | 1861 | 281K| | 639 (1)| 00:00:08 |
|*175 | TABLE ACCESS FULL | SB_CKKKKKK_JNSR | 1776 | 218K| | 380 (2)| 00:00:05 |
| 176 | TABLE ACCESS FULL | SB_CKKKKKK_JN_HXXX | 34954 | 989K| | 258 (1)| 00:00:04 |
| 177 | HASH UNIQUE | | 13095 | 2250K| 2448K| 3165 (1)| 00:00:38 |
|*178 | FILTER | | | | | | |
|*179 | HASH JOIN RIGHT OUTER | | 13095 | 2250K| | 2657 (1)| 00:00:32 |
| 180 | TABLE ACCESS FULL | SB_JWWWW_SBXX | 123 | 3567 | | 3 (0)| 00:00:01 |
|*181 | HASH JOIN RIGHT OUTER | | 13095 | 1879K| | 2654 (1)| 00:00:32 |
| 182 | TABLE ACCESS FULL | SB_JWWWW_HXXX | 123 | 3567 | | 3 (0)| 00:00:01 |
|*183 | TABLE ACCESS FULL | SB_JWWWW | 13095 | 1508K| | 2650 (1)| 00:00:32 |
| 184 | HASH UNIQUE | | 3221 | 484K| | 966 (1)| 00:00:12 |
|*185 | FILTER | | | | | | |
| 186 | NESTED LOOPS OUTER | | 3221 | 484K| | 965 (1)| 00:00:12 |
|*187 | TABLE ACCESS FULL | SB_JNNNN | 3221 | 393K| | 964 (1)| 00:00:12 |
| 188 | TABLE ACCESS BY INDEX ROWID | SB_JNNNN_HXXX | 1 | 29 | | 1 (0)| 00:00:01 |
|*189 | INDEX RANGE SCAN | INX_JNNNNQSHXXXRNO | 1 | | | 0 (0)| 00:00:01 |
| 190 | HASH UNIQUE | | 3810 | 680K| | 900 (2)| 00:00:11 |
|*191 | FILTER | | | | | | |
| 192 | NESTED LOOPS OUTER | | 3810 | 680K| | 898 (1)| 00:00:11 |
| 193 | NESTED LOOPS OUTER | | 3810 | 572K| | 897 (1)| 00:00:11 |
|*194 | TABLE ACCESS FULL | SB_DDDDDDTTS | 3810 | 465K| | 896 (1)| 00:00:11 |
| 195 | TABLE ACCESS BY INDEX ROWID| SB_DWWWWWTZS_HXXX | 1 | 29 | | 1 (0)| 00:00:01 |
|*196 | INDEX RANGE SCAN | INX_DWWWWWWWWWWWNO | 1 | | | 0 (0)| 00:00:01 |
| 197 | TABLE ACCESS BY INDEX ROWID | SB_DWWWWWTZS_SBXX | 1 | 29 | | 1 (0)| 00:00:01 |
|*198 | INDEX RANGE SCAN | INX_DWDDDDDDDDDDNO | 1 | | | 0 (0)| 00:00:01 |
| 199 | HASH UNIQUE | | 234 | 36036 | | 106 (2)| 00:00:02 |
|*200 | FILTER | | | | | | |
| 201 | NESTED LOOPS OUTER | | 234 | 36036 | | 105 (1)| 00:00:02 |
|*202 | TABLE ACCESS FULL | SB_JNFFFFFFS | 234 | 29250 | | 104 (1)| 00:00:02 |
| 203 | TABLE ACCESS BY INDEX ROWID | SB_DDDDDDTZS_HXXX | 1 | 29 | | 1 (0)| 00:00:01 |
|*204 | INDEX RANGE SCAN | INX_DNNNNNNNNNNNNO | 1 | | | 0 (0)| 00:00:01 |
| 205 | HASH UNIQUE | | 15227 | 2245K| 2496K| 3582 (1)| 00:00:43 |
|*206 | FILTER | | | | | | |
| 207 | NESTED LOOPS OUTER | | 15227 | 2245K| | 3070 (1)| 00:00:37 |
|*208 | TABLE ACCESS FULL | SB_ZZZZ | 15227 | 1814K| | 3068 (1)| 00:00:37 |
| 209 | TABLE ACCESS BY INDEX ROWID | SB_ZZZZ_GLXX | 1 | 29 | | 1 (0)| 00:00:01 |
|*210 | INDEX RANGE SCAN | PK_SB_ZZZZ_GLXX_RPTNO | 1 | | | 0 (0)| 00:00:01 |
| 211 | HASH UNIQUE | | 2173 | 324K| | 451 (2)| 00:00:06 |
|*212 | FILTER | | | | | | |
| 213 | NESTED LOOPS OUTER | | 2173 | 324K| | 450 (1)| 00:00:06 |
|*214 | TABLE ACCESS FULL | SB_ZHHH | 2173 | 263K| | 449 (1)| 00:00:06 |
| 215 | TABLE ACCESS BY INDEX ROWID | SB_ZHHH_GLXX | 1 | 29 | | 1 (0)| 00:00:01 |
|*216 | INDEX RANGE SCAN | PK_SB_ZHHH_GLXX_RPTNO | 1 | | | 0 (0)| 00:00:01 |
| 217 | VIEW | index$_join$_155 | 3018K| 69M| | 32919 (1)| 00:06:36 |
|*218 | HASH JOIN | | | | | | |
| 219 | INDEX FAST FULL SCAN | IDX_BU_TTTTTTTTTTTINFO_TDNOFI | 3018K| 69M| | 14661 (1)| 00:02:56 |
| 220 | INDEX FAST FULL SCAN | PK_BRRRRRRRRD_KEY | 3018K| 69M| | 14293 (1)| 00:02:52 |
| 221 | HASH UNIQUE | | 7 | 896 | | 40175 (1)| 00:08:03 |
| 222 | NESTED LOOPS OUTER | | 7 | 896 | | 40174 (1)| 00:08:03 |
| 223 | NESTED LOOPS ANTI | | 7 | 679 | | 40167 (1)| 00:08:03 |
|*224 | TABLE ACCESS FULL | BU_TTTTTTTTTTTINFO | 8 | 640 | | 40055 (1)| 00:08:01 |
| 225 | VIEW | | 2 | 34 | | 14 (0)| 00:00:01 |
| 226 | UNION ALL PUSHED PREDICATE | | | | | | |
|*227 | INDEX RANGE SCAN | INX_SSSRSSD_TID | 1 | 17 | | 3 (0)| 00:00:01 |
|*228 | INDEX RANGE SCAN | INX_CKSHHHHHHJNTID | 1 | 17 | | 1 (0)| 00:00:01 |
|*229 | INDEX RANGE SCAN | INX_JWWWWQSTID | 1 | 17 | | 3 (0)| 00:00:01 |
|*230 | INDEX RANGE SCAN | INX_JNNNNQSTID | 1 | 17 | | 1 (0)| 00:00:01 |
|*231 | INDEX RANGE SCAN | INX_DWWWWWTZSTID | 1 | 17 | | 1 (0)| 00:00:01 |
|*232 | INDEX RANGE SCAN | INX_JNFFFFFFSTID | 1 | 17 | | 1 (0)| 00:00:01 |
|*233 | INDEX RANGE SCAN | IDX_SB_ZZZZ_RWIDH | 1 | 17 | | 3 (0)| 00:00:01 |
|*234 | INDEX RANGE SCAN | IDX_SB_ZHHH_RWIDH | 1 | 17 | | 1 (0)| 00:00:01 |
| 235 | TABLE ACCESS BY INDEX ROWID | PA_CCCC | 1 | 31 | | 1 (0)| 00:00:01 |
|*236 | INDEX UNIQUE SCAN | PK_PACCCC_KEY | 1 | | | 0 (0)| 00:00:01 |
-----------------------------------------------------------------------------------------------------------------------------------Predicate Information (identified by operation id):
---------------------------------------------------2 - access("KKKKID"="ORGNO")7 - access("PARENTORGNO"='1100000784')9 - access("ORGNO"='1100000784')19 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND "T2"."SFZX"='Y' AND"T2"."SXBZ"='1')21 - access("T2"."RPTNO"="T3"."RPTNO"(+))24 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND "T2"."SFZX"='Y' AND"T2"."SXBZ"='1')26 - access("T2"."RPTNO"="T3"."RPTNO"(+))30 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND "T2"."SFZX"='Y' AND"T2"."SXBZ"='1')32 - access("T2"."RPTNO"="T3"."RPTNO"(+))34 - access("T2"."RPTNO"="T4"."RPTNO"(+))37 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND "T2"."SFZX"='Y' AND"T2"."SXBZ"='1')39 - access("T2"."RPTNO"="T3"."RPTNO"(+))43 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND "T2"."SFZX"='Y' AND"T2"."SXBZ"='1')45 - access("T2"."RPTNO"="T4"."RPTNO"(+))47 - access("T2"."RPTNO"="T3"."RPTNO"(+))50 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND "T2"."SFZX"='Y' AND"T2"."SXBZ"='1')52 - access("T2"."RPTNO"="T3"."RPTNO"(+))55 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND "T2"."SFZX"='Y' AND"T2"."SXBZ"='1')57 - access("T2"."RPTNO"="T3"."RPTNO"(+))60 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND "T2"."SXBZ"='1' AND"T2"."SFZX"='Y')62 - access("T2"."RPTNO"="T3"."RPTNO"(+))64 - access("TB"."TXNSERIALNO"="T1"."TXNSERIALNO"(+))66 - filter(NULL IS NOT NULL AND NULL IS NOT NULL AND NULL IS NOT NULL)68 - access("T1"."TXNSERIALNO"="B"."RWIDH")69 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T1"."INTERETDATE"),1)>SYSDATE@! AND ("T1"."TRADENO"='010001' OR"T1"."TRADENO"='010002' OR "T1"."TRADENO"='010003' OR "T1"."TRADENO"='010004' OR "T1"."TRADENO"='010011' OR"T1"."TRADENO"='020043' OR "T1"."TRADENO"='020088' OR "T1"."TRADENO"='030004' OR "T1"."TRADENO"='030219' OR"T1"."TRADENO"='030220' OR "T1"."TRADENO"='030221' OR "T1"."TRADENO"='030222' OR "T1"."TRADENO"='030223' OR"T1"."TRADENO"='030904' OR "T1"."TRADENO"='030908' OR "T1"."TRADENO"='080103' OR "T1"."TRADENO"='080104' OR"T1"."TRADENO"='080108' OR "T1"."TRADENO"='080202' OR "T1"."TRADENO"='080205' OR "T1"."TRADENO"='080206') AND"T1"."TRANSTATE"='4')81 - access("T1"."CCCCNO"="T2"."CCCCNO"(+))84 - access("TB"."TXNSERIALNO"="T1"."TXNSERIALNO"(+))88 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T3"."SFYSB" IS NOT NULL THEN"T3"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END ='0' AND CASE WHEN"T3"."SFZX" IS NOT NULL THEN "T3"."SFZX" ELSE '*' END ='Y')90 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)92 - access("T2"."RPTNO"="T3"."RPTNO"(+))94 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T3"."SFYSB" IS NOT NULL THEN"T3"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END ='0' AND CASE WHEN"T3"."SFZX" IS NOT NULL THEN "T3"."SFZX" ELSE '*' END ='Y')95 - access("T2"."RPTNO"="T3"."RPTNO"(+))96 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)99 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T4"."SFYSB" IS NOT NULL THEN"T4"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T4"."SXBZ" IS NOT NULL THEN "T4"."SXBZ" ELSE '*' END ='0' AND CASE WHEN"T4"."SFZX" IS NOT NULL THEN "T4"."SFZX" ELSE '*' END ='Y' OR CASE WHEN "T3"."SFYSB" IS NOT NULL THEN "T3"."SFYSB" ELSE'*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END ='0' AND CASE WHEN "T3"."SFZX" IS NOTNULL THEN "T3"."SFZX" ELSE '*' END ='Y')100 - access("T2"."RPTNO"="T4"."RPTNO"(+))102 - access("T2"."RPTNO"="T3"."RPTNO"(+))104 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)106 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T3"."SFYSB" IS NOT NULL THEN"T3"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END ='0' AND CASE WHEN"T3"."SFZX" IS NOT NULL THEN "T3"."SFZX" ELSE '*' END ='Y')108 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)110 - access("T2"."RPTNO"="T3"."RPTNO"(+))112 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T3"."SFYSB" IS NOT NULL THEN"T3"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END ='0' AND CASE WHEN"T3"."SFZX" IS NOT NULL THEN "T3"."SFZX" ELSE '*' END ='Y' OR CASE WHEN "T4"."SFYSB" IS NOT NULL THEN "T4"."SFYSB" ELSE'*' END ='N' AND CASE WHEN "T4"."SXBZ" IS NOT NULL THEN "T4"."SXBZ" ELSE '*' END ='0' AND CASE WHEN "T4"."SFZX" IS NOTNULL THEN "T4"."SFZX" ELSE '*' END ='Y')115 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)117 - access("T2"."RPTNO"="T4"."RPTNO"(+))119 - access("T2"."RPTNO"="T3"."RPTNO"(+))121 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T3"."SFYSB" IS NOT NULL THEN"T3"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END ='0' AND CASE WHEN"T3"."SFZX" IS NOT NULL THEN "T3"."SFZX" ELSE '*' END ='Y')123 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)125 - access("T2"."RPTNO"="T3"."RPTNO"(+))127 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T3"."SFYSB" IS NOT NULL THEN"T3"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END ='0' AND CASE WHEN"T3"."SFZX" IS NOT NULL THEN "T3"."SFZX" ELSE '*' END ='Y')129 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)131 - access("T2"."RPTNO"="T3"."RPTNO"(+))133 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T3"."SFYSB" IS NOT NULL THEN"T3"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END ='0' AND CASE WHEN"T3"."SFZX" IS NOT NULL THEN "T3"."SFZX" ELSE '*' END ='Y')135 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)137 - access("T2"."RPTNO"="T3"."RPTNO"(+))139 - access(ROWID=ROWID)143 - filter(NULL IS NOT NULL AND NULL IS NOT NULL AND NULL IS NOT NULL)145 - access("T1"."TXNSERIALNO"="B"."RWIDH")146 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T1"."INTERETDATE"),1)>SYSDATE@! AND ("T1"."TRADENO"='010001' OR"T1"."TRADENO"='010002' OR "T1"."TRADENO"='010003' OR "T1"."TRADENO"='010004' OR "T1"."TRADENO"='010011' OR"T1"."TRADENO"='020043' OR "T1"."TRADENO"='020088' OR "T1"."TRADENO"='030004' OR "T1"."TRADENO"='030219' OR"T1"."TRADENO"='030220' OR "T1"."TRADENO"='030221' OR "T1"."TRADENO"='030222' OR "T1"."TRADENO"='030223' OR"T1"."TRADENO"='030904' OR "T1"."TRADENO"='030908' OR "T1"."TRADENO"='080103' OR "T1"."TRADENO"='080104' OR"T1"."TRADENO"='080108' OR "T1"."TRADENO"='080202' OR "T1"."TRADENO"='080205' OR "T1"."TRADENO"='080206') AND"T1"."TRANSTATE"='4')158 - access("T1"."CCCCNO"="T2"."CCCCNO"(+))159 - access("OT1"."RPTNO"="RPTNO")160 - filter("STATE"='0')163 - access("TB"."TXNSERIALNO"="T1"."TXNSERIALNO"(+))164 - filter(CASE WHEN ("TB"."QTYPE"='1' AND "TB"."CUSTYPE"='D' ANDROUND("F_EXCHANGERATEUSD_NEW"(TO_DATE('20'||SUBSTR("TB"."RPTNO",13,6),'yyyy-MM-dd'),"TB"."CURSIGN","TB"."AMOUNT"),2)<=5000)THEN "TB"."JCSFYSB"||"TB"."JCSXBZ"||"TB"."JCSFZX"||"TB"."SBSFYSB"||"TB"."SBSXBZ"||"TB"."SBSFZX"||"TB"."HXSFYSB"||"TB"."HXSXBZ"||"TB"."HXSFZX" ELSE 'Y1Y******' END ='Y1Y******' AND CASE WHEN ("TB"."QTYPE"='4' AND "TB"."CUSTYPE"='D' ANDROUND("F_EXCHANGERATEUSD_NEW"(TO_DATE('20'||SUBSTR("TB"."RPTNO",13,6),'yyyy-MM-dd'),"TB"."CURSIGN","TB"."AMOUNT"),2)<=5000)THEN "TB"."JCSFYSB"||"TB"."JCSXBZ"||"TB"."JCSFZX"||"TB"."SBSFYSB"||"TB"."SBSXBZ"||"TB"."SBSFZX"||"TB"."HXSFYSB"||"TB"."HXSXBZ"||"TB"."HXSFZX" ELSE 'Y1Y******' END ='Y1Y******')167 - filter(CASE WHEN '4'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN"T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||'*'||'*' ELSE 'Y1YYYYY'END ='Y1YYYYY' AND CASE WHEN '4'='2' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL)THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN "T3"."SXBZ" ELSE '*' END ||CASE WHEN("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||'*' ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '4'='3' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||'*'||'*' ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '4'='4'THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASEWHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||'*'||'*' ELSE 'Y1YYY**' END ='Y1YYY**' AND CASE WHEN'4'='5' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN "T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN"T3"."SFZX" ELSE '*' END ||'*'||'*' ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '4'='6' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN("T3"."SXBZ" IS NOT NULL) THEN "T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*'END ||'*'||'*' ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '4'='7' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASEWHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN "T3"."SXBZ"ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||'*'||'*' ELSE 'Y1Y***YY' END='Y1Y***YY' AND CASE WHEN '4'='8' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN"T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN "T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX"IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||'*'||'*' ELSE 'Y1Y***YY' END ='Y1Y***YY')169 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)171 - access("T2"."RPTNO"="T3"."RPTNO"(+))173 - filter(CASE WHEN '6'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOTNULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY'END ='Y1YYYYY' AND CASE WHEN '6'='2' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFZX"IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '6'='3' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '6'='4'THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*'END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYY**' END ='Y1YYY**' AND CASE WHEN'6'='5' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN"T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END='Y1Y***YY' AND CASE WHEN '6'='6' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" ISNOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '6'='7' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*'END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '6'='8' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*'END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY')174 - access("T2"."RPTNO"="T3"."RPTNO"(+))175 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)178 - filter(CASE WHEN '1'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN"T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END ||CASE WHEN ("T3"."SFYSB"IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '1'='2' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T4"."SFYSB" ISNOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SXBZ" IS NOT NULL) THEN "T4"."SXBZ" ELSE '*' END ||CASE WHEN("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*'END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '1'='3' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*'END ||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN"T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '1'='4' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END ||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*'END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYY**' END ='Y1YYY**' AND CASE WHEN'1'='5' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END||CASE WHEN ("T4"."SXBZ" IS NOT NULL) THEN "T4"."SXBZ" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN"T4"."SFZX" ELSE '*' END ||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX"IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '1'='6' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN("T4"."SXBZ" IS NOT NULL) THEN "T4"."SXBZ" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*'END ||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN"T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '1'='7' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN("T4"."SXBZ" IS NOT NULL) THEN "T4"."SXBZ" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*'END ||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN"T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '1'='8' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN("T4"."SXBZ" IS NOT NULL) THEN "T4"."SXBZ" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*'END ||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN"T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY')179 - access("T2"."RPTNO"="T4"."RPTNO"(+))181 - access("T2"."RPTNO"="T3"."RPTNO"(+))183 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)185 - filter(CASE WHEN '5'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOTNULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY'END ='Y1YYYYY' AND CASE WHEN '5'='2' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFZX"IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '5'='3' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '5'='4'THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*'END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYY**' END ='Y1YYY**' AND CASE WHEN'5'='5' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN"T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END='Y1Y***YY' AND CASE WHEN '5'='6' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" ISNOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '5'='7' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*'END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '5'='8' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*'END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY')187 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)189 - access("T2"."RPTNO"="T3"."RPTNO"(+))191 - filter(CASE WHEN '3'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN"T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||CASE WHEN ("T4"."SFYSB"IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END ELSE'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '3'='2' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" ISNOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN "T3"."SXBZ" ELSE '*' END ||CASE WHEN("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*'END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '3'='3' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*'END ||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN"T4"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '3'='4' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*'END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END ELSE 'Y1YYY**' END ='Y1YYY**' AND CASE WHEN'3'='5' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN "T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN"T3"."SFZX" ELSE '*' END ||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SFZX"IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '3'='6' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN("T3"."SXBZ" IS NOT NULL) THEN "T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*'END ||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN"T4"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '3'='7' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN("T3"."SXBZ" IS NOT NULL) THEN "T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*'END ||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN"T4"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '3'='8' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN("T3"."SXBZ" IS NOT NULL) THEN "T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*'END ||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN"T4"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY')194 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)196 - access("T2"."RPTNO"="T4"."RPTNO"(+))198 - access("T2"."RPTNO"="T3"."RPTNO"(+))200 - filter(CASE WHEN '2'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOTNULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY'END ='Y1YYYYY' AND CASE WHEN '2'='2' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFZX"IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '2'='3' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '2'='4'THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*'END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYY**' END ='Y1YYY**' AND CASE WHEN'2'='5' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN"T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END='Y1Y***YY' AND CASE WHEN '2'='6' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" ISNOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '2'='7' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*'END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '2'='8' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*'END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY')202 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)204 - access("T2"."RPTNO"="T3"."RPTNO"(+))206 - filter(CASE WHEN '7'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOTNULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY'END ='Y1YYYYY' AND CASE WHEN '7'='2' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFZX"IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '7'='3' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '7'='4'THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*'END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYY**' END ='Y1YYY**' AND CASE WHEN'7'='5' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN"T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END='Y1Y***YY' AND CASE WHEN '7'='6' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" ISNOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '7'='7' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*'END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '7'='8' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*'END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY')208 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)210 - access("T2"."RPTNO"="T3"."RPTNO"(+))212 - filter(CASE WHEN '8'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOTNULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY'END ='Y1YYYYY' AND CASE WHEN '8'='2' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFZX"IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '8'='3' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '8'='4'THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*'END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYY**' END ='Y1YYY**' AND CASE WHEN'8'='5' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN"T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END='Y1Y***YY' AND CASE WHEN '8'='6' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" ISNOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '8'='7' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*'END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '8'='8' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*'END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY')214 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)216 - access("T2"."RPTNO"="T3"."RPTNO"(+))218 - access(ROWID=ROWID)224 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T1"."INTERETDATE"),1)>SYSDATE@! AND ("T1"."TRADENO"='010001' OR"T1"."TRADENO"='010002' OR "T1"."TRADENO"='010003' OR "T1"."TRADENO"='010004' OR "T1"."TRADENO"='010011' OR"T1"."TRADENO"='020043' OR "T1"."TRADENO"='020088' OR "T1"."TRADENO"='030004' OR "T1"."TRADENO"='030219' OR"T1"."TRADENO"='030220' OR "T1"."TRADENO"='030221' OR "T1"."TRADENO"='030222' OR "T1"."TRADENO"='030223' OR"T1"."TRADENO"='030904' OR "T1"."TRADENO"='030908' OR "T1"."TRADENO"='080103' OR "T1"."TRADENO"='080104' OR"T1"."TRADENO"='080108' OR "T1"."TRADENO"='080202' OR "T1"."TRADENO"='080205' OR "T1"."TRADENO"='080206') AND"T1"."TRANSTATE"='4' AND CASE WHEN (''='1' AND ''='D' AND ROUND("F_EXCHANGERATEUSD_NEW"(TO_DATE('20','yyyy-MM-dd'),"T1"."CURSIGN","T1"."AMOUNT"),2)<=5000) THEN '*********' ELSE 'Y1Y******' END ='Y1Y******' AND CASE WHEN (''='4' AND ''='D' ANDROUND("F_EXCHANGERATEUSD_NEW"(TO_DATE('20','yyyy-MM-dd'),"T1"."CURSIGN","T1"."AMOUNT"),2)<=5000) THEN '*********' ELSE'Y1Y******' END ='Y1Y******')227 - access("TT"."RWIDH"="T1"."TXNSERIALNO")228 - access("T3"."RWIDH"="T1"."TXNSERIALNO")229 - access("T4"."RWIDH"="T1"."TXNSERIALNO")230 - access("T5"."RWIDH"="T1"."TXNSERIALNO")231 - access("T6"."RWIDH"="T1"."TXNSERIALNO")232 - access("T7"."RWIDH"="T1"."TXNSERIALNO")233 - access("T8"."RWIDH"="T1"."TXNSERIALNO")234 - access("T9"."RWIDH"="T1"."TXNSERIALNO")236 - access("T1"."CCCCNO"="T2"."CCCCNO"(+))Statistics
----------------------------------------------------------229 recursive calls28 db block gets354584 consistent gets271906 physical reads0 redo size525 bytes sent via SQL*Net to client520 bytes received via SQL*Net from client2 SQL*Net roundtrips to/from client0 sorts (memory)0 sorts (disk)1 rows processed
视图源码如下:
CREATE OR REPLACE VIEW OWNERR.VIEW_SB_UUUUUUUUUUUUUUUUU AS
SELECT vb.transactorgno as KKKKID FROM sb_SSSSYYYY vb
WHERE 1=1
and (vb.jcsfysb='N' and vb.jcsxbz='1' and vb.jcsfzx='Y')
and add_months(vb.interetdate,1)>sysdate
union all
SELECT vb.transactorgno as KKKKID FROM sb_SSSSYYYY vb
WHERE 1=1
and ((vb.jcsfysb='N' and vb.jcsxbz='0' and vb.jcsfzx='Y') or (vb.sbsfysb='N' and vb.sbsxbz='0' and vb.sbsfzx='Y') or (vb.hxsfysb='N' and vb.hxsxbz='0' and vb.hxsfzx='Y'))
and add_months(vb.interetdate,1)>sysdate
union all
SELECT vb.transactorgno as KKKKID FROM sb_SSSSYYYY vb
WHERE 1=1
and vb.rptno in (select rptno from sb_DEEEEEEERR where state = '0')
and (case when qtype = '1' then jcsfysb||jcsxbz||jcsfzx||sbsfysb||sbsfzx||hxSFYSB||hxSFZX else 'Y1YYYYY' end ='Y1YYYYY'
and case when qtype = '1' and custype = 'D' and round(f_exchangerateusd_new(to_date('20' || substr(rptno, 13, 6), 'yyyy-MM-dd'), cursign, amount),2) <= 5000
then jcsfysb||jcsxbz||jcsfzx||sbsfysb||sbsxbz||sbsfzx||hxSFYSB||hxSXBZ||hxSFZX else 'Y1Y******' end ='Y1Y******'
and case when qtype = '2' then jcsfysb||jcsxbz||jcsfzx||sbsfysb||sbsxbz||sbsfzx||hxSFZX else 'Y1Y***YY' end ='Y1Y***YY'
and case when qtype = '3' then jcsfysb||jcsxbz||jcsfzx||sbsfysb||sbsfzx||hxSFYSB||hxSFZX else 'Y1YYYYY' end ='Y1YYYYY'
and case when qtype = '4' then jcsfysb||jcsxbz||jcsfzx||sbsfysb||sbsfzx||hxSFYSB||hxSFZX else 'Y1YYY**' end ='Y1YYY**'
and case when qtype = '4' and custype = 'D' and round(f_exchangerateusd_new(to_date('20' || substr(rptno, 13, 6), 'yyyy-MM-dd'), cursign, amount),2) <= 5000
then jcsfysb||jcsxbz||jcsfzx||sbsfysb||sbsxbz||sbsfzx||hxSFYSB||hxSXBZ||hxSFZX else 'Y1Y******' end ='Y1Y******'
and case when qtype = '5' then jcsfysb||jcsxbz||jcsfzx||sbsfysb||sbsxbz||sbsfzx||hxSFYSB||hxSFZX else 'Y1Y***YY' end ='Y1Y***YY'
and case when qtype = '6' then jcsfysb||jcsxbz||jcsfzx||sbsfysb||sbsxbz||sbsfzx||hxSFYSB||hxSFZX else 'Y1Y***YY' end ='Y1Y***YY'
and case when qtype = '7' then jcsfysb||jcsxbz||jcsfzx||sbsfysb||sbsxbz||sbsfzx||hxSFYSB||hxSFZX else 'Y1Y***YY' end ='Y1Y***YY'
and case when qtype = '8' then jcsfysb||jcsxbz||jcsfzx||sbsfysb||sbsxbz||sbsfzx||hxSFYSB||hxSFZX else 'Y1Y***YY' end ='Y1Y***YY')
and add_months(vb.interetdate,1)>sysdate;============================================================================================create or replace view OWNERR.sb_SSSSYYYY as
select ot1.txnserialNo,ot1.currentbizno,ot1.rptno,ot1.tradeno,ot1.cursign,ot1.amount,ot1.interetdate,ot1name,ot1.qtype,ot1.jcxx,ot1.hxxx,ot1.sbxx,ot1.transactorgno,ot1.launchmode,case ot1.tradeno when 'SGLR' then '手工录入' else ot2.tradename end tradeNameName,ot1.qtypename,'P' as NULLSTR,'0' as NULLNUM,ot1.jcsfysb,ot1.jcsxbz,ot1.jcsfzx,ot1.sbsfysb,ot1.sbsxbz,ot1.sbsfzx,ot1.hxSFYSB,ot1.hxSXBZ,ot1.hxSFZX,ot1.custypefrom (--------------------------业务申报--------------------------------------------------------------------------------select tb.txnserialno as txnserialNo,tb.ywbh as currentbizno,tb.rptno,tb.cursign as cursign,tb.amount as amount,tb.interetdate as interetdate,tb.jcxx as jcxx,tb.hxxx as hxxx,tb.sbxx as sbxx,tb.transactorgno as transactorgno,tb.launchmode as launchmode,tbname as cnname,tb.qtype as qtype,tb.qtypename as qtypename,case when t1.tradeno is null then 'SGLR' else t1.tradeno end tradeno,tb.sfzfsb,tb.custype,tb.jcsfysb,tb.jcsxbz,tb.jcsfzx,tb.sbsfysb,tb.sbsxbz,tb.sbsfzx,tb.hxSFYSB,tb.hxSXBZ,tb.hxSFZXfrom (--1.涉外收入申报单select distinct t2.rwidh as txnserialNo,t2.ywbh,t2.rptno,t2.txccy as cursign,t2.txamt as amount,t2.sjlrrq as interetdate,'Y' as jcxx,'' as hxxx,decode(t3.rptno, null, '', 'Y') as sbxx,t2.bank_id as transactorgno,t2.launchmode as launchmode,t2.custnm as cnname,'4' as qtype,'涉外收入' as qtypename,'' tradeno,decode(t2.launchmode, 'TP', 'Y', 'N') as sfzfsb,t2.custype,t2.sfysb jcsfysb,t2.sxbz jcsxbz,t2.sfzx jcsfzx,case when t3.sfysb is not null then t3.sfysb else '' end sbsfysb,case when t3.sxbz is not null then t3.sxbz else '' end sbsxbz,case when t3.sfzx is not null then t3.sfzx else '' end sbsfzx,'' hxSFYSB,'' hxSXBZ,'' hxSFZXfrom SB_SSSSSSS t2left join SB_SSSSSSS_sbxx t3 on t2.rptno = t3.rptnounion all--2.境内收入申报单select distinct t2.rwidh,t2.ywbh,t2.rptno,t2.txccy as cursign,t2.txamt as amount,t2.sjlrrq as interetdate,'Y' as jcxx,decode(t3.rptno, null, '', 'Y') as hxxx,'' as sbxx,t2.bank_id as transactorgno,t2.launchmode as launchmode,t2.custnm,'6' as qtype,'境内收入' as qtypename,'' tradeno,decode(t2.launchmode, 'TP', 'Y', 'N') as sfzfsb,t2.custype,t2.sfysb jcsfysb,t2.sxbz jcsxbz,t2.sfzx jcsfzx,'' sbsfysb,'' sbsxbz,'' sbsfzx,case when t3.sfysb is not null then t3.sfysb else '' end hxSFYSB,case when t3.sxbz is not null then t3.sxbz else '' end hxSXBZ,case when t3.sfzx is not null then t3.sfzx else '' end hxSFZXfrom sb_CKKKKKK_jnsr t2left join sb_CKKKKKK_jn_hxxx t3 on t2.rptno = t3.rptnounion all--3.境外汇款申请书select distinct t2.rwidh,t2.ywbh,t2.rptno,t2.txccy as cursign,t2.txamt as amount,t2.sjlrrq as interetdate,'Y' as jcxx,decode(t4.rptno, null, '', 'Y') as hxxx,decode(t3.rptno, null, '', 'Y') as sbxx,t2.bank_id as transactorgno,t2.launchmode as launchmode,t2.custnm,'1' as qtype,'境外汇款申请书' as qtypename,'' tradeno,decode(t2.launchmode, 'TP', 'Y', 'N') as sfzfsb,t2.custype,t2.sfysb jcsfysb,t2.sxbz jcsxbz,t2.sfzx jcsfzx,case when t4.sfysb is not null then t4.sfysb else '' end sbsfysb,case when t4.sxbz is not null then t4.sxbz else '' end sbsxbz,case when t4.sfzx is not null then t4.sfzx else '' end sbsfzx,case when t3.sfysb is not null then t3.sfysb else '' end hxsfysb,case when t3.sxbz is not null then t3.sxbz else '' end hxsxbz,case when t3.sfzx is not null then t3.sfzx else '' end hxsfzxfrom sb_JWWWW t2left join sb_JWWWW_hxxx t3 on t2.rptno = t3.rptnoleft join sb_JWWWW_sbxx t4 on t2.rptno = t4.rptnounion all--4.境内汇款申请书select distinct t2.rwidh,t2.ywbh,t2.rptno,t2.txccy as cursign,t2.txamt as amount,t2.sjlrrq as interetdate,'Y' as jcxx,decode(t3.rptno, null, '', 'Y') as hxxx,'' as sbxx,t2.bank_id as transactorgno,t2.launchmode as launchmode,t2.custnm,'5' as qtype,'境内汇款申请书' as qtypename,'' tradeno,decode(t2.launchmode, 'TP', 'Y', 'N') as sfzfsb,t2.custype,t2.sfysb jcsfysb,t2.sxbz jcsxbz,t2.sfzx jcsfzx,'' sbsfysb,'' sbsxbz,'' sbsfzx,case when t3.sfysb is not null then t3.sfysb else '' end hxSFYSB,case when t3.sxbz is not null then t3.sxbz else '' end hxSXBZ,case when t3.sfzx is not null then t3.sfzx else '' end hxSFZXfrom sb_JNNNN t2left join sb_JNNNN_hxxx t3 on t2.rptno = t3.rptnounion all--5.对外付款承兑通知书select distinct t2.rwidh,t2.ywbh,t2.rptno,t2.txccy as cursign,t2.txamt as amount,t2.sjlrrq as interetdate,'Y' as jcxx,decode(t4.rptno, null, '', 'Y') as hxxx,decode(t3.rptno, null, '', 'Y') as sbxx,t2.bank_id as transactorgno,t2.launchmode as launchmode,t2.custnm,'3' as qtype,'对外付款承兑书' as qtypename,'' tradeno,decode(t2.launchmode, 'TP', 'Y', 'N') as sfzfsb,t2.custype,t2.sfysb jcsfysb,t2.sxbz jcsxbz,t2.sfzx jcsfzx,case when t3.sfysb is not null then t3.sfysb else '' end sbsfysb,case when t3.sxbz is not null then t3.sxbz else '' end sbsxbz,case when t3.sfzx is not null then t3.sfzx else '' end sbsfzx,case when t4.sfysb is not null then t4.sfysb else '' end hxSFYSB,case when t4.sxbz is not null then t4.sxbz else '' end hxSXBZ,case when t4.sfzx is not null then t4.sfzx else '' end hxSFZXfrom sb_DDDDDDTTS t2left join sb_DWWWWWTZS_sbxx t3 on t2.rptno = t3.rptnoleft join Sb_DWWWWWTZS_hxxx t4 on t2.rptno = t4.rptnounion all--6.境内付款承兑通知书select distinct t2.rwidh,t2.ywbh,t2.rptno,t2.txccy as cursign,t2.txamt as amount,t2.sjlrrq as interetdate,'Y' as jcxx,decode(t3.rptno, null, '', 'Y') as hxxx,'' as sbxx,t2.bank_id as transactorgno,t2.launchmode as launchmode,t2.custnm,'2' as qtype,'境内付款承兑书' as qtypename,'' tradeno,decode(t2.launchmode, 'TP', 'Y', 'N') as sfzfsb,t2.custype,t2.sfysb jcsfysb,t2.sxbz jcsxbz,t2.sfzx jcsfzx,'' sbsfysb,'' sbsxbz,'' sbsfzx,case when t3.sfysb is not null then t3.sfysb else '' end hxSFYSB,case when t3.sxbz is not null then t3.sxbz else '' end hxSXBZ,case when t3.sfzx is not null then t3.sfzx else '' end hxSFZXfrom sb_JNFFFFFFS t2left join sb_DDDDDDTZS_hxxx t3 on t2.rptno = t3.rptnounion all--7.外汇账户内结汇select distinct t2.rwidh,t2.ywbh,t2.rptno,t2.fcyccy as cursign,t2.fcyamt as amount,t2.sjlrrq as interetdate,'Y' as jcxx,decode(t3.rptno, null, '', 'Y') as hxxx,'' as sbxx,t2.KKKKID as transactorgno,t2.launchmode as launchmode,t2.custnm,'7' as qtype,'外汇账户内结汇' as qtypename,'' tradeno,decode(t2.launchmode, 'TP', 'Y', 'N') as sfzfsb,t2.custype,t2.sfysb jcsfysb,t2.sxbz jcsxbz,t2.sfzx jcsfzx,'' sbsfysb,'' sbsxbz,'' sbsfzx,case when t3.sfysb is not null then t3.sfysb else '' end hxSFYSB,case when t3.sxbz is not null then t3.sxbz else '' end hxSXBZ,case when t3.sfzx is not null then t3.sfzx else '' end hxSFZXfrom sb_ZZZZ t2left join sb_ZZZZ_glxx t3 on t2.rptno = t3.rptnounion all--8.外汇账户内售汇select distinct t2.rwidh,t2.ywbh,t2.rptno,t2.lcyccy as cursign,t2.lcyamt as amount,t2.sjlrrq as interetdate,'Y' as jcxx,decode(t3.rptno, null, '', 'Y') as hxxx,'' as sbxx,t2.KKKKID as transactorgno,t2.launchmode as launchmode,t2.custnm,'8' as qtype,'外汇账户内购汇' as qtypename,'' tradeno,decode(t2.launchmode, 'TP', 'Y', 'N') as sfzfsb,t2.custype,t2.sfysb jcsfysb,t2.sxbz jcsxbz,t2.sfzx jcsfzx,'' sbsfysb,'' sbsxbz,'' sbsfzx,case when t3.sfysb is not null then t3.sfysb else '' end hxSFYSB,case when t3.sxbz is not null then t3.sxbz else '' end hxSXBZ,case when t3.sfzx is not null then t3.sfzx else '' end hxSFZXfrom sb_ZHHH t2left join sb_ZHHH_glxx t3 on t2.rptno = t3.rptno) tbleft join bu_TTTTTTTTTTTINFO t1 on tb.txnserialNo = t1.txnserialnounion all--未申报统计select + leading(t1)distinct t1.txnserialno,t1.currentbizno,'' rptno,t1.cursign as cursign,t1.amount as amount,t1.interetdate as interetdate,'' as jcxx,'' as hxxx,'' as sbxx,t1.transactorgno as transactorgno,'' as launchmode,t2name,'' as qtype,'未录入' as qtypename,t1.tradeno,'N' sfzfsb,'' custype,'' jcsfysb,'' jcsxbz,'' jcsfzx,'' sbsfysb,'' sbsxbz,'' sbsfzx,'' hxSFYSB,'' hxSXBZ,'' hxSFZXfrom bu_TTTTTTTTTTTINFO t1left join pa_CCCC t2 on t1.CCCCno = t2.CCCCnowhere t1.tradeno in('010002', '020088', '020043', '080103', '080104', '020043','080103', '080104', '030004', '030904', '030219', '030220','030221', '030222', '030223', '030908', '010001', '010011','080108', '080206', '080205', '080202', '030004', '030904','030219', '030220', '030221', '030222', '030223', '030908','010001', '010011', '080108', '080206', '080205', '080202','010003', '010004')
and not exists (select 1 from OWNERR.SB_SSSSSSS tt where t1.txnserialno=tt.rwidh)and not exists (select 1 from OWNERR.sb_CKKKKKK_jnsr t3 where t1.txnserialno=t3.rwidh)and not exists (select 1 from OWNERR.sb_JWWWW t4 where t1.txnserialno=t4.rwidh)and not exists (select 1 from OWNERR.sb_JNNNN t5 where t1.txnserialno=t5.rwidh)and not exists (select 1 from OWNERR.sb_DDDDDDTTS t6 where t1.txnserialno=t6.rwidh)and not exists (select 1 from OWNERR.sb_JNFFFFFFS t7 where t1.txnserialno=t7.rwidh)and not exists (select 1 from OWNERR.sb_ZZZZ t8 where t1.txnserialno=t8.rwidh)and not exists (select 1 from OWNERR.sb_ZHHH t9 where t1.txnserialno=t9.rwidh)and t1.transtate = '4') ot1left join pa_tradetype ot2 on ot1.tradeno = ot2.tradeno;
该语句VIEW_SB_UUUUUUUUUUUUUUUUU为视图,其中多次调用sb_SSSSYYYY视图,造成了比较复杂的嵌套视图调用,从执行计划看,在执行完对OWNERR.PP_OOO表的查询后得出的结果集较小,比较适合作为驱动条件,但由于视图复杂,该谓词条件并未推入到视图内部进行过滤,而是先生成view的所有数据,即大量的结果集,最后再进行过滤,由此导致视图中出现了大量的全表扫描。综上,考虑:
1) 对全表扫描的对象添加索引:
create index OWNERR.test_temp_i1 on OWNERR.SB_ZZZZ(KKKKID) tablespace xxx;
create index OWNERR.test_temp_i2 on OWNERR.SB_ZHHH(KKKKID) tablespace xxx;
2)添加hint,使OWNERR.PP_OOO的结果集能够作为谓词条件推入到视图尽早进行数据过滤,而非通过全表扫描得到大量数据最后再进行过滤。
select /*+ push_pred(v)*/ count(*)
from VIEW_SB_UUUUUUUUUUUUUUUUU v
where 1 = 1
and (KKKKID in (SELECT orgno
FROM PP_OOO
WHERE PARENTORGNO = '1100000784'
or orgno = '1100000784'));
调整后耗时、执行计划及资源消耗:
Elapsed: 00:00:00.73Execution Plan
----------------------------------------------------------
Plan hash value: 3495787813-----------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-----------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 29 | 41838 (1)| 00:08:23 |
| 1 | SORT AGGREGATE | | 1 | 29 | | |
| 2 | NESTED LOOPS | | 404 | 11716 | 41838 (1)| 00:08:23 |
| 3 | TABLE ACCESS BY INDEX ROWID | PP_OOO | 5 | 110 | 3 (0)| 00:00:01 |
| 4 | BITMAP CONVERSION TO ROWIDS | | | | | |
| 5 | BITMAP OR | | | | | |
| 6 | BITMAP CONVERSION FROM ROWIDS | | | | | |
|* 7 | INDEX RANGE SCAN | IND_PPPPP_PGO | | | 1 (0)| 00:00:01 |
| 8 | BITMAP CONVERSION FROM ROWIDS | | | | | |
|* 9 | INDEX RANGE SCAN | PK_PPPPP_KEY | | | 1 (0)| 00:00:01 |
| 10 | VIEW | VIEW_SB_UUUUUUUUUUUUUUUUU | 1 | 7 | 8367 (1)| 00:01:41 |
| 11 | UNION ALL PUSHED PREDICATE | | | | | |
| 12 | VIEW | | 9 | 63 | 1523 (1)| 00:00:19 |
| 13 | UNION-ALL | | | | | |
| 14 | NESTED LOOPS OUTER | | 8 | 1856 | 1522 (1)| 00:00:19 |
| 15 | VIEW | | 8 | 1664 | 1506 (1)| 00:00:19 |
| 16 | UNION-ALL | | | | | |
| 17 | SORT UNIQUE | | 1 | 150 | 777 (1)| 00:00:10 |
| 18 | NESTED LOOPS OUTER | | 1 | 150 | 776 (0)| 00:00:10 |
|* 19 | TABLE ACCESS BY INDEX ROWID | SB_SSSSSSS | 1 | 121 | 775 (0)| 00:00:10 |
|* 20 | INDEX RANGE SCAN | INX_SSSRSSD_BID | 1104 | | 6 (0)| 00:00:01 |
| 21 | TABLE ACCESS BY INDEX ROWID | SB_SSSSSSS_SBXX | 1 | 29 | 1 (0)| 00:00:01 |
|* 22 | INDEX RANGE SCAN | INX_SSSRRRRXXXXRNO | 1 | | 0 (0)| 00:00:01 |
| 23 | SORT UNIQUE | | 1 | 155 | 64 (2)| 00:00:01 |
| 24 | NESTED LOOPS OUTER | | 1 | 155 | 63 (0)| 00:00:01 |
|* 25 | TABLE ACCESS BY INDEX ROWID | SB_CKKKKKK_JNSR | 1 | 126 | 61 (0)| 00:00:01 |
|* 26 | INDEX RANGE SCAN | INX_CKSHHXZYLJNBID | 105 | | 1 (0)| 00:00:01 |
| 27 | TABLE ACCESS BY INDEX ROWID | SB_CKKKKKK_JN_HXXX | 1 | 29 | 2 (0)| 00:00:01 |
|* 28 | INDEX RANGE SCAN | INX_CKKKKKKJNHXXXR | 1 | | 1 (0)| 00:00:01 |
| 29 | SORT UNIQUE | | 1 | 176 | 375 (1)| 00:00:05 |
| 30 | NESTED LOOPS OUTER | | 1 | 176 | 374 (0)| 00:00:05 |
| 31 | NESTED LOOPS OUTER | | 1 | 147 | 373 (0)| 00:00:05 |
|* 32 | TABLE ACCESS BY INDEX ROWID | SB_JWWWW | 1 | 118 | 372 (0)| 00:00:05 |
|* 33 | INDEX RANGE SCAN | INX_JWWWWQSBID | 471 | | 4 (0)| 00:00:01 |
| 34 | TABLE ACCESS BY INDEX ROWID | SB_JWWWW_HXXX | 1 | 29 | 1 (0)| 00:00:01 |
|* 35 | INDEX RANGE SCAN | INX_JWWWWQSHXXXRNO | 1 | | 0 (0)| 00:00:01 |
| 36 | TABLE ACCESS BY INDEX ROWID | SB_JWWWW_SBXX | 1 | 29 | 1 (0)| 00:00:01 |
|* 37 | INDEX RANGE SCAN | INX_JWWWWQSSBXXRNO | 1 | | 0 (0)| 00:00:01 |
| 38 | SORT UNIQUE | | 1 | 154 | 109 (1)| 00:00:02 |
| 39 | NESTED LOOPS OUTER | | 1 | 154 | 108 (0)| 00:00:02 |
|* 40 | TABLE ACCESS BY INDEX ROWID | SB_JNNNN | 1 | 125 | 107 (0)| 00:00:02 |
|* 41 | INDEX RANGE SCAN | INX_JNNNNQSBID | 167 | | 1 (0)| 00:00:01 |
| 42 | TABLE ACCESS BY INDEX ROWID | SB_JNNNN_HXXX | 1 | 29 | 1 (0)| 00:00:01 |
|* 43 | INDEX RANGE SCAN | INX_JNNNNQSHXXXRNO | 1 | | 0 (0)| 00:00:01 |
| 44 | SORT UNIQUE | | 1 | 183 | 151 (1)| 00:00:02 |
| 45 | NESTED LOOPS OUTER | | 1 | 183 | 150 (0)| 00:00:02 |
| 46 | NESTED LOOPS OUTER | | 1 | 154 | 149 (0)| 00:00:02 |
|* 47 | TABLE ACCESS BY INDEX ROWID | SB_DDDDDDTTS | 1 | 125 | 148 (0)| 00:00:02 |
|* 48 | INDEX RANGE SCAN | INX_DWWWWWTZSBID | 217 | | 1 (0)| 00:00:01 |
| 49 | TABLE ACCESS BY INDEX ROWID | SB_DWWWWWTZS_HXXX | 1 | 29 | 1 (0)| 00:00:01 |
|* 50 | INDEX RANGE SCAN | INX_DWWWWWWWWWWWNO | 1 | | 0 (0)| 00:00:01 |
| 51 | TABLE ACCESS BY INDEX ROWID | SB_DWWWWWTZS_SBXX | 1 | 29 | 1 (0)| 00:00:01 |
|* 52 | INDEX RANGE SCAN | INX_DWDDDDDDDDDDNO | 1 | | 0 (0)| 00:00:01 |
| 53 | SORT UNIQUE | | 1 | 154 | 18 (6)| 00:00:01 |
| 54 | NESTED LOOPS OUTER | | 1 | 154 | 17 (0)| 00:00:01 |
|* 55 | TABLE ACCESS BY INDEX ROWID | SB_JNFFFFFFS | 1 | 125 | 16 (0)| 00:00:01 |
|* 56 | INDEX RANGE SCAN | INX_JNFFFFFFSBID | 32 | | 1 (0)| 00:00:01 |
| 57 | TABLE ACCESS BY INDEX ROWID | SB_DDDDDDTZS_HXXX | 1 | 29 | 1 (0)| 00:00:01 |
|* 58 | INDEX RANGE SCAN | INX_DNNNNNNNNNNNNO | 1 | | 0 (0)| 00:00:01 |
| 59 | SORT UNIQUE | | 1 | 151 | 5 (20)| 00:00:01 |
| 60 | NESTED LOOPS OUTER | | 1 | 151 | 4 (0)| 00:00:01 |
|* 61 | TABLE ACCESS BY INDEX ROWID | SB_ZZZZ | 1 | 122 | 3 (0)| 00:00:01 |
|* 62 | INDEX RANGE SCAN | TEST_TEMP_I1 | 644 | | 1 (0)| 00:00:01 |
| 63 | TABLE ACCESS BY INDEX ROWID | SB_ZZZZ_GLXX | 1 | 29 | 1 (0)| 00:00:01 |
|* 64 | INDEX RANGE SCAN | PK_SB_ZZZZ_GLXX_RPTNO | 1 | | 0 (0)| 00:00:01 |
| 65 | SORT UNIQUE | | 1 | 153 | 6 (17)| 00:00:01 |
| 66 | NESTED LOOPS OUTER | | 1 | 153 | 5 (0)| 00:00:01 |
|* 67 | TABLE ACCESS BY INDEX ROWID | SB_ZHHH | 1 | 124 | 4 (0)| 00:00:01 |
|* 68 | INDEX RANGE SCAN | TEST_TEMP_I2 | 113 | | 1 (0)| 00:00:01 |
| 69 | TABLE ACCESS BY INDEX ROWID | SB_ZHHH_GLXX | 1 | 29 | 1 (0)| 00:00:01 |
|* 70 | INDEX RANGE SCAN | PK_SB_ZHHH_GLXX_RPTNO | 1 | | 0 (0)| 00:00:01 |
| 71 | TABLE ACCESS BY INDEX ROWID | BU_TTTTTTTTTTTINFO | 1 | 24 | 2 (0)| 00:00:01 |
|* 72 | INDEX UNIQUE SCAN | PK_BRRRRRRRRD_KEY | 1 | | 1 (0)| 00:00:01 |
| 73 | SORT UNIQUE | | 1 | 128 | 1 (100)| 00:00:01 |
|* 74 | FILTER | | | | | |
| 75 | NESTED LOOPS OUTER | | 1 | 128 | 17732 (1)| 00:03:33 |
|* 76 | HASH JOIN ANTI | | 1 | 97 | 17731 (1)| 00:03:33 |
|* 77 | TABLE ACCESS BY INDEX ROWID | BU_TTTTTTTTTTTINFO | 110 | 8800 | 3084 (1)| 00:00:38 |
|* 78 | INDEX RANGE SCAN | IND_BUTRANSAC_TRG2 | 4090 | | 15 (0)| 00:00:01 |
| 79 | VIEW | | 1398K| 22M| 14639 (1)| 00:02:56 |
| 80 | UNION-ALL | | | | | |
| 81 | TABLE ACCESS FULL | SB_SSSSSSS | 607K| 9M| 6174 (1)| 00:01:15 |
| 82 | TABLE ACCESS FULL | SB_CKKKKKK_JNSR | 35512 | 589K| 378 (1)| 00:00:05 |
| 83 | TABLE ACCESS FULL | SB_JWWWW | 261K| 4348K| 2635 (1)| 00:00:32 |
| 84 | TABLE ACCESS FULL | SB_JNNNN | 64426 | 1069K| 960 (1)| 00:00:12 |
| 85 | TABLE ACCESS FULL | SB_DDDDDDTTS | 76194 | 1264K| 892 (1)| 00:00:11 |
| 86 | TABLE ACCESS FULL | SB_JNFFFFFFS | 4688 | 79696 | 103 (0)| 00:00:02 |
| 87 | TABLE ACCESS FULL | SB_ZZZZ | 304K| 5055K| 3051 (1)| 00:00:37 |
| 88 | TABLE ACCESS FULL | SB_ZHHH | 43465 | 721K| 447 (1)| 00:00:06 |
| 89 | TABLE ACCESS BY INDEX ROWID | PA_CCCC | 1 | 31 | 1 (0)| 00:00:01 |
|* 90 | INDEX UNIQUE SCAN | PK_PACCCC_KEY | 1 | | 0 (0)| 00:00:01 |
| 91 | VIEW | | 145 | 1015 | 1803 (1)| 00:00:22 |
| 92 | UNION-ALL | | | | | |
| 93 | NESTED LOOPS OUTER | | 144 | 33408 | 1802 (1)| 00:00:22 |
| 94 | VIEW | | 144 | 29952 | 1514 (1)| 00:00:19 |
| 95 | UNION-ALL | | | | | |
| 96 | SORT UNIQUE | | 55 | 8250 | 777 (1)| 00:00:10 |
|* 97 | FILTER | | | | | |
| 98 | NESTED LOOPS OUTER | | 55 | 8250 | 776 (0)| 00:00:10 |
|* 99 | TABLE ACCESS BY INDEX ROWID | SB_SSSSSSS | 55 | 6655 | 775 (0)| 00:00:10 |
|*100 | INDEX RANGE SCAN | INX_SSSRSSD_BID | 1104 | | 6 (0)| 00:00:01 |
| 101 | TABLE ACCESS BY INDEX ROWID | SB_SSSSSSS_SBXX | 1 | 29 | 1 (0)| 00:00:01 |
|*102 | INDEX RANGE SCAN | INX_SSSRRRRXXXXRNO | 1 | | 0 (0)| 00:00:01 |
| 103 | SORT UNIQUE | | 6 | 930 | 72 (2)| 00:00:01 |
|*104 | FILTER | | | | | |
| 105 | NESTED LOOPS OUTER | | 6 | 930 | 71 (0)| 00:00:01 |
|*106 | TABLE ACCESS BY INDEX ROWID | SB_CKKKKKK_JNSR | 5 | 630 | 61 (0)| 00:00:01 |
|*107 | INDEX RANGE SCAN | INX_CKSHHXZYLJNBID | 105 | | 1 (0)| 00:00:01 |
| 108 | TABLE ACCESS BY INDEX ROWID | SB_CKKKKKK_JN_HXXX | 1 | 29 | 2 (0)| 00:00:01 |
|*109 | INDEX RANGE SCAN | INX_CKKKKKKJNHXXXR | 1 | | 1 (0)| 00:00:01 |
| 110 | SORT UNIQUE | | 24 | 4224 | 375 (1)| 00:00:05 |
|*111 | FILTER | | | | | |
| 112 | NESTED LOOPS OUTER | | 24 | 4224 | 374 (0)| 00:00:05 |
| 113 | NESTED LOOPS OUTER | | 24 | 3528 | 373 (0)| 00:00:05 |
|*114 | TABLE ACCESS BY INDEX ROWID | SB_JWWWW | 24 | 2832 | 372 (0)| 00:00:05 |
|*115 | INDEX RANGE SCAN | INX_JWWWWQSBID | 471 | | 4 (0)| 00:00:01 |
| 116 | TABLE ACCESS BY INDEX ROWID | SB_JWWWW_HXXX | 1 | 29 | 1 (0)| 00:00:01 |
|*117 | INDEX RANGE SCAN | INX_JWWWWQSHXXXRNO | 1 | | 0 (0)| 00:00:01 |
| 118 | TABLE ACCESS BY INDEX ROWID | SB_JWWWW_SBXX | 1 | 29 | 1 (0)| 00:00:01 |
|*119 | INDEX RANGE SCAN | INX_JWWWWQSSBXXRNO | 1 | | 0 (0)| 00:00:01 |
| 120 | SORT UNIQUE | | 8 | 1232 | 109 (1)| 00:00:02 |
|*121 | FILTER | | | | | |
| 122 | NESTED LOOPS OUTER | | 8 | 1232 | 108 (0)| 00:00:02 |
|*123 | TABLE ACCESS BY INDEX ROWID | SB_JNNNN | 8 | 1000 | 107 (0)| 00:00:02 |
|*124 | INDEX RANGE SCAN | INX_JNNNNQSBID | 167 | | 1 (0)| 00:00:01 |
| 125 | TABLE ACCESS BY INDEX ROWID | SB_JNNNN_HXXX | 1 | 29 | 1 (0)| 00:00:01 |
|*126 | INDEX RANGE SCAN | INX_JNNNNQSHXXXRNO | 1 | | 0 (0)| 00:00:01 |
| 127 | SORT UNIQUE | | 11 | 2013 | 151 (1)| 00:00:02 |
|*128 | FILTER | | | | | |
| 129 | NESTED LOOPS OUTER | | 11 | 2013 | 150 (0)| 00:00:02 |
| 130 | NESTED LOOPS OUTER | | 11 | 1694 | 149 (0)| 00:00:02 |
|*131 | TABLE ACCESS BY INDEX ROWID | SB_DDDDDDTTS | 11 | 1375 | 148 (0)| 00:00:02 |
|*132 | INDEX RANGE SCAN | INX_DWWWWWTZSBID | 217 | | 1 (0)| 00:00:01 |
| 133 | TABLE ACCESS BY INDEX ROWID | SB_DWWWWWTZS_HXXX | 1 | 29 | 1 (0)| 00:00:01 |
|*134 | INDEX RANGE SCAN | INX_DWWWWWWWWWWWNO | 1 | | 0 (0)| 00:00:01 |
| 135 | TABLE ACCESS BY INDEX ROWID | SB_DWWWWWTZS_SBXX | 1 | 29 | 1 (0)| 00:00:01 |
|*136 | INDEX RANGE SCAN | INX_DWDDDDDDDDDDNO | 1 | | 0 (0)| 00:00:01 |
| 137 | SORT UNIQUE | | 2 | 308 | 18 (6)| 00:00:01 |
|*138 | FILTER | | | | | |
| 139 | NESTED LOOPS OUTER | | 2 | 308 | 17 (0)| 00:00:01 |
|*140 | TABLE ACCESS BY INDEX ROWID | SB_JNFFFFFFS | 2 | 250 | 16 (0)| 00:00:01 |
|*141 | INDEX RANGE SCAN | INX_JNFFFFFFSBID | 32 | | 1 (0)| 00:00:01 |
| 142 | TABLE ACCESS BY INDEX ROWID | SB_DDDDDDTZS_HXXX | 1 | 29 | 1 (0)| 00:00:01 |
|*143 | INDEX RANGE SCAN | INX_DNNNNNNNNNNNNO | 1 | | 0 (0)| 00:00:01 |
| 144 | SORT UNIQUE | | 32 | 4832 | 5 (20)| 00:00:01 |
|*145 | FILTER | | | | | |
| 146 | NESTED LOOPS OUTER | | 32 | 4832 | 4 (0)| 00:00:01 |
|*147 | TABLE ACCESS BY INDEX ROWID | SB_ZZZZ | 32 | 3904 | 3 (0)| 00:00:01 |
|*148 | INDEX RANGE SCAN | TEST_TEMP_I1 | 644 | | 1 (0)| 00:00:01 |
| 149 | TABLE ACCESS BY INDEX ROWID | SB_ZZZZ_GLXX | 1 | 29 | 1 (0)| 00:00:01 |
|*150 | INDEX RANGE SCAN | PK_SB_ZZZZ_GLXX_RPTNO | 1 | | 0 (0)| 00:00:01 |
| 151 | SORT UNIQUE | | 6 | 918 | 6 (17)| 00:00:01 |
|*152 | FILTER | | | | | |
| 153 | NESTED LOOPS OUTER | | 6 | 918 | 5 (0)| 00:00:01 |
|*154 | TABLE ACCESS BY INDEX ROWID | SB_ZHHH | 6 | 744 | 4 (0)| 00:00:01 |
|*155 | INDEX RANGE SCAN | TEST_TEMP_I2 | 113 | | 1 (0)| 00:00:01 |
| 156 | TABLE ACCESS BY INDEX ROWID | SB_ZHHH_GLXX | 1 | 29 | 1 (0)| 00:00:01 |
|*157 | INDEX RANGE SCAN | PK_SB_ZHHH_GLXX_RPTNO | 1 | | 0 (0)| 00:00:01 |
| 158 | TABLE ACCESS BY INDEX ROWID | BU_TTTTTTTTTTTINFO | 1 | 24 | 2 (0)| 00:00:01 |
|*159 | INDEX UNIQUE SCAN | PK_BRRRRRRRRD_KEY | 1 | | 1 (0)| 00:00:01 |
| 160 | SORT UNIQUE | | 1 | 128 | 1 (100)| 00:00:01 |
|*161 | FILTER | | | | | |
| 162 | NESTED LOOPS OUTER | | 1 | 128 | 17732 (1)| 00:03:33 |
|*163 | HASH JOIN ANTI | | 1 | 97 | 17731 (1)| 00:03:33 |
|*164 | TABLE ACCESS BY INDEX ROWID | BU_TTTTTTTTTTTINFO | 110 | 8800 | 3084 (1)| 00:00:38 |
|*165 | INDEX RANGE SCAN | IND_BUTRANSAC_TRG2 | 4090 | | 15 (0)| 00:00:01 |
| 166 | VIEW | | 1398K| 22M| 14639 (1)| 00:02:56 |
| 167 | UNION-ALL | | | | | |
| 168 | TABLE ACCESS FULL | SB_SSSSSSS | 607K| 9M| 6174 (1)| 00:01:15 |
| 169 | TABLE ACCESS FULL | SB_CKKKKKK_JNSR | 35512 | 589K| 378 (1)| 00:00:05 |
| 170 | TABLE ACCESS FULL | SB_JWWWW | 261K| 4348K| 2635 (1)| 00:00:32 |
| 171 | TABLE ACCESS FULL | SB_JNNNN | 64426 | 1069K| 960 (1)| 00:00:12 |
| 172 | TABLE ACCESS FULL | SB_DDDDDDTTS | 76194 | 1264K| 892 (1)| 00:00:11 |
| 173 | TABLE ACCESS FULL | SB_JNFFFFFFS | 4688 | 79696 | 103 (0)| 00:00:02 |
| 174 | TABLE ACCESS FULL | SB_ZZZZ | 304K| 5055K| 3051 (1)| 00:00:37 |
| 175 | TABLE ACCESS FULL | SB_ZHHH | 43465 | 721K| 447 (1)| 00:00:06 |
| 176 | TABLE ACCESS BY INDEX ROWID | PA_CCCC | 1 | 31 | 1 (0)| 00:00:01 |
|*177 | INDEX UNIQUE SCAN | PK_PACCCC_KEY | 1 | | 0 (0)| 00:00:01 |
|*178 | HASH JOIN SEMI | | 145 | 6670 | 5041 (1)| 00:01:01 |
| 179 | VIEW | | 145 | 2900 | 4902 (1)| 00:00:59 |
| 180 | UNION-ALL | | | | | |
| 181 | NESTED LOOPS OUTER | | 144 | 33408 | 1802 (1)| 00:00:22 |
|*182 | VIEW | | 144 | 29952 | 1514 (1)| 00:00:19 |
| 183 | UNION-ALL | | | | | |
| 184 | SORT UNIQUE | | 55 | 8250 | 777 (1)| 00:00:10 |
|*185 | FILTER | | | | | |
| 186 | NESTED LOOPS OUTER | | 55 | 8250 | 776 (0)| 00:00:10 |
|*187 | TABLE ACCESS BY INDEX ROWID | SB_SSSSSSS | 55 | 6655 | 775 (0)| 00:00:10 |
|*188 | INDEX RANGE SCAN | INX_SSSRSSD_BID | 1104 | | 6 (0)| 00:00:01 |
| 189 | TABLE ACCESS BY INDEX ROWID | SB_SSSSSSS_SBXX | 1 | 29 | 1 (0)| 00:00:01 |
|*190 | INDEX RANGE SCAN | INX_SSSRRRRXXXXRNO | 1 | | 0 (0)| 00:00:01 |
| 191 | SORT UNIQUE | | 6 | 930 | 72 (2)| 00:00:01 |
|*192 | FILTER | | | | | |
| 193 | NESTED LOOPS OUTER | | 6 | 930 | 71 (0)| 00:00:01 |
|*194 | TABLE ACCESS BY INDEX ROWID | SB_CKKKKKK_JNSR | 5 | 630 | 61 (0)| 00:00:01 |
|*195 | INDEX RANGE SCAN | INX_CKSHHXZYLJNBID | 105 | | 1 (0)| 00:00:01 |
| 196 | TABLE ACCESS BY INDEX ROWID | SB_CKKKKKK_JN_HXXX | 1 | 29 | 2 (0)| 00:00:01 |
|*197 | INDEX RANGE SCAN | INX_CKKKKKKJNHXXXR | 1 | | 1 (0)| 00:00:01 |
| 198 | SORT UNIQUE | | 24 | 4224 | 375 (1)| 00:00:05 |
|*199 | FILTER | | | | | |
| 200 | NESTED LOOPS OUTER | | 24 | 4224 | 374 (0)| 00:00:05 |
| 201 | NESTED LOOPS OUTER | | 24 | 3528 | 373 (0)| 00:00:05 |
|*202 | TABLE ACCESS BY INDEX ROWID| SB_JWWWW | 24 | 2832 | 372 (0)| 00:00:05 |
|*203 | INDEX RANGE SCAN | INX_JWWWWQSBID | 471 | | 4 (0)| 00:00:01 |
| 204 | TABLE ACCESS BY INDEX ROWID| SB_JWWWW_HXXX | 1 | 29 | 1 (0)| 00:00:01 |
|*205 | INDEX RANGE SCAN | INX_JWWWWQSHXXXRNO | 1 | | 0 (0)| 00:00:01 |
| 206 | TABLE ACCESS BY INDEX ROWID | SB_JWWWW_SBXX | 1 | 29 | 1 (0)| 00:00:01 |
|*207 | INDEX RANGE SCAN | INX_JWWWWQSSBXXRNO | 1 | | 0 (0)| 00:00:01 |
| 208 | SORT UNIQUE | | 8 | 1232 | 109 (1)| 00:00:02 |
|*209 | FILTER | | | | | |
| 210 | NESTED LOOPS OUTER | | 8 | 1232 | 108 (0)| 00:00:02 |
|*211 | TABLE ACCESS BY INDEX ROWID | SB_JNNNN | 8 | 1000 | 107 (0)| 00:00:02 |
|*212 | INDEX RANGE SCAN | INX_JNNNNQSBID | 167 | | 1 (0)| 00:00:01 |
| 213 | TABLE ACCESS BY INDEX ROWID | SB_JNNNN_HXXX | 1 | 29 | 1 (0)| 00:00:01 |
|*214 | INDEX RANGE SCAN | INX_JNNNNQSHXXXRNO | 1 | | 0 (0)| 00:00:01 |
| 215 | SORT UNIQUE | | 11 | 2013 | 151 (1)| 00:00:02 |
|*216 | FILTER | | | | | |
| 217 | NESTED LOOPS OUTER | | 11 | 2013 | 150 (0)| 00:00:02 |
| 218 | NESTED LOOPS OUTER | | 11 | 1694 | 149 (0)| 00:00:02 |
|*219 | TABLE ACCESS BY INDEX ROWID| SB_DDDDDDTTS | 11 | 1375 | 148 (0)| 00:00:02 |
|*220 | INDEX RANGE SCAN | INX_DWWWWWTZSBID | 217 | | 1 (0)| 00:00:01 |
| 221 | TABLE ACCESS BY INDEX ROWID| SB_DWWWWWTZS_HXXX | 1 | 29 | 1 (0)| 00:00:01 |
|*222 | INDEX RANGE SCAN | INX_DWWWWWWWWWWWNO | 1 | | 0 (0)| 00:00:01 |
| 223 | TABLE ACCESS BY INDEX ROWID | SB_DWWWWWTZS_SBXX | 1 | 29 | 1 (0)| 00:00:01 |
|*224 | INDEX RANGE SCAN | INX_DWDDDDDDDDDDNO | 1 | | 0 (0)| 00:00:01 |
| 225 | SORT UNIQUE | | 2 | 308 | 18 (6)| 00:00:01 |
|*226 | FILTER | | | | | |
| 227 | NESTED LOOPS OUTER | | 2 | 308 | 17 (0)| 00:00:01 |
|*228 | TABLE ACCESS BY INDEX ROWID | SB_JNFFFFFFS | 2 | 250 | 16 (0)| 00:00:01 |
|*229 | INDEX RANGE SCAN | INX_JNFFFFFFSBID | 32 | | 1 (0)| 00:00:01 |
| 230 | TABLE ACCESS BY INDEX ROWID | SB_DDDDDDTZS_HXXX | 1 | 29 | 1 (0)| 00:00:01 |
|*231 | INDEX RANGE SCAN | INX_DNNNNNNNNNNNNO | 1 | | 0 (0)| 00:00:01 |
| 232 | SORT UNIQUE | | 32 | 4832 | 5 (20)| 00:00:01 |
|*233 | FILTER | | | | | |
| 234 | NESTED LOOPS OUTER | | 32 | 4832 | 4 (0)| 00:00:01 |
|*235 | TABLE ACCESS BY INDEX ROWID | SB_ZZZZ | 32 | 3904 | 3 (0)| 00:00:01 |
|*236 | INDEX RANGE SCAN | TEST_TEMP_I1 | 644 | | 1 (0)| 00:00:01 |
| 237 | TABLE ACCESS BY INDEX ROWID | SB_ZZZZ_GLXX | 1 | 29 | 1 (0)| 00:00:01 |
|*238 | INDEX RANGE SCAN | PK_SB_ZZZZ_GLXX_RPTNO | 1 | | 0 (0)| 00:00:01 |
| 239 | SORT UNIQUE | | 6 | 918 | 6 (17)| 00:00:01 |
|*240 | FILTER | | | | | |
| 241 | NESTED LOOPS OUTER | | 6 | 918 | 5 (0)| 00:00:01 |
|*242 | TABLE ACCESS BY INDEX ROWID | SB_ZHHH | 6 | 744 | 4 (0)| 00:00:01 |
|*243 | INDEX RANGE SCAN | TEST_TEMP_I2 | 113 | | 1 (0)| 00:00:01 |
| 244 | TABLE ACCESS BY INDEX ROWID | SB_ZHHH_GLXX | 1 | 29 | 1 (0)| 00:00:01 |
|*245 | INDEX RANGE SCAN | PK_SB_ZHHH_GLXX_RPTNO | 1 | | 0 (0)| 00:00:01 |
| 246 | TABLE ACCESS BY INDEX ROWID | BU_TTTTTTTTTTTINFO | 1 | 24 | 2 (0)| 00:00:01 |
|*247 | INDEX UNIQUE SCAN | PK_BRRRRRRRRD_KEY | 1 | | 1 (0)| 00:00:01 |
| 248 | SORT UNIQUE | | 1 | 128 | 3100 (1)| 00:00:38 |
| 249 | NESTED LOOPS ANTI | | 1 | 128 | 3099 (1)| 00:00:38 |
| 250 | NESTED LOOPS OUTER | | 1 | 111 | 3085 (1)| 00:00:38 |
|*251 | TABLE ACCESS BY INDEX ROWID | BU_TTTTTTTTTTTINFO | 1 | 80 | 3084 (1)| 00:00:38 |
|*252 | INDEX RANGE SCAN | IND_BUTRANSAC_TRG2 | 4090 | | 15 (0)| 00:00:01 |
| 253 | TABLE ACCESS BY INDEX ROWID | PA_CCCC | 1 | 31 | 1 (0)| 00:00:01 |
|*254 | INDEX UNIQUE SCAN | PK_PACCCC_KEY | 1 | | 0 (0)| 00:00:01 |
| 255 | VIEW | | 2 | 34 | 14 (0)| 00:00:01 |
| 256 | UNION ALL PUSHED PREDICATE | | | | | |
|*257 | INDEX RANGE SCAN | INX_SSSRSSD_TID | 1 | 17 | 3 (0)| 00:00:01 |
|*258 | INDEX RANGE SCAN | INX_CKSHHHHHHJNTID | 1 | 17 | 1 (0)| 00:00:01 |
|*259 | INDEX RANGE SCAN | INX_JWWWWQSTID | 1 | 17 | 3 (0)| 00:00:01 |
|*260 | INDEX RANGE SCAN | INX_JNNNNQSTID | 1 | 17 | 1 (0)| 00:00:01 |
|*261 | INDEX RANGE SCAN | INX_DWWWWWTZSTID | 1 | 17 | 1 (0)| 00:00:01 |
|*262 | INDEX RANGE SCAN | INX_JNFFFFFFSTID | 1 | 17 | 1 (0)| 00:00:01 |
|*263 | INDEX RANGE SCAN | IDX_SB_ZZZZ_RWIDH | 1 | 17 | 3 (0)| 00:00:01 |
|*264 | INDEX RANGE SCAN | IDX_SB_ZHHH_RWIDH | 1 | 17 | 1 (0)| 00:00:01 |
|*265 | TABLE ACCESS FULL | SB_DEEEEEEERR | 7205 | 182K| 139 (1)| 00:00:02 |
-----------------------------------------------------------------------------------------------------------------------Predicate Information (identified by operation id):
---------------------------------------------------7 - access("PARENTORGNO"='1100000784')9 - access("ORGNO"='1100000784')19 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND"T2"."SFZX"='Y' AND "T2"."SXBZ"='1')20 - access("T2"."BANK_ID"="ORGNO")22 - access("T2"."RPTNO"="T3"."RPTNO"(+))25 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND"T2"."SFZX"='Y' AND "T2"."SXBZ"='1')26 - access("T2"."BANK_ID"="ORGNO")28 - access("T2"."RPTNO"="T3"."RPTNO"(+))32 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND"T2"."SFZX"='Y' AND "T2"."SXBZ"='1')33 - access("T2"."BANK_ID"="ORGNO")35 - access("T2"."RPTNO"="T3"."RPTNO"(+))37 - access("T2"."RPTNO"="T4"."RPTNO"(+))40 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND"T2"."SFZX"='Y' AND "T2"."SXBZ"='1')41 - access("T2"."BANK_ID"="ORGNO")43 - access("T2"."RPTNO"="T3"."RPTNO"(+))47 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND"T2"."SFZX"='Y' AND "T2"."SXBZ"='1')48 - access("T2"."BANK_ID"="ORGNO")50 - access("T2"."RPTNO"="T4"."RPTNO"(+))52 - access("T2"."RPTNO"="T3"."RPTNO"(+))55 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND"T2"."SFZX"='Y' AND "T2"."SXBZ"='1')56 - access("T2"."BANK_ID"="ORGNO")58 - access("T2"."RPTNO"="T3"."RPTNO"(+))61 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND"T2"."SFZX"='Y' AND "T2"."SXBZ"='1')62 - access("T2"."KKKKID"="ORGNO")64 - access("T2"."RPTNO"="T3"."RPTNO"(+))67 - filter("T2"."SFYSB"='N' AND ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@! AND"T2"."SXBZ"='1' AND "T2"."SFZX"='Y')68 - access("T2"."KKKKID"="ORGNO")70 - access("T2"."RPTNO"="T3"."RPTNO"(+))72 - access("TB"."TXNSERIALNO"="T1"."TXNSERIALNO"(+))74 - filter(NULL IS NOT NULL AND NULL IS NOT NULL AND NULL IS NOT NULL)76 - access("T1"."TXNSERIALNO"="B"."RWIDH")77 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T1"."INTERETDATE"),1)>SYSDATE@! AND ("T1"."TRADENO"='010001' OR"T1"."TRADENO"='010002' OR "T1"."TRADENO"='010003' OR "T1"."TRADENO"='010004' OR "T1"."TRADENO"='010011' OR"T1"."TRADENO"='020043' OR "T1"."TRADENO"='020088' OR "T1"."TRADENO"='030004' OR "T1"."TRADENO"='030219' OR"T1"."TRADENO"='030220' OR "T1"."TRADENO"='030221' OR "T1"."TRADENO"='030222' OR "T1"."TRADENO"='030223' OR"T1"."TRADENO"='030904' OR "T1"."TRADENO"='030908' OR "T1"."TRADENO"='080103' OR "T1"."TRADENO"='080104' OR"T1"."TRADENO"='080108' OR "T1"."TRADENO"='080202' OR "T1"."TRADENO"='080205' OR "T1"."TRADENO"='080206') AND"T1"."TRANSTATE"='4')78 - access("T1"."TRANSACTORGNO"="ORGNO")90 - access("T1"."CCCCNO"="T2"."CCCCNO"(+))97 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T3"."SFYSB" IS NOT NULLTHEN "T3"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END ='0'AND CASE WHEN "T3"."SFZX" IS NOT NULL THEN "T3"."SFZX" ELSE '*' END ='Y')99 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)100 - access("T2"."BANK_ID"="ORGNO")102 - access("T2"."RPTNO"="T3"."RPTNO"(+))104 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T3"."SFYSB" IS NOT NULLTHEN "T3"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END ='0'AND CASE WHEN "T3"."SFZX" IS NOT NULL THEN "T3"."SFZX" ELSE '*' END ='Y')106 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)107 - access("T2"."BANK_ID"="ORGNO")109 - access("T2"."RPTNO"="T3"."RPTNO"(+))111 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T4"."SFYSB" IS NOT NULLTHEN "T4"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T4"."SXBZ" IS NOT NULL THEN "T4"."SXBZ" ELSE '*' END ='0'AND CASE WHEN "T4"."SFZX" IS NOT NULL THEN "T4"."SFZX" ELSE '*' END ='Y' OR CASE WHEN "T3"."SFYSB" IS NOTNULL THEN "T3"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END='0' AND CASE WHEN "T3"."SFZX" IS NOT NULL THEN "T3"."SFZX" ELSE '*' END ='Y')114 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)115 - access("T2"."BANK_ID"="ORGNO")117 - access("T2"."RPTNO"="T3"."RPTNO"(+))119 - access("T2"."RPTNO"="T4"."RPTNO"(+))121 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T3"."SFYSB" IS NOT NULLTHEN "T3"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END ='0'AND CASE WHEN "T3"."SFZX" IS NOT NULL THEN "T3"."SFZX" ELSE '*' END ='Y')123 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)124 - access("T2"."BANK_ID"="ORGNO")126 - access("T2"."RPTNO"="T3"."RPTNO"(+))128 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T3"."SFYSB" IS NOT NULLTHEN "T3"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END ='0'AND CASE WHEN "T3"."SFZX" IS NOT NULL THEN "T3"."SFZX" ELSE '*' END ='Y' OR CASE WHEN "T4"."SFYSB" IS NOTNULL THEN "T4"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T4"."SXBZ" IS NOT NULL THEN "T4"."SXBZ" ELSE '*' END='0' AND CASE WHEN "T4"."SFZX" IS NOT NULL THEN "T4"."SFZX" ELSE '*' END ='Y')131 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)132 - access("T2"."BANK_ID"="ORGNO")134 - access("T2"."RPTNO"="T4"."RPTNO"(+))136 - access("T2"."RPTNO"="T3"."RPTNO"(+))138 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T3"."SFYSB" IS NOT NULLTHEN "T3"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END ='0'AND CASE WHEN "T3"."SFZX" IS NOT NULL THEN "T3"."SFZX" ELSE '*' END ='Y')140 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)141 - access("T2"."BANK_ID"="ORGNO")143 - access("T2"."RPTNO"="T3"."RPTNO"(+))145 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T3"."SFYSB" IS NOT NULLTHEN "T3"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END ='0'AND CASE WHEN "T3"."SFZX" IS NOT NULL THEN "T3"."SFZX" ELSE '*' END ='Y')147 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)148 - access("T2"."KKKKID"="ORGNO")150 - access("T2"."RPTNO"="T3"."RPTNO"(+))152 - filter("T2"."SFYSB"='N' AND "T2"."SXBZ"='0' AND "T2"."SFZX"='Y' OR CASE WHEN "T3"."SFYSB" IS NOT NULLTHEN "T3"."SFYSB" ELSE '*' END ='N' AND CASE WHEN "T3"."SXBZ" IS NOT NULL THEN "T3"."SXBZ" ELSE '*' END ='0'AND CASE WHEN "T3"."SFZX" IS NOT NULL THEN "T3"."SFZX" ELSE '*' END ='Y')154 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)155 - access("T2"."KKKKID"="ORGNO")157 - access("T2"."RPTNO"="T3"."RPTNO"(+))159 - access("TB"."TXNSERIALNO"="T1"."TXNSERIALNO"(+))161 - filter(NULL IS NOT NULL AND NULL IS NOT NULL AND NULL IS NOT NULL)163 - access("T1"."TXNSERIALNO"="B"."RWIDH")164 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T1"."INTERETDATE"),1)>SYSDATE@! AND ("T1"."TRADENO"='010001' OR"T1"."TRADENO"='010002' OR "T1"."TRADENO"='010003' OR "T1"."TRADENO"='010004' OR "T1"."TRADENO"='010011' OR"T1"."TRADENO"='020043' OR "T1"."TRADENO"='020088' OR "T1"."TRADENO"='030004' OR "T1"."TRADENO"='030219' OR"T1"."TRADENO"='030220' OR "T1"."TRADENO"='030221' OR "T1"."TRADENO"='030222' OR "T1"."TRADENO"='030223' OR"T1"."TRADENO"='030904' OR "T1"."TRADENO"='030908' OR "T1"."TRADENO"='080103' OR "T1"."TRADENO"='080104' OR"T1"."TRADENO"='080108' OR "T1"."TRADENO"='080202' OR "T1"."TRADENO"='080205' OR "T1"."TRADENO"='080206') AND"T1"."TRANSTATE"='4')165 - access("T1"."TRANSACTORGNO"="ORGNO")177 - access("T1"."CCCCNO"="T2"."CCCCNO"(+))178 - access("OT1"."RPTNO"="RPTNO")182 - filter(CASE WHEN ("TB"."QTYPE"='1' AND "TB"."CUSTYPE"='D' ANDROUND("F_EXCHANGERATEUSD_NEW"(TO_DATE('20'||SUBSTR("TB"."RPTNO",13,6),'yyyy-MM-dd'),"TB"."CURSIGN","TB"."AMOUNT"),2)<=5000) THEN "TB"."JCSFYSB"||"TB"."JCSXBZ"||"TB"."JCSFZX"||"TB"."SBSFYSB"||"TB"."SBSXBZ"||"TB"."SBSFZX"||"TB"."HXSFYSB"||"TB"."HXSXBZ"||"TB"."HXSFZX" ELSE 'Y1Y******' END ='Y1Y******' AND CASE WHEN ("TB"."QTYPE"='4'AND "TB"."CUSTYPE"='D' AND ROUND("F_EXCHANGERATEUSD_NEW"(TO_DATE('20'||SUBSTR("TB"."RPTNO",13,6),'yyyy-MM-dd'),"TB"."CURSIGN","TB"."AMOUNT"),2)<=5000) THEN "TB"."JCSFYSB"||"TB"."JCSXBZ"||"TB"."JCSFZX"||"TB"."SBSFYSB"||"TB"."SBSXBZ"||"TB"."SBSFZX"||"TB"."HXSFYSB"||"TB"."HXSXBZ"||"TB"."HXSFZX" ELSE 'Y1Y******' END ='Y1Y******')185 - filter(CASE WHEN '4'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOTNULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END||'*'||'*' ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '4'='2' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN "T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL)THEN "T3"."SFZX" ELSE '*' END ||'*' ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '4'='3' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||'*'||'*' ELSE 'Y1YYYYY' END ='Y1YYYYY'AND CASE WHEN '4'='4' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN"T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||'*'||'*' ELSE'Y1YYY**' END ='Y1YYY**' AND CASE WHEN '4'='5' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN"T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||'*'||'*' ELSE'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '4'='6' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN"T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||'*'||'*' ELSE'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '4'='7' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN"T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||'*'||'*' ELSE'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '4'='8' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN"T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||'*'||'*' ELSE'Y1Y***YY' END ='Y1Y***YY')187 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)188 - access("T2"."BANK_ID"="ORGNO")190 - access("T2"."RPTNO"="T3"."RPTNO"(+))192 - filter(CASE WHEN '6'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN"T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '6'='2' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX"ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '6'='3' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE'*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY'AND CASE WHEN '6'='4' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOTNULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' ENDELSE 'Y1YYY**' END ='Y1YYY**' AND CASE WHEN '6'='5' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB"ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END='Y1Y***YY' AND CASE WHEN '6'='6' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN"T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '6'='7' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB"ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END='Y1Y***YY' AND CASE WHEN '6'='8' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN"T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY')194 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)195 - access("T2"."BANK_ID"="ORGNO")197 - access("T2"."RPTNO"="T3"."RPTNO"(+))199 - filter(CASE WHEN '1'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T4"."SFYSB" IS NOTNULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL)THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '1'='2' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END||CASE WHEN ("T4"."SXBZ" IS NOT NULL) THEN "T4"."SXBZ" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL)THEN "T4"."SFZX" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '1'='3' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN"T4"."SFZX" ELSE '*' END ||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '1'='4'THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*'END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END ||CASE WHEN ("T3"."SFYSB" IS NOTNULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' ENDELSE 'Y1YYY**' END ='Y1YYY**' AND CASE WHEN '1'='5' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SXBZ" IS NOT NULL) THEN"T4"."SXBZ" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END ||CASE WHEN("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN"T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '1'='6' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END||CASE WHEN ("T4"."SXBZ" IS NOT NULL) THEN "T4"."SXBZ" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL)THEN "T4"."SFZX" ELSE '*' END ||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASEWHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN'1'='7' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB"ELSE '*' END ||CASE WHEN ("T4"."SXBZ" IS NOT NULL) THEN "T4"."SXBZ" ELSE '*' END ||CASE WHEN ("T4"."SFZX" ISNOT NULL) THEN "T4"."SFZX" ELSE '*' END ||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASEWHEN '1'='8' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN"T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SXBZ" IS NOT NULL) THEN "T4"."SXBZ" ELSE '*' END ||CASE WHEN("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END ||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN"T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE'Y1Y***YY' END ='Y1Y***YY')202 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)203 - access("T2"."BANK_ID"="ORGNO")205 - access("T2"."RPTNO"="T3"."RPTNO"(+))207 - access("T2"."RPTNO"="T4"."RPTNO"(+))209 - filter(CASE WHEN '5'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN"T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '5'='2' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX"ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '5'='3' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE'*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY'AND CASE WHEN '5'='4' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOTNULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' ENDELSE 'Y1YYY**' END ='Y1YYY**' AND CASE WHEN '5'='5' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB"ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END='Y1Y***YY' AND CASE WHEN '5'='6' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN"T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '5'='7' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB"ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END='Y1Y***YY' AND CASE WHEN '5'='8' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN"T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY')211 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)212 - access("T2"."BANK_ID"="ORGNO")214 - access("T2"."RPTNO"="T3"."RPTNO"(+))216 - filter(CASE WHEN '3'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOTNULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL)THEN "T4"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '3'='2' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN "T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL)THEN "T3"."SFZX" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END ELSE'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '3'='3' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN"T3"."SFZX" ELSE '*' END ||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '3'='4'THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*'END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||CASE WHEN ("T4"."SFYSB" IS NOTNULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*' ENDELSE 'Y1YYY**' END ='Y1YYY**' AND CASE WHEN '3'='5' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN"T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||CASE WHEN("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN"T4"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '3'='6' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN "T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL)THEN "T3"."SFZX" ELSE '*' END ||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END ||CASEWHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN'3'='7' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB"ELSE '*' END ||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN "T3"."SXBZ" ELSE '*' END ||CASE WHEN ("T3"."SFZX" ISNOT NULL) THEN "T3"."SFZX" ELSE '*' END ||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN "T4"."SFYSB" ELSE '*' END||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASEWHEN '3'='8' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN"T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SXBZ" IS NOT NULL) THEN "T3"."SXBZ" ELSE '*' END ||CASE WHEN("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ||CASE WHEN ("T4"."SFYSB" IS NOT NULL) THEN"T4"."SFYSB" ELSE '*' END ||CASE WHEN ("T4"."SFZX" IS NOT NULL) THEN "T4"."SFZX" ELSE '*' END ELSE'Y1Y***YY' END ='Y1Y***YY')219 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)220 - access("T2"."BANK_ID"="ORGNO")222 - access("T2"."RPTNO"="T4"."RPTNO"(+))224 - access("T2"."RPTNO"="T3"."RPTNO"(+))226 - filter(CASE WHEN '2'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN"T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '2'='2' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX"ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '2'='3' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE'*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY'AND CASE WHEN '2'='4' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOTNULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' ENDELSE 'Y1YYY**' END ='Y1YYY**' AND CASE WHEN '2'='5' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB"ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END='Y1Y***YY' AND CASE WHEN '2'='6' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN"T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '2'='7' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB"ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END='Y1Y***YY' AND CASE WHEN '2'='8' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN"T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY')228 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)229 - access("T2"."BANK_ID"="ORGNO")231 - access("T2"."RPTNO"="T3"."RPTNO"(+))233 - filter(CASE WHEN '7'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN"T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '7'='2' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX"ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '7'='3' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE'*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY'AND CASE WHEN '7'='4' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOTNULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' ENDELSE 'Y1YYY**' END ='Y1YYY**' AND CASE WHEN '7'='5' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB"ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END='Y1Y***YY' AND CASE WHEN '7'='6' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN"T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '7'='7' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB"ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END='Y1Y***YY' AND CASE WHEN '7'='8' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN"T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY')235 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)236 - access("T2"."KKKKID"="ORGNO")238 - access("T2"."RPTNO"="T3"."RPTNO"(+))240 - filter(CASE WHEN '8'='1' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN"T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY' AND CASE WHEN '8'='2' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX"ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '8'='3' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE'*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1YYYYY' END ='Y1YYYYY'AND CASE WHEN '8'='4' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOTNULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' ENDELSE 'Y1YYY**' END ='Y1YYY**' AND CASE WHEN '8'='5' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB"ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END='Y1Y***YY' AND CASE WHEN '8'='6' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN"T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY' AND CASE WHEN '8'='7' THEN"T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN ("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB"ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN "T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END='Y1Y***YY' AND CASE WHEN '8'='8' THEN "T2"."SFYSB"||"T2"."SXBZ"||"T2"."SFZX"||'*'||'*'||'*'||CASE WHEN("T3"."SFYSB" IS NOT NULL) THEN "T3"."SFYSB" ELSE '*' END ||CASE WHEN ("T3"."SFZX" IS NOT NULL) THEN"T3"."SFZX" ELSE '*' END ELSE 'Y1Y***YY' END ='Y1Y***YY')242 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T2"."SJLRRQ"),1)>SYSDATE@!)243 - access("T2"."KKKKID"="ORGNO")245 - access("T2"."RPTNO"="T3"."RPTNO"(+))247 - access("TB"."TXNSERIALNO"="T1"."TXNSERIALNO"(+))251 - filter(ADD_MONTHS(INTERNAL_FUNCTION("T1"."INTERETDATE"),1)>SYSDATE@! AND ("T1"."TRADENO"='010001' OR"T1"."TRADENO"='010002' OR "T1"."TRADENO"='010003' OR "T1"."TRADENO"='010004' OR "T1"."TRADENO"='010011' OR"T1"."TRADENO"='020043' OR "T1"."TRADENO"='020088' OR "T1"."TRADENO"='030004' OR "T1"."TRADENO"='030219' OR"T1"."TRADENO"='030220' OR "T1"."TRADENO"='030221' OR "T1"."TRADENO"='030222' OR "T1"."TRADENO"='030223' OR"T1"."TRADENO"='030904' OR "T1"."TRADENO"='030908' OR "T1"."TRADENO"='080103' OR "T1"."TRADENO"='080104' OR"T1"."TRADENO"='080108' OR "T1"."TRADENO"='080202' OR "T1"."TRADENO"='080205' OR "T1"."TRADENO"='080206') AND"T1"."TRANSTATE"='4' AND CASE WHEN (''='1' AND ''='D' ANDROUND("F_EXCHANGERATEUSD_NEW"(TO_DATE('20','yyyy-MM-dd'),"T1"."CURSIGN","T1"."AMOUNT"),2)<=5000) THEN'*********' ELSE 'Y1Y******' END ='Y1Y******' AND CASE WHEN (''='4' AND ''='D' ANDROUND("F_EXCHANGERATEUSD_NEW"(TO_DATE('20','yyyy-MM-dd'),"T1"."CURSIGN","T1"."AMOUNT"),2)<=5000) THEN'*********' ELSE 'Y1Y******' END ='Y1Y******')252 - access("T1"."TRANSACTORGNO"="ORGNO")254 - access("T1"."CCCCNO"="T2"."CCCCNO"(+))257 - access("TT"."RWIDH"="T1"."TXNSERIALNO")258 - access("T3"."RWIDH"="T1"."TXNSERIALNO")259 - access("T4"."RWIDH"="T1"."TXNSERIALNO")260 - access("T5"."RWIDH"="T1"."TXNSERIALNO")261 - access("T6"."RWIDH"="T1"."TXNSERIALNO")262 - access("T7"."RWIDH"="T1"."TXNSERIALNO")263 - access("T8"."RWIDH"="T1"."TXNSERIALNO")264 - access("T9"."RWIDH"="T1"."TXNSERIALNO")265 - filter("STATE"='0')Statistics
----------------------------------------------------------269 recursive calls0 db block gets774 consistent gets0 physical reads0 redo size525 bytes sent via SQL*Net to client520 bytes received via SQL*Net from client2 SQL*Net roundtrips to/from client162 sorts (memory)0 sorts (disk)1 rows processed
'030219', '030220', '030221', '030222', '030223', '030908','010001', '010011', '080108', '080206', '080205', '080202','010003', '010004')
and not exists (select 1 from OWNERR.SB_SSSSSSS tt where t1.txnserialno=tt.rwidh)and not exists (select 1 from OWNERR.sb_CKKKKKK_jnsr t3 where t1.txnserialno=t3.rwidh)and not exists (select 1 from OWNERR.sb_JWWWW t4 where t1.txnserialno=t4.rwidh)and not exists (select 1 from OWNERR.sb_JNNNN t5 where t1.txnserialno=t5.rwidh)and not exists (select 1 from OWNERR.sb_DDDDDDTTS t6 where t1.txnserialno=t6.rwidh)and not exists (select 1 from OWNERR.sb_JNFFFFFFS t7 where t1.txnserialno=t7.rwidh)and not exists (select 1 from OWNERR.sb_ZZZZ t8 where t1.txnserialno=t8.rwidh)and not exists (select 1 from OWNERR.sb_ZHHH t9 where t1.txnserialno=t9.rwidh)and t1.transtate = '4') ot1left join pa_tradetype ot2 on ot1.tradeno = ot2.tradeno;
调整后,sql语句耗时由45.71缩短为0.73,耗时降低98%;逻辑读资源消耗由354584降为774,降低99%
谓词推入见执行计划ID=11 UNION ALL PUSHED PREDICATE
更多推荐
谓词推入的优化案例
发布评论