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)