SQL> select * from table(dbms_xplan.display_cursor('8adsynzgj9j3z',0,'advanced'));
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL_ID 8adsynzgj9j3z, child number 0
-------------------------------------
SELECT to_char(to_date(c.SG2_DEAL_DATE,'yyyymmdd'),'yyyy-mm-dd'),case
when length(decrypt_des(a.user_name,get_secrty_key())) = '2'
then nvl2(decrypt_des(a.user_name,get_secrty_key()),substr(decrypt_des(a.user_name,get_secrty_key()),0,1) || '*', null)
when length(decrypt_des(a.user_name,get_secrty_key())) = '3'
then nvl2(decrypt_des(a.user_name,get_secrty_key()),substr(decrypt_des(a.user_name,get_secrty_key()),0,2) || '*', null)
when length(decrypt_des(a.user_name,get_secrty_key())) >= '4' and instr(decrypt_des(a.user_name,get_secrty_key()),'.',1) > '0'
then nvl2(decrypt_des(a.user_name,get_secrty_key()),substr(decrypt_des(a.user_name,get_secrty_key()),1,instr(decrypt_des(a.user_name,get_secrty_key()),'.',1)-1) || '*', null)
else nvl2(decrypt_des(a.user_name,get_secrty_key()),substr(decrypt_des(a.user_name,get_secrty_key()),0,2) || '**', null)
end,nvl2(a.CERT_ID,substr(decrypt_des(a.CERT_ID,get_secrty_key()),0,4) || '**********' || substr(decrypt_des(a.CERT_ID,get_secrty_key()),15,18), null),b.card_sub_type,c.SG2_CARD_NO,c.SG2_DEAL_FEE/100,to_char(to_date(c.SG2_DEAL_DATE || c.SG2_DEAL_TIME,'YYYYMMDDHH24MISS'),'yyyy-mm-dd hh:mm:ss') time,case when c.err_code = '000000' then '00' else '01' end,c.err_desc,c.merchant_no,c.workdate
FROM yy_user_info a,yy_card_info b,QS_WALLET_HIS c
WHERE to_char(c.workdate,'yyyy-mm-dd') >= to_char(to_date(:1 ,'YYYY-MM-DD'),'YYYY-MM-DD')
AND to_char(c.workdate,'yyyy-mm-dd') <= to_char(to_date(:2 ,'YYYY-MM-DD'),'YYYY-MM-DD')
AND a.user_no(+) = b.user_no
and b.card_no(+) = c.card_no
Plan hash value: 4207760586
-----------------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop |
-----------------------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 1288 (100)| | | |
| 1 | VIEW | VW_TE_2 | 245 | 114K| 1288 (1)| 00:00:16 | | |
| 2 | UNION-ALL | | | | | | | |
|* 3 | FILTER | | | | | | | |
| 4 | NESTED LOOPS OUTER | | 18 | 2898 | 221 (0)| 00:00:03 | | |
| 5 | NESTED LOOPS OUTER | | 18 | 2268 | 218 (1)| 00:00:03 | | |
| 6 | PARTITION RANGE OR | | 18 | 1782 | 182 (1)| 00:00:03 |KEY(OR)|KEY(OR)|
|* 7 | TABLE ACCESS FULL | QS_WALLET_HIS | 18 | 1782 | 182 (1)| 00:00:03 |KEY(OR)|KEY(OR)|
| 8 | TABLE ACCESS BY INDEX ROWID | YY_CARD_INFO | 1 | 27 | 2 (0)| 00:00:01 | | |
|* 9 | INDEX UNIQUE SCAN | CARD_INFO_CARD_N_19360068971 | 1 | | 1 (0)| 00:00:01 | | |
| 10 | TABLE ACCESS BY INDEX ROWID | YY_USER_INFO | 1 | 35 | 1 (0)| 00:00:01 | | |
|* 11 | INDEX UNIQUE SCAN | USER_INFO_USER_N_12285283791 | 1 | | 0 (0)| | | |
| 12 | CONCATENATION | | | | | | | |
|* 13 | FILTER | | | | | | | |
| 14 | NESTED LOOPS OUTER | | 1 | 161 | 7 (0)| 00:00:01 | | |
| 15 | NESTED LOOPS OUTER | | 1 | 126 | 6 (0)| 00:00:01 | | |
| 16 | TABLE ACCESS BY GLOBAL INDEX ROWID| QS_WALLET_HIS | 1 | 99 | 4 (0)| 00:00:01 | 287 | 287 |
|* 17 | INDEX RANGE SCAN | IDX_WORKDATE | 1 | | 3 (0)| 00:00:01 | | |
| 18 | TABLE ACCESS BY INDEX ROWID | YY_CARD_INFO | 1 | 27 | 2 (0)| 00:00:01 | | |
|* 19 | INDEX UNIQUE SCAN | CARD_INFO_CARD_N_19360068971 | 1 | | 1 (0)| 00:00:01 | | |
| 20 | TABLE ACCESS BY INDEX ROWID | YY_USER_INFO | 1 | 35 | 1 (0)| 00:00:01 | | |
|* 21 | INDEX UNIQUE SCAN | USER_INFO_USER_N_12285283791 | 1 | | 0 (0)| | | |
|* 22 | FILTER | | | | | | | |
| 23 | NESTED LOOPS OUTER | | 7 | 1127 | 28 (0)| 00:00:01 | | |
| 24 | NESTED LOOPS OUTER | | 7 | 882 | 26 (0)| 00:00:01 | | |
| 25 | TABLE ACCESS BY GLOBAL INDEX ROWID| QS_WALLET_HIS | 7 | 693 | 12 (0)| 00:00:01 | ROWID | ROWID |
|* 26 | INDEX RANGE SCAN | IDX_WORKDATE | 7 | | 11 (0)| 00:00:01 | | |
| 27 | TABLE ACCESS BY INDEX ROWID | YY_CARD_INFO | 1 | 27 | 2 (0)| 00:00:01 | | |
|* 28 | INDEX UNIQUE SCAN | CARD_INFO_CARD_N_19360068971 | 1 | | 1 (0)| 00:00:01 | | |
| 29 | TABLE ACCESS BY INDEX ROWID | YY_USER_INFO | 1 | 35 | 1 (0)| 00:00:01 | | |
|* 30 | INDEX UNIQUE SCAN | USER_INFO_USER_N_12285283791 | 1 | | 0 (0)| | | |
|* 31 | FILTER | | | | | | | |
| 32 | NESTED LOOPS OUTER | | 21 | 3381 | 79 (0)| 00:00:01 | | |
| 33 | NESTED LOOPS OUTER | | 21 | 2646 | 75 (0)| 00:00:01 | | |
| 34 | TABLE ACCESS BY GLOBAL INDEX ROWID| QS_WALLET_HIS | 21 | 2079 | 33 (0)| 00:00:01 | ROWID | ROWID |
|* 35 | INDEX RANGE SCAN | IDX_WORKDATE | 21 | | 31 (0)| 00:00:01 | | |
| 36 | TABLE ACCESS BY INDEX ROWID | YY_CARD_INFO | 1 | 27 | 2 (0)| 00:00:01 | | |
|* 37 | INDEX UNIQUE SCAN | CARD_INFO_CARD_N_19360068971 | 1 | | 1 (0)| 00:00:01 | | |
| 38 | TABLE ACCESS BY INDEX ROWID | YY_USER_INFO | 1 | 35 | 1 (0)| 00:00:01 | | |
|* 39 | INDEX UNIQUE SCAN | USER_INFO_USER_N_12285283791 | 1 | | 0 (0)| | | |
|* 40 | FILTER | | | | | | | |
| 41 | NESTED LOOPS OUTER | | 20 | 3220 | 80 (0)| 00:00:01 | | |
| 42 | NESTED LOOPS OUTER | | 20 | 2520 | 76 (0)| 00:00:01 | | |
| 43 | TABLE ACCESS BY GLOBAL INDEX ROWID| QS_WALLET_HIS | 20 | 1980 | 36 (0)| 00:00:01 | ROWID | ROWID |
|* 44 | INDEX RANGE SCAN | IDX_WORKDATE | 21 | | 34 (0)| 00:00:01 | | |
| 45 | TABLE ACCESS BY INDEX ROWID | YY_CARD_INFO | 1 | 27 | 2 (0)| 00:00:01 | | |
|* 46 | INDEX UNIQUE SCAN | CARD_INFO_CARD_N_19360068971 | 1 | | 1 (0)| 00:00:01 | | |
| 47 | TABLE ACCESS BY INDEX ROWID | YY_USER_INFO | 1 | 35 | 1 (0)| 00:00:01 | | |
|* 48 | INDEX UNIQUE SCAN | USER_INFO_USER_N_12285283791 | 1 | | 0 (0)| | | |
|* 49 | FILTER | | | | | | | |
| 50 | NESTED LOOPS OUTER | | 17 | 2737 | 75 (0)| 00:00:01 | | |
| 51 | NESTED LOOPS OUTER | | 17 | 2142 | 71 (0)| 00:00:01 | | |
| 52 | TABLE ACCESS BY GLOBAL INDEX ROWID| QS_WALLET_HIS | 17 | 1683 | 37 (0)| 00:00:01 | ROWID | ROWID |
|* 53 | INDEX RANGE SCAN | IDX_WORKDATE | 18 | | 35 (0)| 00:00:01 | | |
| 54 | TABLE ACCESS BY INDEX ROWID | YY_CARD_INFO | 1 | 27 | 2 (0)| 00:00:01 | | |
|* 55 | INDEX UNIQUE SCAN | CARD_INFO_CARD_N_19360068971 | 1 | | 1 (0)| 00:00:01 | | |
| 56 | TABLE ACCESS BY INDEX ROWID | YY_USER_INFO | 1 | 35 | 1 (0)| 00:00:01 | | |
|* 57 | INDEX UNIQUE SCAN | USER_INFO_USER_N_12285283791 | 1 | | 0 (0)| | | |
|* 58 | FILTER | | | | | | | |
| 59 | NESTED LOOPS OUTER | | 29 | 4669 | 131 (1)| 00:00:02 | | |
| 60 | NESTED LOOPS OUTER | | 29 | 3654 | 125 (1)| 00:00:02 | | |
| 61 | TABLE ACCESS BY GLOBAL INDEX ROWID| QS_WALLET_HIS | 29 | 2871 | 67 (2)| 00:00:01 | ROWID | ROWID |
|* 62 | INDEX RANGE SCAN | IDX_WORKDATE | 30 | | 64 (2)| 00:00:01 | | |
| 63 | TABLE ACCESS BY INDEX ROWID | YY_CARD_INFO | 1 | 27 | 2 (0)| 00:00:01 | | |
|* 64 | INDEX UNIQUE SCAN | CARD_INFO_CARD_N_19360068971 | 1 | | 1 (0)| 00:00:01 | | |
| 65 | TABLE ACCESS BY INDEX ROWID | YY_USER_INFO | 1 | 35 | 1 (0)| 00:00:01 | | |
|* 66 | INDEX UNIQUE SCAN | USER_INFO_USER_N_12285283791 | 1 | | 0 (0)| | | |
|* 67 | FILTER | | | | | | | |
| 68 | NESTED LOOPS OUTER | | 132 | 21252 | 666 (1)| 00:00:08 | | |
| 69 | NESTED LOOPS OUTER | | 132 | 16632 | 642 (1)| 00:00:08 | | |
| 70 | TABLE ACCESS BY GLOBAL INDEX ROWID| QS_WALLET_HIS | 132 | 13068 | 378 (1)| 00:00:05 | ROWID | ROWID |
|* 71 | INDEX RANGE SCAN | IDX_WORKDATE | 137 | | 368 (1)| 00:00:05 | | |
| 72 | TABLE ACCESS BY INDEX ROWID | YY_CARD_INFO | 1 | 27 | 2 (0)| 00:00:01 | | |
|* 73 | INDEX UNIQUE SCAN | CARD_INFO_CARD_N_19360068971 | 1 | | 1 (0)| 00:00:01 | | |
| 74 | TABLE ACCESS BY INDEX ROWID | YY_USER_INFO | 1 | 35 | 1 (0)| 00:00:01 | | |
|* 75 | INDEX UNIQUE SCAN | USER_INFO_USER_N_12285283791 | 1 | | 0 (0)| | | |
-----------------------------------------------------------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SET$9833F087 / VW_TE_2@SEL$99C9837B
2 - SET$9833F087
3 - SET$9833F087_1
7 - SET$9833F087_1 / C@SEL$1
8 - SET$9833F087_1 / B@SEL$1
9 - SET$9833F087_1 / B@SEL$1
10 - SET$9833F087_1 / A@SEL$1
11 - SET$9833F087_1 / A@SEL$1
12 - SET$9833F087_2
16 - SET$9833F087_2_1 / C@SEL$1
17 - SET$9833F087_2_1 / C@SEL$1
18 - SET$9833F087_2_1 / B@SEL$1
19 - SET$9833F087_2_1 / B@SEL$1
20 - SET$9833F087_2_1 / A@SEL$1
21 - SET$9833F087_2_1 / A@SEL$1
25 - SET$9833F087_2_2 / C@SET$9833F087_2_2
26 - SET$9833F087_2_2 / C@SET$9833F087_2_2
27 - SET$9833F087_2_2 / B@SET$9833F087_2_2
28 - SET$9833F087_2_2 / B@SET$9833F087_2_2
29 - SET$9833F087_2_2 / A@SET$9833F087_2_2
30 - SET$9833F087_2_2 / A@SET$9833F087_2_2
34 - SET$9833F087_2_3 / C@SET$9833F087_2_3
35 - SET$9833F087_2_3 / C@SET$9833F087_2_3
36 - SET$9833F087_2_3 / B@SET$9833F087_2_3
37 - SET$9833F087_2_3 / B@SET$9833F087_2_3
38 - SET$9833F087_2_3 / A@SET$9833F087_2_3
39 - SET$9833F087_2_3 / A@SET$9833F087_2_3
43 - SET$9833F087_2_4 / C@SET$9833F087_2_4
44 - SET$9833F087_2_4 / C@SET$9833F087_2_4
45 - SET$9833F087_2_4 / B@SET$9833F087_2_4
46 - SET$9833F087_2_4 / B@SET$9833F087_2_4
47 - SET$9833F087_2_4 / A@SET$9833F087_2_4
48 - SET$9833F087_2_4 / A@SET$9833F087_2_4
52 - SET$9833F087_2_5 / C@SET$9833F087_2_5
53 - SET$9833F087_2_5 / C@SET$9833F087_2_5
54 - SET$9833F087_2_5 / B@SET$9833F087_2_5
55 - SET$9833F087_2_5 / B@SET$9833F087_2_5
56 - SET$9833F087_2_5 / A@SET$9833F087_2_5
57 - SET$9833F087_2_5 / A@SET$9833F087_2_5
61 - SET$9833F087_2_6 / C@SET$9833F087_2_6
62 - SET$9833F087_2_6 / C@SET$9833F087_2_6
63 - SET$9833F087_2_6 / B@SET$9833F087_2_6
64 - SET$9833F087_2_6 / B@SET$9833F087_2_6
65 - SET$9833F087_2_6 / A@SET$9833F087_2_6
66 - SET$9833F087_2_6 / A@SET$9833F087_2_6
70 - SET$9833F087_2_7 / C@SET$9833F087_2_7
71 - SET$9833F087_2_7 / C@SET$9833F087_2_7
72 - SET$9833F087_2_7 / B@SET$9833F087_2_7
73 - SET$9833F087_2_7 / B@SET$9833F087_2_7
74 - SET$9833F087_2_7 / A@SET$9833F087_2_7
75 - SET$9833F087_2_7 / A@SET$9833F087_2_7
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('11.2.0.4')
DB_VERSION('11.2.0.4')
OPT_PARAM('_optimizer_extended_cursor_sharing' 'none')
OPT_PARAM('_optimizer_extended_cursor_sharing_rel' 'none')
OPT_PARAM('_optimizer_adaptive_cursor_sharing' 'false')
OPT_PARAM('_optimizer_use_feedback' 'false')
ALL_ROWS
OUTLINE_LEAF(@"SET$9833F087_2")
OUTLINE_LEAF(@"SET$9833F087_1")
OUTLINE_LEAF(@"SET$9833F087")
EXPAND_TABLE(@"SEL$1" "C"@"SEL$1")
OUTLINE_LEAF(@"SEL$99C9837B")
OUTLINE_LEAF(@"SET$9833F087_2_1")
USE_CONCAT(@"SET$9833F087_2" 8 OR_PREDICATES(5) PREDICATE_REORDERS((21 6) (22 7) (23 8) (18 9) (20 10) (19 11) (9 12) (11 13)
(10 14) (17 16) (16 17) (12 18) (14 19) (13 20) (6 21) (8 22) (7 23)))
OUTLINE_LEAF(@"SET$9833F087_2_2")
OUTLINE_LEAF(@"SET$9833F087_2_3")
OUTLINE_LEAF(@"SET$9833F087_2_4")
OUTLINE_LEAF(@"SET$9833F087_2_5")
OUTLINE_LEAF(@"SET$9833F087_2_6")
OUTLINE_LEAF(@"SET$9833F087_2_7")
OUTLINE(@"SET$9833F087")
EXPAND_TABLE(@"SEL$1" "C"@"SEL$1")
OUTLINE(@"SEL$1")
OUTLINE(@"SET$9833F087_2")
NO_ACCESS(@"SEL$99C9837B" "VW_TE_2"@"SEL$99C9837B")
FULL(@"SET$9833F087_1" "C"@"SEL$1")
INDEX_RS_ASC(@"SET$9833F087_1" "B"@"SEL$1" ("YY_CARD_INFO"."CARD_NO"))
INDEX_RS_ASC(@"SET$9833F087_1" "A"@"SEL$1" ("YY_USER_INFO"."USER_NO"))
LEADING(@"SET$9833F087_1" "C"@"SEL$1" "B"@"SEL$1" "A"@"SEL$1")
USE_NL(@"SET$9833F087_1" "B"@"SEL$1")
USE_NL(@"SET$9833F087_1" "A"@"SEL$1")
INDEX_RS_ASC(@"SET$9833F087_2_1" "C"@"SEL$1" ("QS_WALLET_HIS"."WORKDATE"))
INDEX_RS_ASC(@"SET$9833F087_2_1" "B"@"SEL$1" ("YY_CARD_INFO"."CARD_NO"))
INDEX_RS_ASC(@"SET$9833F087_2_1" "A"@"SEL$1" ("YY_USER_INFO"."USER_NO"))
INDEX_RS_ASC(@"SET$9833F087_2_2" "C"@"SET$9833F087_2_2" ("QS_WALLET_HIS"."WORKDATE"))
INDEX_RS_ASC(@"SET$9833F087_2_2" "B"@"SET$9833F087_2_2" ("YY_CARD_INFO"."CARD_NO"))
INDEX_RS_ASC(@"SET$9833F087_2_2" "A"@"SET$9833F087_2_2" ("YY_USER_INFO"."USER_NO"))
INDEX_RS_ASC(@"SET$9833F087_2_3" "C"@"SET$9833F087_2_3" ("QS_WALLET_HIS"."WORKDATE"))
INDEX_RS_ASC(@"SET$9833F087_2_3" "B"@"SET$9833F087_2_3" ("YY_CARD_INFO"."CARD_NO"))
INDEX_RS_ASC(@"SET$9833F087_2_3" "A"@"SET$9833F087_2_3" ("YY_USER_INFO"."USER_NO"))
INDEX_RS_ASC(@"SET$9833F087_2_4" "C"@"SET$9833F087_2_4" ("QS_WALLET_HIS"."WORKDATE"))
INDEX_RS_ASC(@"SET$9833F087_2_4" "B"@"SET$9833F087_2_4" ("YY_CARD_INFO"."CARD_NO"))
INDEX_RS_ASC(@"SET$9833F087_2_4" "A"@"SET$9833F087_2_4" ("YY_USER_INFO"."USER_NO"))
INDEX_RS_ASC(@"SET$9833F087_2_5" "C"@"SET$9833F087_2_5" ("QS_WALLET_HIS"."WORKDATE"))
INDEX_RS_ASC(@"SET$9833F087_2_5" "B"@"SET$9833F087_2_5" ("YY_CARD_INFO"."CARD_NO"))
INDEX_RS_ASC(@"SET$9833F087_2_5" "A"@"SET$9833F087_2_5" ("YY_USER_INFO"."USER_NO"))
INDEX_RS_ASC(@"SET$9833F087_2_6" "C"@"SET$9833F087_2_6" ("QS_WALLET_HIS"."WORKDATE"))
INDEX_RS_ASC(@"SET$9833F087_2_6" "B"@"SET$9833F087_2_6" ("YY_CARD_INFO"."CARD_NO"))
INDEX_RS_ASC(@"SET$9833F087_2_6" "A"@"SET$9833F087_2_6" ("YY_USER_INFO"."USER_NO"))
INDEX_RS_ASC(@"SET$9833F087_2_7" "C"@"SET$9833F087_2_7" ("QS_WALLET_HIS"."WORKDATE"))
INDEX_RS_ASC(@"SET$9833F087_2_7" "B"@"SET$9833F087_2_7" ("YY_CARD_INFO"."CARD_NO"))
INDEX_RS_ASC(@"SET$9833F087_2_7" "A"@"SET$9833F087_2_7" ("YY_USER_INFO"."USER_NO"))
LEADING(@"SET$9833F087_2_1" "C"@"SEL$1" "B"@"SEL$1" "A"@"SEL$1")
LEADING(@"SET$9833F087_2_2" "C"@"SET$9833F087_2_2" "B"@"SET$9833F087_2_2" "A"@"SET$9833F087_2_2")
LEADING(@"SET$9833F087_2_3" "C"@"SET$9833F087_2_3" "B"@"SET$9833F087_2_3" "A"@"SET$9833F087_2_3")
LEADING(@"SET$9833F087_2_4" "C"@"SET$9833F087_2_4" "B"@"SET$9833F087_2_4" "A"@"SET$9833F087_2_4")
LEADING(@"SET$9833F087_2_5" "C"@"SET$9833F087_2_5" "B"@"SET$9833F087_2_5" "A"@"SET$9833F087_2_5")
LEADING(@"SET$9833F087_2_6" "C"@"SET$9833F087_2_6" "B"@"SET$9833F087_2_6" "A"@"SET$9833F087_2_6")
LEADING(@"SET$9833F087_2_7" "C"@"SET$9833F087_2_7" "B"@"SET$9833F087_2_7" "A"@"SET$9833F087_2_7")
USE_NL(@"SET$9833F087_2_1" "B"@"SEL$1")
USE_NL(@"SET$9833F087_2_1" "A"@"SEL$1")
USE_NL(@"SET$9833F087_2_2" "B"@"SET$9833F087_2_2")
USE_NL(@"SET$9833F087_2_2" "A"@"SET$9833F087_2_2")
USE_NL(@"SET$9833F087_2_3" "B"@"SET$9833F087_2_3")
USE_NL(@"SET$9833F087_2_3" "A"@"SET$9833F087_2_3")
USE_NL(@"SET$9833F087_2_4" "B"@"SET$9833F087_2_4")
USE_NL(@"SET$9833F087_2_4" "A"@"SET$9833F087_2_4")
USE_NL(@"SET$9833F087_2_5" "B"@"SET$9833F087_2_5")
USE_NL(@"SET$9833F087_2_5" "A"@"SET$9833F087_2_5")
USE_NL(@"SET$9833F087_2_6" "B"@"SET$9833F087_2_6")
USE_NL(@"SET$9833F087_2_6" "A"@"SET$9833F087_2_6")
USE_NL(@"SET$9833F087_2_7" "B"@"SET$9833F087_2_7")
USE_NL(@"SET$9833F087_2_7" "A"@"SET$9833F087_2_7")
END_OUTLINE_DATA
*/
Predicate Information (identified by operation id):
---------------------------------------------------
3 - filter(TO_CHAR(TO_DATE(:1,'YYYY-MM-DD'),'YYYY-MM-DD')<=TO_CHAR(TO_DATE(:2,'YYYY-MM-DD'),'YYYY-MM-DD'))
7 - filter(((("C"."WORKDATE"<TO_DATE(' 2018-10-09 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "C"."WORKDATE">=TO_DATE('
2018-10-07 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) OR ("C"."WORKDATE"<TO_DATE(' 2018-10-15 00:00:00', 'syyyy-mm-dd hh24:mi:ss')
AND "C"."WORKDATE">=TO_DATE(' 2018-10-14 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) OR ("C"."WORKDATE"<TO_DATE(' 2018-10-30
00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "C"."WORKDATE">=TO_DATE(' 2018-10-28 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) OR
"C"."WORKDATE"<TO_DATE(' 2018-09-19 00:00:00', 'syyyy-mm-dd hh24:mi:ss') OR ("C"."WORKDATE">=TO_DATE(' 2018-12-10 00:00:00',
'syyyy-mm-dd hh24:mi:ss') AND "C"."WORKDATE"<TO_DATE(' 2018-12-26 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) OR
("C"."WORKDATE"<TO_DATE(' 2018-09-26 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "C"."WORKDATE">=TO_DATE(' 2018-09-23 00:00:00',
'syyyy-mm-dd hh24:mi:ss')) OR ("C"."WORKDATE"<TO_DATE(' 2018-10-21 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND
"C"."WORKDATE">=TO_DATE(' 2018-10-20 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) OR "C"."WORKDATE">=TO_DATE(' 2018-12-27 00:00:00',
'syyyy-mm-dd hh24:mi:ss') OR "C"."WORKDATE" IS NULL) AND TO_CHAR(INTERNAL_FUNCTION("C"."WORKDATE"),'yyyy-mm-dd')<=TO_CHAR(TO_DATE
(:2,'YYYY-MM-DD'),'YYYY-MM-DD') AND TO_CHAR(INTERNAL_FUNCTION("C"."WORKDATE"),'yyyy-mm-dd')>=TO_CHAR(TO_DATE(:1,'YYYY-MM-DD'),'YY
YY-MM-DD')))
9 - access("B"."CARD_NO"="C"."CARD_NO")
11 - access("A"."USER_NO"="B"."USER_NO")
13 - filter(TO_CHAR(TO_DATE(:1,'YYYY-MM-DD'),'YYYY-MM-DD')<=TO_CHAR(TO_DATE(:2,'YYYY-MM-DD'),'YYYY-MM-DD'))
17 - access("C"."WORKDATE">=TO_DATE(' 2018-12-26 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "C"."WORKDATE"<TO_DATE(' 2018-12-27
00:00:00', 'syyyy-mm-dd hh24:mi:ss'))
filter((TO_CHAR(INTERNAL_FUNCTION("C"."WORKDATE"),'yyyy-mm-dd')<=TO_CHAR(TO_DATE(:2,'YYYY-MM-DD'),'YYYY-MM-DD') AND
TO_CHAR(INTERNAL_FUNCTION("C"."WORKDATE"),'yyyy-mm-dd')>=TO_CHAR(TO_DATE(:1,'YYYY-MM-DD'),'YYYY-MM-DD')))
19 - access("B"."CARD_NO"="C"."CARD_NO")
21 - access("A"."USER_NO"="B"."USER_NO")
22 - filter(TO_CHAR(TO_DATE(:1,'YYYY-MM-DD'),'YYYY-MM-DD')<=TO_CHAR(TO_DATE(:2,'YYYY-MM-DD'),'YYYY-MM-DD'))
26 - access("C"."WORKDATE">=TO_DATE(' 2018-09-19 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "C"."WORKDATE"<TO_DATE(' 2018-09-23
00:00:00', 'syyyy-mm-dd hh24:mi:ss'))
filter((TO_CHAR(INTERNAL_FUNCTION("C"."WORKDATE"),'yyyy-mm-dd')<=TO_CHAR(TO_DATE(:2,'YYYY-MM-DD'),'YYYY-MM-DD') AND
TO_CHAR(INTERNAL_FUNCTION("C"."WORKDATE"),'yyyy-mm-dd')>=TO_CHAR(TO_DATE(:1,'YYYY-MM-DD'),'YYYY-MM-DD') AND
(LNNVL("C"."WORKDATE">=TO_DATE(' 2018-12-26 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) OR LNNVL("C"."WORKDATE"<TO_DATE(' 2018-12-27
00:00:00', 'syyyy-mm-dd hh24:mi:ss')))))
28 - access("B"."CARD_NO"="C"."CARD_NO")
30 - access("A"."USER_NO"="B"."USER_NO")
31 - filter(TO_CHAR(TO_DATE(:1,'YYYY-MM-DD'),'YYYY-MM-DD')<=TO_CHAR(TO_DATE(:2,'YYYY-MM-DD'),'YYYY-MM-DD'))
35 - access("C"."WORKDATE">=TO_DATE(' 2018-10-09 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "C"."WORKDATE"<TO_DATE(' 2018-10-14
00:00:00', 'syyyy-mm-dd hh24:mi:ss'))
filter((TO_CHAR(INTERNAL_FUNCTION("C"."WORKDATE"),'yyyy-mm-dd')<=TO_CHAR(TO_DATE(:2,'YYYY-MM-DD'),'YYYY-MM-DD') AND
TO_CHAR(INTERNAL_FUNCTION("C"."WORKDATE"),'yyyy-mm-dd')>=TO_CHAR(TO_DATE(:1,'YYYY-MM-DD'),'YYYY-MM-DD') AND
(LNNVL("C"."WORKDATE"<TO_DATE(' 2018-09-23 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) OR LNNVL("C"."WORKDATE">=TO_DATE(' 2018-09-19
00:00:00', 'syyyy-mm-dd hh24:mi:ss'))) AND (LNNVL("C"."WORKDATE">=TO_DATE(' 2018-12-26 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) OR
LNNVL("C"."WORKDATE"<TO_DATE(' 2018-12-27 00:00:00', 'syyyy-mm-dd hh24:mi:ss')))))
37 - access("B"."CARD_NO"="C"."CARD_NO")
39 - access("A"."USER_NO"="B"."USER_NO")
40 - filter(TO_CHAR(TO_DATE(:1,'YYYY-MM-DD'),'YYYY-MM-DD')<=TO_CHAR(TO_DATE(:2,'YYYY-MM-DD'),'YYYY-MM-DD'))
44 - access("C"."WORKDATE">=TO_DATE(' 2018-10-15 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "C"."WORKDATE"<TO_DATE(' 2018-10-20
00:00:00', 'syyyy-mm-dd hh24:mi:ss'))
filter((TO_CHAR(INTERNAL_FUNCTION("C"."WORKDATE"),'yyyy-mm-dd')<=TO_CHAR(TO_DATE(:2,'YYYY-MM-DD'),'YYYY-MM-DD') AND
TO_CHAR(INTERNAL_FUNCTION("C"."WORKDATE"),'yyyy-mm-dd')>=TO_CHAR(TO_DATE(:1,'YYYY-MM-DD'),'YYYY-MM-DD') AND
(LNNVL("C"."WORKDATE"<TO_DATE(' 2018-10-14 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) OR LNNVL("C"."WORKDATE">=TO_DATE(' 2018-10-09
00:00:00', 'syyyy-mm-dd hh24:mi:ss'))) AND (LNNVL("C"."WORKDATE"<TO_DATE(' 2018-09-23 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) OR
LNNVL("C"."WORKDATE">=TO_DATE(' 2018-09-19 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))) AND (LNNVL("C"."WORKDATE">=TO_DATE('
2018-12-26 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) OR LNNVL("C"."WORKDATE"<TO_DATE(' 2018-12-27 00:00:00', 'syyyy-mm-dd
hh24:mi:ss')))))
46 - access("B"."CARD_NO"="C"."CARD_NO")
48 - access("A"."USER_NO"="B"."USER_NO")
49 - filter(TO_CHAR(TO_DATE(:1,'YYYY-MM-DD'),'YYYY-MM-DD')<=TO_CHAR(TO_DATE(:2,'YYYY-MM-DD'),'YYYY-MM-DD'))
53 - access("C"."WORKDATE">=TO_DATE(' 2018-09-26 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "C"."WORKDATE"<TO_DATE(' 2018-10-07
00:00:00', 'syyyy-mm-dd hh24:mi:ss'))
filter((TO_CHAR(INTERNAL_FUNCTION("C"."WORKDATE"),'yyyy-mm-dd')<=TO_CHAR(TO_DATE(:2,'YYYY-MM-DD'),'YYYY-MM-DD') AND
TO_CHAR(INTERNAL_FUNCTION("C"."WORKDATE"),'yyyy-mm-dd')>=TO_CHAR(TO_DATE(:1,'YYYY-MM-DD'),'YYYY-MM-DD') AND
(LNNVL("C"."WORKDATE"<TO_DATE(' 2018-10-20 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) OR LNNVL("C"."WORKDATE">=TO_DATE(' 2018-10-15
00:00:00', 'syyyy-mm-dd hh24:mi:ss'))) AND (LNNVL("C"."WORKDATE"<TO_DATE(' 2018-10-14 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) OR
LNNVL("C"."WORKDATE">=TO_DATE(' 2018-10-09 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))) AND (LNNVL("C"."WORKDATE"<TO_DATE(' 2018-09-23
00:00:00', 'syyyy-mm-dd hh24:mi:ss')) OR LNNVL("C"."WORKDATE">=TO_DATE(' 2018-09-19 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))) AND
(LNNVL("C"."WORKDATE">=TO_DATE(' 2018-12-26 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) OR LNNVL("C"."WORKDATE"<TO_DATE(' 2018-12-27
00:00:00', 'syyyy-mm-dd hh24:mi:ss')))))
55 - access("B"."CARD_NO"="C"."CARD_NO")
57 - access("A"."USER_NO"="B"."USER_NO")
58 - filter(TO_CHAR(TO_DATE(:1,'YYYY-MM-DD'),'YYYY-MM-DD')<=TO_CHAR(TO_DATE(:2,'YYYY-MM-DD'),'YYYY-MM-DD'))
62 - access("C"."WORKDATE">=TO_DATE(' 2018-10-21 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "C"."WORKDATE"<TO_DATE(' 2018-10-28
00:00:00', 'syyyy-mm-dd hh24:mi:ss'))
filter((TO_CHAR(INTERNAL_FUNCTION("C"."WORKDATE"),'yyyy-mm-dd')<=TO_CHAR(TO_DATE(:2,'YYYY-MM-DD'),'YYYY-MM-DD') AND
TO_CHAR(INTERNAL_FUNCTION("C"."WORKDATE"),'yyyy-mm-dd')>=TO_CHAR(TO_DATE(:1,'YYYY-MM-DD'),'YYYY-MM-DD') AND
(LNNVL("C"."WORKDATE"<TO_DATE(' 2018-10-07 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) OR LNNVL("C"."WORKDATE">=TO_DATE(' 2018-09-26
00:00:00', 'syyyy-mm-dd hh24:mi:ss'))) AND (LNNVL("C"."WORKDATE"<TO_DATE(' 2018-10-20 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) OR
LNNVL("C"."WORKDATE">=TO_DATE(' 2018-10-15 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))) AND (LNNVL("C"."WORKDATE"<TO_DATE(' 2018-10-14
00:00:00', 'syyyy-mm-dd hh24:mi:ss')) OR LNNVL("C"."WORKDATE">=TO_DATE(' 2018-10-09 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))) AND
(LNNVL("C"."WORKDATE"<TO_DATE(' 2018-09-23 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) OR LNNVL("C"."WORKDATE">=TO_DATE(' 2018-09-19
00:00:00', 'syyyy-mm-dd hh24:mi:ss'))) AND (LNNVL("C"."WORKDATE">=TO_DATE(' 2018-12-26 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) OR
LNNVL("C"."WORKDATE"<TO_DATE(' 2018-12-27 00:00:00', 'syyyy-mm-dd hh24:mi:ss')))))
64 - access("B"."CARD_NO"="C"."CARD_NO")
66 - access("A"."USER_NO"="B"."USER_NO")
67 - filter(TO_CHAR(TO_DATE(:1,'YYYY-MM-DD'),'YYYY-MM-DD')<=TO_CHAR(TO_DATE(:2,'YYYY-MM-DD'),'YYYY-MM-DD'))
71 - access("C"."WORKDATE">=TO_DATE(' 2018-10-30 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "C"."WORKDATE"<TO_DATE(' 2018-12-10
00:00:00', 'syyyy-mm-dd hh24:mi:ss'))
filter((TO_CHAR(INTERNAL_FUNCTION("C"."WORKDATE"),'yyyy-mm-dd')<=TO_CHAR(TO_DATE(:2,'YYYY-MM-DD'),'YYYY-MM-DD') AND
TO_CHAR(INTERNAL_FUNCTION("C"."WORKDATE"),'yyyy-mm-dd')>=TO_CHAR(TO_DATE(:1,'YYYY-MM-DD'),'YYYY-MM-DD') AND
(LNNVL("C"."WORKDATE"<TO_DATE(' 2018-10-28 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) OR LNNVL("C"."WORKDATE">=TO_DATE(' 2018-10-21
00:00:00', 'syyyy-mm-dd hh24:mi:ss'))) AND (LNNVL("C"."WORKDATE"<TO_DATE(' 2018-10-07 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) OR
LNNVL("C"."WORKDATE">=TO_DATE(' 2018-09-26 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))) AND (LNNVL("C"."WORKDATE"<TO_DATE(' 2018-10-20
00:00:00', 'syyyy-mm-dd hh24:mi:ss')) OR LNNVL("C"."WORKDATE">=TO_DATE(' 2018-10-15 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))) AND
(LNNVL("C"."WORKDATE"<TO_DATE(' 2018-10-14 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) OR LNNVL("C"."WORKDATE">=TO_DATE(' 2018-10-09
00:00:00', 'syyyy-mm-dd hh24:mi:ss'))) AND (LNNVL("C"."WORKDATE"<TO_DATE(' 2018-09-23 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) OR
LNNVL("C"."WORKDATE">=TO_DATE(' 2018-09-19 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))) AND (LNNVL("C"."WORKDATE">=TO_DATE('
2018-12-26 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) OR LNNVL("C"."WORKDATE"<TO_DATE(' 2018-12-27 00:00:00', 'syyyy-mm-dd
hh24:mi:ss')))))
73 - access("B"."CARD_NO"="C"."CARD_NO")
75 - access("A"."USER_NO"="B"."USER_NO")
Column Projection Information (identified by operation id):
-----------------------------------------------------------
1 - "ITEM_1"[CHARACTER,8], "ITEM_2"[VARCHAR2,456], "ITEM_3"[VARCHAR2,100], "ITEM_4"[VARCHAR2,4], "ITEM_5"[VARCHAR2,20],
"ITEM_6"[NUMBER,22], "ITEM_7"[CHARACTER,6], "ITEM_8"[VARCHAR2,8], "ITEM_9"[VARCHAR2,256], "ITEM_10"[VARCHAR2,8],
"ITEM_11"[DATE,7]
2 - STRDEF[8], STRDEF[456], STRDEF[100], STRDEF[4], STRDEF[20], STRDEF[22], STRDEF[6], STRDEF[8], STRDEF[256], STRDEF[8],
STRDEF[7]
3 - "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22], "C"."SG2_DEAL_DATE"[CHARACTER,8],
"C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8], "C"."ERR_DESC"[VARCHAR2,256],
"C"."WORKDATE"[DATE,7], "B"."CARD_SUB_TYPE"[VARCHAR2,4], "A"."USER_NAME"[VARCHAR2,456], "A"."CERT_ID"[VARCHAR2,100]
4 - "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22], "C"."SG2_DEAL_DATE"[CHARACTER,8],
"C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8], "C"."ERR_DESC"[VARCHAR2,256],
"C"."WORKDATE"[DATE,7], "B"."CARD_SUB_TYPE"[VARCHAR2,4], "A"."USER_NAME"[VARCHAR2,456], "A"."CERT_ID"[VARCHAR2,100]
5 - "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22], "C"."SG2_DEAL_DATE"[CHARACTER,8],
"C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8], "C"."ERR_DESC"[VARCHAR2,256],
"C"."WORKDATE"[DATE,7], "B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32]
6 - "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7]
7 - "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7]
8 - "B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32]
9 - "B".ROWID[ROWID,10]
10 - "A"."USER_NAME"[VARCHAR2,456], "A"."CERT_ID"[VARCHAR2,100]
11 - "A".ROWID[ROWID,10]
12 - "C".ROWID[ROWID,10], "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7], "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19],
"B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32], "A".ROWID[ROWID,10], "A"."USER_NO"[VARCHAR2,32],
"A"."USER_NAME"[VARCHAR2,456], "A"."CERT_ID"[VARCHAR2,100]
13 - "C".ROWID[ROWID,10], "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7], "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19],
"B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32], "A".ROWID[ROWID,10], "A"."USER_NO"[VARCHAR2,32],
"A"."USER_NAME"[VARCHAR2,456], "A"."CERT_ID"[VARCHAR2,100]
14 - "C".ROWID[ROWID,10], "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7], "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19],
"B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32], "A".ROWID[ROWID,10], "A"."USER_NO"[VARCHAR2,32],
"A"."USER_NAME"[VARCHAR2,456], "A"."CERT_ID"[VARCHAR2,100]
15 - "C".ROWID[ROWID,10], "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7], "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19],
"B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32]
16 - "C".ROWID[ROWID,10], "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7]
17 - "C".ROWID[ROWID,10], "C"."WORKDATE"[DATE,7]
18 - "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19], "B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32]
19 - "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19]
20 - "A".ROWID[ROWID,10], "A"."USER_NO"[VARCHAR2,32], "A"."USER_NAME"[VARCHAR2,456], "A"."CERT_ID"[VARCHAR2,100]
21 - "A".ROWID[ROWID,10], "A"."USER_NO"[VARCHAR2,32]
22 - "C".ROWID[ROWID,10], "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7], "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19],
"B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32], "A".ROWID[ROWID,10], "A"."USER_NO"[VARCHAR2,32],
"A"."USER_NAME"[VARCHAR2,456], "A"."CERT_ID"[VARCHAR2,100]
23 - "C".ROWID[ROWID,10], "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7], "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19],
"B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32], "A".ROWID[ROWID,10], "A"."USER_NO"[VARCHAR2,32],
"A"."USER_NAME"[VARCHAR2,456], "A"."CERT_ID"[VARCHAR2,100]
24 - "C".ROWID[ROWID,10], "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7], "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19],
"B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32]
25 - "C".ROWID[ROWID,10], "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7]
26 - "C".ROWID[ROWID,10], "C"."WORKDATE"[DATE,7]
27 - "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19], "B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32]
28 - "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19]
29 - "A".ROWID[ROWID,10], "A"."USER_NO"[VARCHAR2,32], "A"."USER_NAME"[VARCHAR2,456], "A"."CERT_ID"[VARCHAR2,100]
30 - "A".ROWID[ROWID,10], "A"."USER_NO"[VARCHAR2,32]
31 - "C".ROWID[ROWID,10], "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7], "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19],
"B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32], "A".ROWID[ROWID,10], "A"."USER_NO"[VARCHAR2,32],
"A"."USER_NAME"[VARCHAR2,456], "A"."CERT_ID"[VARCHAR2,100]
32 - "C".ROWID[ROWID,10], "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7], "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19],
"B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32], "A".ROWID[ROWID,10], "A"."USER_NO"[VARCHAR2,32],
"A"."USER_NAME"[VARCHAR2,456], "A"."CERT_ID"[VARCHAR2,100]
33 - "C".ROWID[ROWID,10], "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7], "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19],
"B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32]
34 - "C".ROWID[ROWID,10], "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7]
35 - "C".ROWID[ROWID,10], "C"."WORKDATE"[DATE,7]
36 - "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19], "B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32]
37 - "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19]
38 - "A".ROWID[ROWID,10], "A"."USER_NO"[VARCHAR2,32], "A"."USER_NAME"[VARCHAR2,456], "A"."CERT_ID"[VARCHAR2,100]
39 - "A".ROWID[ROWID,10], "A"."USER_NO"[VARCHAR2,32]
40 - "C".ROWID[ROWID,10], "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7], "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19],
"B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32], "A".ROWID[ROWID,10], "A"."USER_NO"[VARCHAR2,32],
"A"."USER_NAME"[VARCHAR2,456], "A"."CERT_ID"[VARCHAR2,100]
41 - "C".ROWID[ROWID,10], "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7], "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19],
"B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32], "A".ROWID[ROWID,10], "A"."USER_NO"[VARCHAR2,32],
"A"."USER_NAME"[VARCHAR2,456], "A"."CERT_ID"[VARCHAR2,100]
42 - "C".ROWID[ROWID,10], "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7], "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19],
"B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32]
43 - "C".ROWID[ROWID,10], "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7]
44 - "C".ROWID[ROWID,10], "C"."WORKDATE"[DATE,7]
45 - "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19], "B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32]
46 - "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19]
47 - "A".ROWID[ROWID,10], "A"."USER_NO"[VARCHAR2,32], "A"."USER_NAME"[VARCHAR2,456], "A"."CERT_ID"[VARCHAR2,100]
48 - "A".ROWID[ROWID,10], "A"."USER_NO"[VARCHAR2,32]
49 - "C".ROWID[ROWID,10], "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7], "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19],
"B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32], "A".ROWID[ROWID,10], "A"."USER_NO"[VARCHAR2,32],
"A"."USER_NAME"[VARCHAR2,456], "A"."CERT_ID"[VARCHAR2,100]
50 - "C".ROWID[ROWID,10], "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7], "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19],
"B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32], "A".ROWID[ROWID,10], "A"."USER_NO"[VARCHAR2,32],
"A"."USER_NAME"[VARCHAR2,456], "A"."CERT_ID"[VARCHAR2,100]
51 - "C".ROWID[ROWID,10], "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7], "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19],
"B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32]
52 - "C".ROWID[ROWID,10], "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7]
53 - "C".ROWID[ROWID,10], "C"."WORKDATE"[DATE,7]
54 - "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19], "B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32]
55 - "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19]
56 - "A".ROWID[ROWID,10], "A"."USER_NO"[VARCHAR2,32], "A"."USER_NAME"[VARCHAR2,456], "A"."CERT_ID"[VARCHAR2,100]
57 - "A".ROWID[ROWID,10], "A"."USER_NO"[VARCHAR2,32]
58 - "C".ROWID[ROWID,10], "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7], "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19],
"B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32], "A".ROWID[ROWID,10], "A"."USER_NO"[VARCHAR2,32],
"A"."USER_NAME"[VARCHAR2,456], "A"."CERT_ID"[VARCHAR2,100]
59 - "C".ROWID[ROWID,10], "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7], "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19],
"B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32], "A".ROWID[ROWID,10], "A"."USER_NO"[VARCHAR2,32],
"A"."USER_NAME"[VARCHAR2,456], "A"."CERT_ID"[VARCHAR2,100]
60 - "C".ROWID[ROWID,10], "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7], "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19],
"B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32]
61 - "C".ROWID[ROWID,10], "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7]
62 - "C".ROWID[ROWID,10], "C"."WORKDATE"[DATE,7]
63 - "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19], "B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32]
64 - "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19]
65 - "A".ROWID[ROWID,10], "A"."USER_NO"[VARCHAR2,32], "A"."USER_NAME"[VARCHAR2,456], "A"."CERT_ID"[VARCHAR2,100]
66 - "A".ROWID[ROWID,10], "A"."USER_NO"[VARCHAR2,32]
67 - "C".ROWID[ROWID,10], "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7], "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19],
"B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32], "A".ROWID[ROWID,10], "A"."USER_NO"[VARCHAR2,32],
"A"."USER_NAME"[VARCHAR2,456], "A"."CERT_ID"[VARCHAR2,100]
68 - "C".ROWID[ROWID,10], "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7], "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19],
"B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32], "A".ROWID[ROWID,10], "A"."USER_NO"[VARCHAR2,32],
"A"."USER_NAME"[VARCHAR2,456], "A"."CERT_ID"[VARCHAR2,100]
69 - "C".ROWID[ROWID,10], "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7], "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19],
"B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32]
70 - "C".ROWID[ROWID,10], "C"."CARD_NO"[VARCHAR2,20], "C"."SG2_CARD_NO"[VARCHAR2,20], "C"."SG2_DEAL_FEE"[NUMBER,22],
"C"."SG2_DEAL_DATE"[CHARACTER,8], "C"."SG2_DEAL_TIME"[CHARACTER,6], "C"."MERCHANT_NO"[VARCHAR2,8], "C"."ERR_CODE"[VARCHAR2,8],
"C"."ERR_DESC"[VARCHAR2,256], "C"."WORKDATE"[DATE,7]
71 - "C".ROWID[ROWID,10], "C"."WORKDATE"[DATE,7]
72 - "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19], "B"."CARD_SUB_TYPE"[VARCHAR2,4], "B"."USER_NO"[VARCHAR2,32]
73 - "B".ROWID[ROWID,10], "B"."CARD_NO"[CHARACTER,19]
74 - "A".ROWID[ROWID,10], "A"."USER_NO"[VARCHAR2,32], "A"."USER_NAME"[VARCHAR2,456], "A"."CERT_ID"[VARCHAR2,100]
75 - "A".ROWID[ROWID,10], "A"."USER_NO"[VARCHAR2,32]
WHERE to_char(c.workdate,'yyyy-mm-dd') >= to_char(to_date(:1 ,'YYYY-MM-DD'),'YYYY-MM-DD') AND to_char(c.workdate,'yyyy-mm-dd') <= to_char(to_date(:2 ,'YYYY-MM-DD'),'YYYY-MM-DD')
1、这个C表的数据量有多少，变量带进去的时间区间筛选出来的数据占总数据量多少？
2、workdata字段上是否有索引？
3、写法有问题，直接用时间类型比较即可
评论
有用 0C表有164673条记录 C表workdata上有索引。C表是分区表，根据workdata进行分区的
INDEX_NAME INDEX_TYPE STATUS
------------------------------ --------------------------- --------
IDX_MERCHANT_NO NORMAL VALID
IDX_WORKDATE NORMAL VALID
QS_WALLET_HIS_IDX1 NORMAL N/A
IDX_SG2_DEAL_DATE NORMAL N/A
评论 有用 0变量带进去的时间区间筛选出来的数据占总数据量多少？
--这个不确定的，时间分区是每天一个分区，统计一般是按照一个月，或者几天来统计查询的，查询条件是不一定的。所以数据占比是不确定的
评论 有用 0目前能优化的也就是这个workdate字段了，
1、去掉SQL中的to_char，直接用时间类型比较；或者考虑创建to_char(workdate,’yyyy-mm-dd’)函数索引，（原索引保留，目前是分区键）
2、检查workdate字段上是否有直方图信息，避免变量窥探引起执行计划不准的问题
评论 有用 0
墨值悬赏