MySQL [ens_gl]> explain SELECT GPH.BLORG_NO, GPH.CCY, GPH.CUSTOMER_NO, GPH.SUBJ_NO, GPH.AMT_TYPE, GPH.COR_SEQNO, GPH.ACCTNT_ENTRY_NO, GPH.PRFT_CNTR, GPH.SOURCE_MODULE_TYPE_CD, GPH.QRY_CHNL, GPH.TRANS_SEQ_IDNTFNO, GPH.TRANS_REFCNO, GPH.POST_DT, GPH.BOOKKEEPING_DT, GPH.NARRATIVE, GPH.AMT, GPH.REV_FLAG, GPH.STAT_CD, GPH.ACCTNO_KEYVAL, GPH.BAL_DEAL_FLAG, GPH.PROD_BUSI_EVENT_CD, GPH.PARATYPE_IND, GPH.GL_SYS_RUN_DT, GPH.TRANS_REMARK, GPH.ACCTNT_TERM, GPH.AFLT_LPR_CD, GPH.BASIC_ACCTNO, GPH.ACCTNT_BOOKKEEPING_DBTCRDT_IND, GPH.PRODC_TP, GPH.CHNL_DT, GPH.CLEAR_ENTRY_STANDARD, GPH.CHNL_SEQNO, GPH.MKTG_PROD_NO, GPH.MKTG_PROD_NM, GPH.BUSI_PROD_CD, GPH.INDEX_NO, GPH.DPSTRM_TERM, GPH.TERM_TYPE, GPH.SYS_ID, GPH.TRANS_TELLER, GPH.ACCT_CRSP_CUSTOMER_NO, GPH.COMMN_INDS_CD, GPH.TAILBOX_NO, GPH.CUSTOMER_MGR_NO, GPH.FNDRS_TYPE_CD, GPH.INTAMT_PCSMED_IND, GPH.DRAWINT_FREQ, GPH.TRANS_CD, GPH.TELLER_LANG_CD, GPH.ACCTNT_SQUANACCT_STAC_NO, GPH.MNL_BOOKKEEPING_IND, GPH.COLT_BOOKKEEPING_IND, GPH.CROSYS_DUTY_SYS_NO, GPH.INLAND_OVSEA_IND, GPH.ECON_CMPONT_CD, GPH.STAC_CD, GPH.RULE_NO, GPH.OFBS_SUBJ_FLAG, GPH.TRANS_VARTY_CD, GPH.GRP_INNER_NOS_ORG_NO, NULL AS CUSTOMER_TYPE, GPH.TRANS_TM  FROM GL_POST_HIST GPH  WHERE 1 = 1  AND ( GPH.PTXSP_MID_ENTRY_FLAG = '0' OR GPH.PTXSP_MID_ENTRY_FLAG IS NULL )  AND GPH.BLORG_NO IN ( '0006', '0021', '0812', '1111', '1115', '0111', '0112', '0113', '0132', '0351', '0411', '0412', '0421', '0432', '1011', '1032', '1033', '0211', '0212', '0413', '0431', '0511', '0711', '0712', '0811', '0821', '1022', '1031', '1112', '0121', '0251', '0341', '0422', '0522', '0541', '0751', '0911', '0913', '0916', '0921', '0939', '0115', '0222', '0231', '0551', '0571', '0572', '0721', '0732', '0931', '1113', '1212', '0311', '0331', '0332', '0333', '0441', '0822', '0841', '0842', '0843', '1114', '0513', '0641', '1501', '1502', '1503', '0133', '0232', '0233', '0234', '0512', '0762', '0941', '1012', '1021', '1023', '1211', '0241', '0242', '0761', '0932', '1311', '1312', '1313', '0312', '0321', '0442', '0521', '0523', '0552', '0561', '0611', '0666', '0713', '0722', '0723', '0831', '1362', '1363', '1364', '1365', '1367', '1369', '1370', '1372', '1375', '1378', '0050', '2001', '2002', '2003', '2051', '0051', '2400', '2401', '2402', '2403', '0052', '2200', '2201', '2202', '0053', '2600', '2601', '0054', '2800', '2801', '0055', '2900', '0001', '0003', '0004', '0005', '0007', '0008', '0011', '0016', '0019', '0020', '0022', '1358', '1359', '2203', '9000', '9001', '9002', '9003', '9004', '9005', '1360', '1361', '1397', '0000'  )  AND GPH.CCY = 'CNY'  AND GPH.SUBJ_NO NOT IN ( '99999999' )  AND GPH.POST_DT >= '2024-08-19'  AND GPH.POST_DT <= '2024-09-17' AND GPH.AMT >= 4999  AND GPH.AMT <= 4999  AND GPH.REV_FLAG != 'X'  AND ( GPH.CLEAR_ENTRY_STANDARD != 'Y' OR GPH.CLEAR_ENTRY_STANDARD IS NULL ) UNION ALL SELECT BGPH.BLORG_NO, BGPH.CCY, BGPH.CUSTOMER_NO, BGPH.SUBJ_NO, BGPH.AMT_TYPE, BGPH.COR_SEQNO, BGPH.ACCTNT_ENTRY_NO, BGPH.PRFT_CNTR, BGPH.SOURCE_MODULE_TYPE_CD, BGPH.QRY_CHNL, BGPH.TRANS_SEQ_IDNTFNO, BGPH.TRANS_REFCNO, BGPH.POST_DT, BGPH.BOOKKEEPING_DT, BGPH.NARRATIVE, BGPH.AMT, BGPH.REV_FLAG, BGPH.STAT_CD, BGPH.ACCTNO_KEYVAL, BGPH.BAL_DEAL_FLAG, BGPH.PROD_BUSI_EVENT_CD, BGPH.PARATYPE_IND, BGPH.GL_SYS_RUN_DT, BGPH.TRANS_REMARK, BGPH.ACCTNT_TERM, BGPH.AFLT_LPR_CD, BGPH.BASIC_ACCTNO, BGPH.ACCTNT_BOOKKEEPING_DBTCRDT_IND, BGPH.PRODC_TP, BGPH.CHNL_DT, BGPH.CLEAR_ENTRY_STANDARD, BGPH.CHNL_SEQNO, BGPH.MKTG_PROD_NO, BGPH.MKTG_PROD_NM, BGPH.BUSI_PROD_CD, BGPH.INDEX_NO, BGPH.DPSTRM_TERM, BGPH.TERM_TYPE, BGPH.SYS_ID, BGPH.TRANS_TELLER, BGPH.ACCT_CRSP_CUSTOMER_NO, BGPH.COMMN_INDS_CD, BGPH.CUSTOMER_MGR_NO, BGPH.TAILBOX_NO, BGPH.FNDRS_TYPE_CD, BGPH.INTAMT_PCSMED_IND, BGPH.DRAWINT_FREQ, BGPH.TRANS_CD, BGPH.TELLER_LANG_CD, BGPH.ACCTNT_SQUANACCT_STAC_NO, BGPH.MNL_BOOKKEEPING_IND, BGPH.COLT_BOOKKEEPING_IND, BGPH.CROSYS_DUTY_SYS_NO, BGPH.INLAND_OVSEA_IND, BGPH.ECON_CMPONT_CD, BGPH.STAC_CD, BGPH.RULE_NO, BGPH.OFBS_SUBJ_FLAG, BGPH.TRANS_VARTY_CD, BGPH.GRP_INNER_NOS_ORG_NO, BGPH.CUSTOMER_TYPE, BGPH.TRANS_TM  FROM BS_GL_POST_HIST BGPH  WHERE 1 = 1  AND ( BGPH.PTXSP_MID_ENTRY_FLAG = '0' OR BGPH.PTXSP_MID_ENTRY_FLAG IS NULL )  AND BGPH.BLORG_NO IN ( '0006', '0021', '0812', '1111', '1115', '0111', '0112', '0113', '0132', '0351', '0411', '0412', '0421', '0432', '1011', '1032', '1033', '0211', '0212', '0413', '0431', '0511', '0711', '0712', '0811', '0821', '1022', '1031', '1112', '0121', '0251', '0341', '0422', '0522', '0541', '0751', '0911', '0913', '0916', '0921', '0939', '0115', '0222', '0231', '0551', '0571', '0572', '0721', '0732', '0931', '1113', '1212', '0311', '0331', '0332', '0333', '0441', '0822', '0841', '0842', '0843', '1114', '0513', '0641', '1501', '1502', '1503', '0133', '0232', '0233', '0234', '0512', '0762', '0941', '1012', '1021', '1023', '1211', '0241', '0242', '0761', '0932', '1311', '1312', '1313', '0312', '0321', '0442', '0521', '0523', '0552', '0561', '0611', '0666', '0713', '0722', '0723', '0831', '1362', '1363', '1364', '1365', '1367', '1369', '1370', '1372', '1375', '1378', '0050', '2001', '2002', '2003', '2051', '0051', '2400', '2401', '2402', '2403', '0052', '2200', '2201', '2202', '0053', '2600', '2601', '0054', '2800', '2801', '0055', '2900', '0001', '0003', '0004', '0005', '0007', '0008', '0011', '0016', '0019', '0020', '0022', '1358', '1359', '2203', '9000', '9001', '9002', '9003', '9004', '9005', '1360', '1361', '1397', '0000'  )  AND BGPH.CCY = 'CNY'  AND BGPH.SUBJ_NO NOT IN ( '99999999' )  AND BGPH.POST_DT >= '2024-08-19'  AND BGPH.POST_DT <= '2024-09-17' AND BGPH.AMT >= 4999  AND BGPH.AMT <= 4999  AND BGPH.REV_FLAG != 'X'  AND ( BGPH.CLEAR_ENTRY_STANDARD != 'Y' OR BGPH.CLEAR_ENTRY_STANDARD IS NULL );
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Query Plan                                                                                                                                                                                |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| =====================================================================                                                                                                                     |
| |ID|OPERATOR          |NAME                   |EST.ROWS|EST.TIME(us)|                                                                                                                     |
| ---------------------------------------------------------------------                                                                                                                     |
| |0 |UNION ALL         |                       |4       |2696368     |                                                                                                                     |
| |1 |├─TABLE RANGE SCAN|GPH(GL_POST_HIST_IND2M)|1       |4           |                                                                                                                     |
| |2 |└─TABLE FULL SCAN |BGPH                   |4       |2696364     |                                                                                                                     |
| =====================================================================                                                                                                                     |
| Outputs & filters:                                                                                                                                                                        |
| -------------------------------------                                                                                                                                                     |
|   0 - output([UNION([1])], [UNION([2])], [UNION([3])], [UNION([4])], [UNION([5])], [UNION([6])], [UNION([7])], [UNION([8])], [UNION([9])], [UNION([10])],                                 |
|        [UNION([11])], [UNION([12])], [UNION([13])], [UNION([14])], [UNION([15])], [UNION([16])], [UNION([17])], [UNION([18])], [UNION([19])], [UNION([20])], [UNION([21])],               |
|        [UNION([22])], [UNION([23])], [UNION([24])], [UNION([25])], [UNION([26])], [UNION([27])], [UNION([28])], [UNION([29])], [UNION([30])], [UNION([31])], [UNION([32])],               |
|        [UNION([33])], [UNION([34])], [UNION([35])], [UNION([36])], [UNION([37])], [UNION([38])], [UNION([39])], [UNION([40])], [UNION([41])], [UNION([42])], [UNION([43])],               |
|        [UNION([44])], [UNION([45])], [UNION([46])], [UNION([47])], [UNION([48])], [UNION([49])], [UNION([50])], [UNION([51])], [UNION([52])], [UNION([53])], [UNION([54])],               |
|        [UNION([55])], [UNION([56])], [UNION([57])], [UNION([58])], [UNION([59])], [UNION([60])], [UNION([61])], [UNION([62])]), filter(nil), rowset=16                                    |
|   1 - output([GPH.BLORG_NO], [GPH.CCY], [GPH.CUSTOMER_NO], [GPH.SUBJ_NO], [GPH.AMT_TYPE], [GPH.COR_SEQNO], [GPH.ACCTNT_ENTRY_NO], [GPH.PRFT_CNTR], [GPH.SOURCE_MODULE_TYPE_CD],           |
|        [GPH.QRY_CHNL], [GPH.TRANS_SEQ_IDNTFNO], [GPH.TRANS_REFCNO], [GPH.POST_DT], [GPH.BOOKKEEPING_DT], [GPH.NARRATIVE], [GPH.AMT], [GPH.REV_FLAG], [GPH.STAT_CD],                       |
|        [GPH.ACCTNO_KEYVAL], [GPH.BAL_DEAL_FLAG], [GPH.PROD_BUSI_EVENT_CD], [GPH.PARATYPE_IND], [GPH.GL_SYS_RUN_DT], [GPH.TRANS_REMARK], [GPH.ACCTNT_TERM], [GPH.AFLT_LPR_CD],             |
|        [GPH.BASIC_ACCTNO], [GPH.ACCTNT_BOOKKEEPING_DBTCRDT_IND], [GPH.PRODC_TP], [GPH.CHNL_DT], [GPH.CLEAR_ENTRY_STANDARD], [GPH.CHNL_SEQNO], [GPH.MKTG_PROD_NO],                         |
|        [GPH.MKTG_PROD_NM], [GPH.BUSI_PROD_CD], [GPH.INDEX_NO], [GPH.DPSTRM_TERM], [GPH.TERM_TYPE], [GPH.SYS_ID], [GPH.TRANS_TELLER], [GPH.ACCT_CRSP_CUSTOMER_NO],                         |
|        [GPH.COMMN_INDS_CD], [GPH.TAILBOX_NO], [GPH.CUSTOMER_MGR_NO], [GPH.FNDRS_TYPE_CD], [GPH.INTAMT_PCSMED_IND], [GPH.DRAWINT_FREQ], [GPH.TRANS_CD], [GPH.TELLER_LANG_CD],              |
|        [GPH.ACCTNT_SQUANACCT_STAC_NO], [GPH.MNL_BOOKKEEPING_IND], [GPH.COLT_BOOKKEEPING_IND], [GPH.CROSYS_DUTY_SYS_NO], [GPH.INLAND_OVSEA_IND], [GPH.ECON_CMPONT_CD],                     |
|        [GPH.STAC_CD], [GPH.RULE_NO], [GPH.OFBS_SUBJ_FLAG], [GPH.TRANS_VARTY_CD], [GPH.GRP_INNER_NOS_ORG_NO], [cast(NULL, VARCHAR(6))], [GPH.TRANS_TM]), filter([GPH.AMT                   |
|       >= cast(4999, DECIMAL(4, 0))], [GPH.AMT <= cast(4999, DECIMAL(4, 0))], [GPH.SUBJ_NO != '99999999'], [GPH.REV_FLAG != 'X'], [GPH.CLEAR_ENTRY_STANDARD !=                             |
|       'Y' OR GPH.CLEAR_ENTRY_STANDARD IS NULL], [GPH.PTXSP_MID_ENTRY_FLAG = '0' OR GPH.PTXSP_MID_ENTRY_FLAG IS NULL], [GPH.BLORG_NO IN ('0006', '0021', '0812',                           |
|        '1111', '1115', '0111', '0112', '0113', '0132', '0351', '0411', '0412', '0421', '0432', '1011', '1032', '1033', '0211', '0212', '0413', '0431', '0511',                            |
|        '0711', '0712', '0811', '0821', '1022', '1031', '1112', '0121', '0251', '0341', '0422', '0522', '0541', '0751', '0911', '0913', '0916', '0921', '0939',                            |
|        '0115', '0222', '0231', '0551', '0571', '0572', '0721', '0732', '0931', '1113', '1212', '0311', '0331', '0332', '0333', '0441', '0822', '0841', '0842',                            |
|        '0843', '1114', '0513', '0641', '1501', '1502', '1503', '0133', '0232', '0233', '0234', '0512', '0762', '0941', '1012', '1021', '1023', '1211', '0241',                            |
|        '0242', '0761', '0932', '1311', '1312', '1313', '0312', '0321', '0442', '0521', '0523', '0552', '0561', '0611', '0666', '0713', '0722', '0723', '0831',                            |
|        '1362', '1363', '1364', '1365', '1367', '1369', '1370', '1372', '1375', '1378', '0050', '2001', '2002', '2003', '2051', '0051', '2400', '2401', '2402',                            |
|        '2403', '0052', '2200', '2201', '2202', '0053', '2600', '2601', '0054', '2800', '2801', '0055', '2900', '0001', '0003', '0004', '0005', '0007', '0008',                            |
|        '0011', '0016', '0019', '0020', '0022', '1358', '1359', '2203', '9000', '9001', '9002', '9003', '9004', '9005', '1360', '1361', '1397', '0000')], [GPH.CCY                         |
|       = 'CNY']), rowset=16                                                                                                                                                                |
|       access([GPH.INDEX_NO], [GPH.BLORG_NO], [GPH.PTXSP_MID_ENTRY_FLAG], [GPH.CCY], [GPH.SUBJ_NO], [GPH.POST_DT], [GPH.AMT], [GPH.REV_FLAG], [GPH.CLEAR_ENTRY_STANDARD],                  |
|        [GPH.CUSTOMER_NO], [GPH.AMT_TYPE], [GPH.COR_SEQNO], [GPH.ACCTNT_ENTRY_NO], [GPH.PRFT_CNTR], [GPH.SOURCE_MODULE_TYPE_CD], [GPH.QRY_CHNL], [GPH.TRANS_SEQ_IDNTFNO],                  |
|        [GPH.TRANS_REFCNO], [GPH.BOOKKEEPING_DT], [GPH.NARRATIVE], [GPH.STAT_CD], [GPH.ACCTNO_KEYVAL], [GPH.BAL_DEAL_FLAG], [GPH.PROD_BUSI_EVENT_CD], [GPH.PARATYPE_IND],                  |
|        [GPH.GL_SYS_RUN_DT], [GPH.TRANS_REMARK], [GPH.ACCTNT_TERM], [GPH.AFLT_LPR_CD], [GPH.BASIC_ACCTNO], [GPH.ACCTNT_BOOKKEEPING_DBTCRDT_IND], [GPH.PRODC_TP],                           |
|        [GPH.CHNL_DT], [GPH.CHNL_SEQNO], [GPH.MKTG_PROD_NO], [GPH.MKTG_PROD_NM], [GPH.BUSI_PROD_CD], [GPH.DPSTRM_TERM], [GPH.TERM_TYPE], [GPH.SYS_ID], [GPH.TRANS_TELLER],                 |
|        [GPH.ACCT_CRSP_CUSTOMER_NO], [GPH.COMMN_INDS_CD], [GPH.TAILBOX_NO], [GPH.CUSTOMER_MGR_NO], [GPH.FNDRS_TYPE_CD], [GPH.INTAMT_PCSMED_IND], [GPH.DRAWINT_FREQ],                       |
|        [GPH.TRANS_CD], [GPH.TELLER_LANG_CD], [GPH.ACCTNT_SQUANACCT_STAC_NO], [GPH.MNL_BOOKKEEPING_IND], [GPH.COLT_BOOKKEEPING_IND], [GPH.CROSYS_DUTY_SYS_NO],                             |
|       [GPH.INLAND_OVSEA_IND], [GPH.ECON_CMPONT_CD], [GPH.STAC_CD], [GPH.RULE_NO], [GPH.OFBS_SUBJ_FLAG], [GPH.TRANS_VARTY_CD], [GPH.GRP_INNER_NOS_ORG_NO], [GPH.TRANS_TM]), partitions(p0) |
|       is_index_back=true, is_global_index=false, filter_before_indexback[false,false,true,false,false,false,true,false],                                                                  |
|       range_key([GPH.POST_DT], [GPH.BLORG_NO], [GPH.SUBJ_NO], [GPH.INDEX_NO]), range(2024-08-19,0000,NULL,MAX ; 2024-09-17,9005,MAX,MAX),                                                 |
|       range_cond([cast(GPH.POST_DT, DATETIME(-1, -1)) >= INTERNAL_FUNCTION('2024-08-19', 114, 17)], [cast(GPH.POST_DT, DATETIME(-1, -1)) <= INTERNAL_FUNCTION('2024-09-17',               |
|        112, 17)])                                                                                                                                                                         |
|   2 - output([BGPH.BLORG_NO], [BGPH.CCY], [BGPH.CUSTOMER_NO], [BGPH.SUBJ_NO], [BGPH.AMT_TYPE], [BGPH.COR_SEQNO], [BGPH.ACCTNT_ENTRY_NO], [BGPH.PRFT_CNTR],                                |
|        [BGPH.SOURCE_MODULE_TYPE_CD], [BGPH.QRY_CHNL], [BGPH.TRANS_SEQ_IDNTFNO], [BGPH.TRANS_REFCNO], [BGPH.POST_DT], [BGPH.BOOKKEEPING_DT], [BGPH.NARRATIVE],                             |
|       [BGPH.AMT], [BGPH.REV_FLAG], [BGPH.STAT_CD], [BGPH.ACCTNO_KEYVAL], [BGPH.BAL_DEAL_FLAG], [BGPH.PROD_BUSI_EVENT_CD], [BGPH.PARATYPE_IND], [BGPH.GL_SYS_RUN_DT],                      |
|        [BGPH.TRANS_REMARK], [BGPH.ACCTNT_TERM], [BGPH.AFLT_LPR_CD], [BGPH.BASIC_ACCTNO], [BGPH.ACCTNT_BOOKKEEPING_DBTCRDT_IND], [BGPH.PRODC_TP], [BGPH.CHNL_DT],                          |
|        [BGPH.CLEAR_ENTRY_STANDARD], [BGPH.CHNL_SEQNO], [BGPH.MKTG_PROD_NO], [BGPH.MKTG_PROD_NM], [BGPH.BUSI_PROD_CD], [BGPH.INDEX_NO], [BGPH.DPSTRM_TERM], [BGPH.TERM_TYPE],              |
|        [BGPH.SYS_ID], [BGPH.TRANS_TELLER], [BGPH.ACCT_CRSP_CUSTOMER_NO], [BGPH.COMMN_INDS_CD], [BGPH.CUSTOMER_MGR_NO], [BGPH.TAILBOX_NO], [BGPH.FNDRS_TYPE_CD],                           |
|        [BGPH.INTAMT_PCSMED_IND], [BGPH.DRAWINT_FREQ], [BGPH.TRANS_CD], [BGPH.TELLER_LANG_CD], [BGPH.ACCTNT_SQUANACCT_STAC_NO], [BGPH.MNL_BOOKKEEPING_IND], [BGPH.COLT_BOOKKEEPING_IND],   |
|        [BGPH.CROSYS_DUTY_SYS_NO], [BGPH.INLAND_OVSEA_IND], [BGPH.ECON_CMPONT_CD], [BGPH.STAC_CD], [BGPH.RULE_NO], [BGPH.OFBS_SUBJ_FLAG], [BGPH.TRANS_VARTY_CD],                           |
|        [BGPH.GRP_INNER_NOS_ORG_NO], [BGPH.CUSTOMER_TYPE], [BGPH.TRANS_TM]), filter([cast(BGPH.POST_DT, DATETIME(-1, -1)) >= INTERNAL_FUNCTION('2024-08-19', 114,                          |
|        17)], [BGPH.AMT >= cast(4999, DECIMAL(4, 0))], [BGPH.AMT <= cast(4999, DECIMAL(4, 0))], [cast(BGPH.POST_DT, DATETIME(-1, -1)) <= INTERNAL_FUNCTION('2024-09-17',                   |
|        112, 17)], [BGPH.SUBJ_NO != '99999999'], [BGPH.CLEAR_ENTRY_STANDARD != 'Y' OR BGPH.CLEAR_ENTRY_STANDARD IS NULL], [BGPH.CCY = 'CNY'], [BGPH.REV_FLAG !=                            |
|       'X'], [BGPH.PTXSP_MID_ENTRY_FLAG = '0' OR BGPH.PTXSP_MID_ENTRY_FLAG IS NULL], [BGPH.BLORG_NO IN ('0006', '0021', '0812', '1111', '1115', '0111', '0112',                            |
|        '0113', '0132', '0351', '0411', '0412', '0421', '0432', '1011', '1032', '1033', '0211', '0212', '0413', '0431', '0511', '0711', '0712', '0811', '0821',                            |
|        '1022', '1031', '1112', '0121', '0251', '0341', '0422', '0522', '0541', '0751', '0911', '0913', '0916', '0921', '0939', '0115', '0222', '0231', '0551',                            |
|        '0571', '0572', '0721', '0732', '0931', '1113', '1212', '0311', '0331', '0332', '0333', '0441', '0822', '0841', '0842', '0843', '1114', '0513', '0641',                            |
|        '1501', '1502', '1503', '0133', '0232', '0233', '0234', '0512', '0762', '0941', '1012', '1021', '1023', '1211', '0241', '0242', '0761', '0932', '1311',                            |
|        '1312', '1313', '0312', '0321', '0442', '0521', '0523', '0552', '0561', '0611', '0666', '0713', '0722', '0723', '0831', '1362', '1363', '1364', '1365',                            |
|        '1367', '1369', '1370', '1372', '1375', '1378', '0050', '2001', '2002', '2003', '2051', '0051', '2400', '2401', '2402', '2403', '0052', '2200', '2201',                            |
|        '2202', '0053', '2600', '2601', '0054', '2800', '2801', '0055', '2900', '0001', '0003', '0004', '0005', '0007', '0008', '0011', '0016', '0019', '0020',                            |
|        '0022', '1358', '1359', '2203', '9000', '9001', '9002', '9003', '9004', '9005', '1360', '1361', '1397', '0000')]), rowset=16                                                       |
|       access([BGPH.INDEX_NO], [BGPH.BLORG_NO], [BGPH.PTXSP_MID_ENTRY_FLAG], [BGPH.CCY], [BGPH.SUBJ_NO], [BGPH.POST_DT], [BGPH.AMT], [BGPH.REV_FLAG], [BGPH.CLEAR_ENTRY_STANDARD],         |
|        [BGPH.CUSTOMER_NO], [BGPH.AMT_TYPE], [BGPH.COR_SEQNO], [BGPH.ACCTNT_ENTRY_NO], [BGPH.PRFT_CNTR], [BGPH.SOURCE_MODULE_TYPE_CD], [BGPH.QRY_CHNL], [BGPH.TRANS_SEQ_IDNTFNO],          |
|        [BGPH.TRANS_REFCNO], [BGPH.BOOKKEEPING_DT], [BGPH.NARRATIVE], [BGPH.STAT_CD], [BGPH.ACCTNO_KEYVAL], [BGPH.BAL_DEAL_FLAG], [BGPH.PROD_BUSI_EVENT_CD], [BGPH.PARATYPE_IND],          |
|        [BGPH.GL_SYS_RUN_DT], [BGPH.TRANS_REMARK], [BGPH.ACCTNT_TERM], [BGPH.AFLT_LPR_CD], [BGPH.BASIC_ACCTNO], [BGPH.ACCTNT_BOOKKEEPING_DBTCRDT_IND], [BGPH.PRODC_TP],                    |
|        [BGPH.CHNL_DT], [BGPH.CHNL_SEQNO], [BGPH.MKTG_PROD_NO], [BGPH.MKTG_PROD_NM], [BGPH.BUSI_PROD_CD], [BGPH.DPSTRM_TERM], [BGPH.TERM_TYPE], [BGPH.SYS_ID],                             |
|       [BGPH.TRANS_TELLER], [BGPH.ACCT_CRSP_CUSTOMER_NO], [BGPH.COMMN_INDS_CD], [BGPH.CUSTOMER_MGR_NO], [BGPH.TAILBOX_NO], [BGPH.FNDRS_TYPE_CD], [BGPH.INTAMT_PCSMED_IND],                 |
|        [BGPH.DRAWINT_FREQ], [BGPH.TRANS_CD], [BGPH.TELLER_LANG_CD], [BGPH.ACCTNT_SQUANACCT_STAC_NO], [BGPH.MNL_BOOKKEEPING_IND], [BGPH.COLT_BOOKKEEPING_IND],                             |
|       [BGPH.CROSYS_DUTY_SYS_NO], [BGPH.INLAND_OVSEA_IND], [BGPH.ECON_CMPONT_CD], [BGPH.STAC_CD], [BGPH.RULE_NO], [BGPH.OFBS_SUBJ_FLAG], [BGPH.TRANS_VARTY_CD],                            |
|        [BGPH.GRP_INNER_NOS_ORG_NO], [BGPH.CUSTOMER_TYPE], [BGPH.TRANS_TM]), partitions(p0)                                                                                                |
|       is_index_back=false, is_global_index=false, filter_before_indexback[false,false,false,false,false,false,false,false,false,false],                                                   |
|       range_key([BGPH.INDEX_NO], [BGPH.BLORG_NO], [BGPH.BCKUP_DT]), range(MIN,MIN,MIN ; MAX,MAX,MAX)always true                                                                           |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
77 rows in set (0.035 sec)