We're running a 4 file join on a set of parquet files, the largest of which is
about 20 GB in size. The query plan seems to indicate that most, if not all the
time for the query (>30 minutes) is spent on the first two major fragments. The
physical plan looks like the output for these 2 fragments below. I am not sure
how to best interpret the results to optimize the query. It's pretty clear
based on the plan output as well as the actual system resources utilized during
execution that we are not CPU, Memory or I/O bound. That doesn't leave a whole
lot left to chase down. Any suggestions on where to look?
00-00 Screen : rowType = RecordType(ANY ACTION, ANY ID_TRAN_COLL,
ANY ID_ACC, ANY ID_IMNT_STD, ANY CD_TYP_PSN, ANY DT_ACQS, ANY CD_TX_ACQS, ANY
DMT_FED_COST_ACQ_PSN, ANY QY_SETT, ANY DMT_FED_COST_SETT_LCL, ANY
DMT_UNIT_SETT_PSN, ANY QY_TOT, ANY DMT_FED_COST_TOT_CLNT, ANY
DMT_FED_COST_TOT_LCL, ANY DMT_UNIT_TOT_PSN, ANY TRD_FEDERAL_TAX_COST_LOCL, ANY
SET_FEDERAL_TAX_COST_LOCL, ANY DMT_TRD_GIFT_DATE, ANY DMT_TRD_FMKT_VAL_LOCL,
ANY DMT_TRD_FMKT_VAL_BASE, ANY DMT_SET_GIFT_DATE, ANY DMT_SET_FMKT_VAL_LOCL,
ANY DMT_SET_FMKT_VAL_BASE, ANY DMT_TRD_LOT_LEVEL_COV_IND, ANY
DMT_SET_LOT_LEVEL_COV_IND, ANY DMT_TRD_TRANSFER_CODE, ANY
DMT_SET_TRANSFER_CODE, ANY DMT_TRD_WASH_SALE_ACQ_DATE, ANY
DMT_SET_WASH_SALE_ACQ_DATE, ANY DMT_TRD_LOT_DISALLOWED_DAYS, ANY
DMT_SET_LOT_DISALLOWED_DAYS, ANY DMT_TRD_LOT_FMKT_USAGE_IND, ANY
DMT_SET_LOT_FMKT_USAGE_IND, ANY DMT_SET_UGL_ST, ANY DMT_SET_UGL_ST_LCL, ANY
DMT_SET_UGL_LT, ANY DMT_SET_UGL_LT_LCL, ANY DMT_TRD_UGL_ST, ANY
DMT_TRD_UGL_ST_LCL, ANY DMT_TRD_UGL_LT, ANY DMT_TRD_UGL_LT_LCL, ANY ID_ACC_ALT,
ANY CD_MTH_CSTNG, ANY CD_CCY_TRD_PRIM, ANY RT_SPOT, ANY
IMNT_CLSS_PRICE_FCTR_RT, ANY ID_IMNT_CL, ANY DMT_TOT_MV_PSN, ANY TRD_INT_LOCL,
ANY DMT_INCM_EXPCTD, ANY DMT_SETT_MV_PSN, ANY CD_CL_OMNI): rowcount =
4.0612884300000004E7, cumulative cost = {7.330557446299999E8 rows,
1.5711522516974182E10 cpu, 0.0 io, 2.5162863282995203E13 network,
1.7235157009600002E10 memory}, id = 117134 00-01 Project(ACTION=[$0],
ID_TRAN_COLL=[$1], ID_ACC=[$2], ID_IMNT_STD=[$3], CD_TYP_PSN=[$4],
DT_ACQS=[$5], CD_TX_ACQS=[$6], DMT_FED_COST_ACQ_PSN=[$7], QY_SETT=[$8],
DMT_FED_COST_SETT_LCL=[$9], DMT_UNIT_SETT_PSN=[$10], QY_TOT=[$11],
DMT_FED_COST_TOT_CLNT=[$12], DMT_FED_COST_TOT_LCL=[$13],
DMT_UNIT_TOT_PSN=[$14], TRD_FEDERAL_TAX_COST_LOCL=[$15],
SET_FEDERAL_TAX_COST_LOCL=[$16], DMT_TRD_GIFT_DATE=[$17],
DMT_TRD_FMKT_VAL_LOCL=[$18], DMT_TRD_FMKT_VAL_BASE=[$19],
DMT_SET_GIFT_DATE=[$20], DMT_SET_FMKT_VAL_LOCL=[$21],
DMT_SET_FMKT_VAL_BASE=[$22], DMT_TRD_LOT_LEVEL_COV_IND=[$23],
DMT_SET_LOT_LEVEL_COV_IND=[$24], DMT_TRD_TRANSFER_CODE=[$25],
DMT_SET_TRANSFER_CODE=[$26], DMT_TRD_WASH_SALE_ACQ_DATE=[$27],
DMT_SET_WASH_SALE_ACQ_DATE=[$28], DMT_TRD_LOT_DISALLOWED_DAYS=[$29],
DMT_SET_LOT_DISALLOWED_DAYS=[$30], DMT_TRD_LOT_FMKT_USAGE_IND=[$31],
DMT_SET_LOT_FMKT_USAGE_IND=[$32], DMT_SET_UGL_ST=[$33],
DMT_SET_UGL_ST_LCL=[$34], DMT_SET_UGL_LT=[$35], DMT_SET_UGL_LT_LCL=[$36],
DMT_TRD_UGL_ST=[$37], DMT_TRD_UGL_ST_LCL=[$38], DMT_TRD_UGL_LT=[$39],
DMT_TRD_UGL_LT_LCL=[$40], ID_ACC_ALT=[$41], CD_MTH_CSTNG=[$42],
CD_CCY_TRD_PRIM=[$43], RT_SPOT=[$44], IMNT_CLSS_PRICE_FCTR_RT=[$45],
ID_IMNT_CL=[$46], DMT_TOT_MV_PSN=[$47], TRD_INT_LOCL=[$48],
DMT_INCM_EXPCTD=[$49], DMT_SETT_MV_PSN=[$50], CD_CL_OMNI=[$51]) : rowType =
RecordType(ANY ACTION, ANY ID_TRAN_COLL, ANY ID_ACC, ANY ID_IMNT_STD, ANY
CD_TYP_PSN, ANY DT_ACQS, ANY CD_TX_ACQS, ANY DMT_FED_COST_ACQ_PSN, ANY QY_SETT,
ANY DMT_FED_COST_SETT_LCL, ANY DMT_UNIT_SETT_PSN, ANY QY_TOT, ANY
DMT_FED_COST_TOT_CLNT, ANY DMT_FED_COST_TOT_LCL, ANY DMT_UNIT_TOT_PSN, ANY
TRD_FEDERAL_TAX_COST_LOCL, ANY SET_FEDERAL_TAX_COST_LOCL, ANY
DMT_TRD_GIFT_DATE, ANY DMT_TRD_FMKT_VAL_LOCL, ANY DMT_TRD_FMKT_VAL_BASE, ANY
DMT_SET_GIFT_DATE, ANY DMT_SET_FMKT_VAL_LOCL, ANY DMT_SET_FMKT_VAL_BASE, ANY
DMT_TRD_LOT_LEVEL_COV_IND, ANY DMT_SET_LOT_LEVEL_COV_IND, ANY
DMT_TRD_TRANSFER_CODE, ANY DMT_SET_TRANSFER_CODE, ANY
DMT_TRD_WASH_SALE_ACQ_DATE, ANY DMT_SET_WASH_SALE_ACQ_DATE, ANY
DMT_TRD_LOT_DISALLOWED_DAYS, ANY DMT_SET_LOT_DISALLOWED_DAYS, ANY
DMT_TRD_LOT_FMKT_USAGE_IND, ANY DMT_SET_LOT_FMKT_USAGE_IND, ANY DMT_SET_UGL_ST,
ANY DMT_SET_UGL_ST_LCL, ANY DMT_SET_UGL_LT, ANY DMT_SET_UGL_LT_LCL, ANY
DMT_TRD_UGL_ST, ANY DMT_TRD_UGL_ST_LCL, ANY DMT_TRD_UGL_LT, ANY
DMT_TRD_UGL_LT_LCL, ANY ID_ACC_ALT, ANY CD_MTH_CSTNG, ANY CD_CCY_TRD_PRIM, ANY
RT_SPOT, ANY IMNT_CLSS_PRICE_FCTR_RT, ANY ID_IMNT_CL, ANY DMT_TOT_MV_PSN, ANY
TRD_INT_LOCL, ANY DMT_INCM_EXPCTD, ANY DMT_SETT_MV_PSN, ANY CD_CL_OMNI):
rowcount = 4.0612884300000004E7, cumulative cost = {7.289944561999999E8 rows,
1.5707461228544182E10 cpu, 0.0 io, 2.5162863282995203E13 network,
1.7235157009600002E10 memory}, id = 117133 00-02
SingleMergeExchange(sort0=[2 ASC], sort1=[3 ASC]) : rowType = RecordType(ANY
ACTION, ANY ID_TRAN_COLL, ANY ID_ACC, ANY ID_IMNT_STD, ANY CD_TYP_PSN, ANY
DT_ACQS, ANY CD_TX_ACQS, ANY DMT_FED_COST_ACQ_PSN, ANY QY_SETT, ANY
DMT_FED_COST_SETT_LCL, ANY DMT_UNIT_SETT_PSN, ANY QY_TOT, ANY
DMT_FED_COST_TOT_CLNT, ANY DMT_FED_COST_TOT_LCL, ANY DMT_UNIT_TOT_PSN, ANY
TRD_FEDERAL_TAX_COST_LOCL, ANY SET_FEDERAL_TAX_COST_LOCL, ANY
DMT_TRD_GIFT_DATE, ANY DMT_TRD_FMKT_VAL_LOCL, ANY DMT_TRD_FMKT_VAL_BASE, ANY
DMT_SET_GIFT_DATE, ANY DMT_SET_FMKT_VAL_LOCL, ANY DMT_SET_FMKT_VAL_BASE, ANY
DMT_TRD_LOT_LEVEL_COV_IND, ANY DMT_SET_LOT_LEVEL_COV_IND, ANY
DMT_TRD_TRANSFER_CODE, ANY DMT_SET_TRANSFER_CODE, ANY
DMT_TRD_WASH_SALE_ACQ_DATE, ANY DMT_SET_WASH_SALE_ACQ_DATE, ANY
DMT_TRD_LOT_DISALLOWED_DAYS, ANY DMT_SET_LOT_DISALLOWED_DAYS, ANY
DMT_TRD_LOT_FMKT_USAGE_IND, ANY DMT_SET_LOT_FMKT_USAGE_IND, ANY DMT_SET_UGL_ST,
ANY DMT_SET_UGL_ST_LCL, ANY DMT_SET_UGL_LT, ANY DMT_SET_UGL_LT_LCL, ANY
DMT_TRD_UGL_ST, ANY DMT_TRD_UGL_ST_LCL, ANY DMT_TRD_UGL_LT, ANY
DMT_TRD_UGL_LT_LCL, ANY ID_ACC_ALT, ANY CD_MTH_CSTNG, ANY CD_CCY_TRD_PRIM, ANY
RT_SPOT, ANY IMNT_CLSS_PRICE_FCTR_RT, ANY ID_IMNT_CL, ANY DMT_TOT_MV_PSN, ANY
TRD_INT_LOCL, ANY DMT_INCM_EXPCTD, ANY DMT_SETT_MV_PSN, ANY CD_CL_OMNI):
rowcount = 4.0612884300000004E7, cumulative cost = {7.289944561999999E8 rows,
1.5707461228544182E10 cpu, 0.0 io, 2.5162863282995203E13 network,
1.7235157009600002E10 memory}, id = 117132 01-01
SelectionVectorRemover : rowType = RecordType(ANY ACTION, ANY ID_TRAN_COLL, ANY
ID_ACC, ANY ID_IMNT_STD, ANY CD_TYP_PSN, ANY DT_ACQS, ANY CD_TX_ACQS, ANY
DMT_FED_COST_ACQ_PSN, ANY QY_SETT, ANY DMT_FED_COST_SETT_LCL, ANY
DMT_UNIT_SETT_PSN, ANY QY_TOT, ANY DMT_FED_COST_TOT_CLNT, ANY
DMT_FED_COST_TOT_LCL, ANY DMT_UNIT_TOT_PSN, ANY TRD_FEDERAL_TAX_COST_LOCL, ANY
SET_FEDERAL_TAX_COST_LOCL, ANY DMT_TRD_GIFT_DATE, ANY DMT_TRD_FMKT_VAL_LOCL,
ANY DMT_TRD_FMKT_VAL_BASE, ANY DMT_SET_GIFT_DATE, ANY DMT_SET_FMKT_VAL_LOCL,
ANY DMT_SET_FMKT_VAL_BASE, ANY DMT_TRD_LOT_LEVEL_COV_IND, ANY
DMT_SET_LOT_LEVEL_COV_IND, ANY DMT_TRD_TRANSFER_CODE, ANY
DMT_SET_TRANSFER_CODE, ANY DMT_TRD_WASH_SALE_ACQ_DATE, ANY
DMT_SET_WASH_SALE_ACQ_DATE, ANY DMT_TRD_LOT_DISALLOWED_DAYS, ANY
DMT_SET_LOT_DISALLOWED_DAYS, ANY DMT_TRD_LOT_FMKT_USAGE_IND, ANY
DMT_SET_LOT_FMKT_USAGE_IND, ANY DMT_SET_UGL_ST, ANY DMT_SET_UGL_ST_LCL, ANY
DMT_SET_UGL_LT, ANY DMT_SET_UGL_LT_LCL, ANY DMT_TRD_UGL_ST, ANY
DMT_TRD_UGL_ST_LCL, ANY DMT_TRD_UGL_LT, ANY DMT_TRD_UGL_LT_LCL, ANY ID_ACC_ALT,
ANY CD_MTH_CSTNG, ANY CD_CCY_TRD_PRIM, ANY RT_SPOT, ANY
IMNT_CLSS_PRICE_FCTR_RT, ANY ID_IMNT_CL, ANY DMT_TOT_MV_PSN, ANY TRD_INT_LOCL,
ANY DMT_INCM_EXPCTD, ANY DMT_SETT_MV_PSN, ANY CD_CL_OMNI): rowcount =
4.0612884300000004E7, cumulative cost = {6.883815719E8 rows,
1.5057655079744183E10 cpu, 0.0 io, 1.6512643830169602E13 network,
1.7235157009600002E10 memory}, id = 117131 01-02 Sort(sort0=[$2],
sort1=[$3], dir0=[ASC], dir1=[ASC]) : rowType = RecordType(ANY ACTION, ANY
ID_TRAN_COLL, ANY ID_ACC, ANY ID_IMNT_STD, ANY CD_TYP_PSN, ANY DT_ACQS, ANY
CD_TX_ACQS, ANY DMT_FED_COST_ACQ_PSN, ANY QY_SETT, ANY DMT_FED_COST_SETT_LCL,
ANY DMT_UNIT_SETT_PSN, ANY QY_TOT, ANY DMT_FED_COST_TOT_CLNT, ANY
DMT_FED_COST_TOT_LCL, ANY DMT_UNIT_TOT_PSN, ANY TRD_FEDERAL_TAX_COST_LOCL, ANY
SET_FEDERAL_TAX_COST_LOCL, ANY DMT_TRD_GIFT_DATE, ANY DMT_TRD_FMKT_VAL_LOCL,
ANY DMT_TRD_FMKT_VAL_BASE, ANY DMT_SET_GIFT_DATE, ANY DMT_SET_FMKT_VAL_LOCL,
ANY DMT_SET_FMKT_VAL_BASE, ANY DMT_TRD_LOT_LEVEL_COV_IND, ANY
DMT_SET_LOT_LEVEL_COV_IND, ANY DMT_TRD_TRANSFER_CODE, ANY
DMT_SET_TRANSFER_CODE, ANY DMT_TRD_WASH_SALE_ACQ_DATE, ANY
DMT_SET_WASH_SALE_ACQ_DATE, ANY DMT_TRD_LOT_DISALLOWED_DAYS, ANY
DMT_SET_LOT_DISALLOWED_DAYS, ANY DMT_TRD_LOT_FMKT_USAGE_IND, ANY
DMT_SET_LOT_FMKT_USAGE_IND, ANY DMT_SET_UGL_ST, ANY DMT_SET_UGL_ST_LCL, ANY
DMT_SET_UGL_LT, ANY DMT_SET_UGL_LT_LCL, ANY DMT_TRD_UGL_ST, ANY
DMT_TRD_UGL_ST_LCL, ANY DMT_TRD_UGL_LT, ANY DMT_TRD_UGL_LT_LCL, ANY ID_ACC_ALT,
ANY CD_MTH_CSTNG, ANY CD_CCY_TRD_PRIM, ANY RT_SPOT, ANY
IMNT_CLSS_PRICE_FCTR_RT, ANY ID_IMNT_CL, ANY DMT_TOT_MV_PSN, ANY TRD_INT_LOCL,
ANY DMT_INCM_EXPCTD, ANY DMT_SETT_MV_PSN, ANY CD_CL_OMNI): rowcount =
4.0612884300000004E7, cumulative cost = {6.477686876E8 rows,
1.5017042195444183E10 cpu, 0.0 io, 1.6512643830169602E13 network,
1.7235157009600002E10 memory}, id = 117130 01-03
Project(ACTION=[$0], ID_TRAN_COLL=[$1], ID_ACC=[$2], ID_IMNT_STD=[$3],
CD_TYP_PSN=[$4], DT_ACQS=[$5], CD_TX_ACQS=[$6], DMT_FED_COST_ACQ_PSN=[$7],
QY_SETT=[$8], DMT_FED_COST_SETT_LCL=[$9], DMT_UNIT_SETT_PSN=[$10],
QY_TOT=[$11], DMT_FED_COST_TOT_CLNT=[$12], DMT_FED_COST_TOT_LCL=[$13],
DMT_UNIT_TOT_PSN=[$14], TRD_FEDERAL_TAX_COST_LOCL=[$15],
SET_FEDERAL_TAX_COST_LOCL=[$16], DMT_TRD_GIFT_DATE=[$17],
DMT_TRD_FMKT_VAL_LOCL=[$18], DMT_TRD_FMKT_VAL_BASE=[$19],
DMT_SET_GIFT_DATE=[$20], DMT_SET_FMKT_VAL_LOCL=[$21],
DMT_SET_FMKT_VAL_BASE=[$22], DMT_TRD_LOT_LEVEL_COV_IND=[$23],
DMT_SET_LOT_LEVEL_COV_IND=[$24], DMT_TRD_TRANSFER_CODE=[$25],
DMT_SET_TRANSFER_CODE=[$26], DMT_TRD_WASH_SALE_ACQ_DATE=[$27],
DMT_SET_WASH_SALE_ACQ_DATE=[$28], DMT_TRD_LOT_DISALLOWED_DAYS=[$29],
DMT_SET_LOT_DISALLOWED_DAYS=[$30], DMT_TRD_LOT_FMKT_USAGE_IND=[$31],
DMT_SET_LOT_FMKT_USAGE_IND=[$32], DMT_SET_UGL_ST=[$33],
DMT_SET_UGL_ST_LCL=[$34], DMT_SET_UGL_LT=[$35], DMT_SET_UGL_LT_LCL=[$36],
DMT_TRD_UGL_ST=[$37], DMT_TRD_UGL_ST_LCL=[$38], DMT_TRD_UGL_LT=[$39],
DMT_TRD_UGL_LT_LCL=[$40], ID_ACC_ALT=[$41], CD_MTH_CSTNG=[$42],
CD_CCY_TRD_PRIM=[$43], RT_SPOT=[$44], IMNT_CLSS_PRICE_FCTR_RT=[$45],
ID_IMNT_CL=[$46], DMT_TOT_MV_PSN=[$47], TRD_INT_LOCL=[$48],
DMT_INCM_EXPCTD=[$49], DMT_SETT_MV_PSN=[$50], CD_CL_OMNI=[$51]) : rowType =
RecordType(ANY ACTION, ANY ID_TRAN_COLL, ANY ID_ACC, ANY ID_IMNT_STD, ANY
CD_TYP_PSN, ANY DT_ACQS, ANY CD_TX_ACQS, ANY DMT_FED_COST_ACQ_PSN, ANY QY_SETT,
ANY DMT_FED_COST_SETT_LCL, ANY DMT_UNIT_SETT_PSN, ANY QY_TOT, ANY
DMT_FED_COST_TOT_CLNT, ANY DMT_FED_COST_TOT_LCL, ANY DMT_UNIT_TOT_PSN, ANY
TRD_FEDERAL_TAX_COST_LOCL, ANY SET_FEDERAL_TAX_COST_LOCL, ANY
DMT_TRD_GIFT_DATE, ANY DMT_TRD_FMKT_VAL_LOCL, ANY DMT_TRD_FMKT_VAL_BASE, ANY
DMT_SET_GIFT_DATE, ANY DMT_SET_FMKT_VAL_LOCL, ANY DMT_SET_FMKT_VAL_BASE, ANY
DMT_TRD_LOT_LEVEL_COV_IND, ANY DMT_SET_LOT_LEVEL_COV_IND, ANY
DMT_TRD_TRANSFER_CODE, ANY DMT_SET_TRANSFER_CODE, ANY
DMT_TRD_WASH_SALE_ACQ_DATE, ANY DMT_SET_WASH_SALE_ACQ_DATE, ANY
DMT_TRD_LOT_DISALLOWED_DAYS, ANY DMT_SET_LOT_DISALLOWED_DAYS, ANY
DMT_TRD_LOT_FMKT_USAGE_IND, ANY DMT_SET_LOT_FMKT_USAGE_IND, ANY DMT_SET_UGL_ST,
ANY DMT_SET_UGL_ST_LCL, ANY DMT_SET_UGL_LT, ANY DMT_SET_UGL_LT_LCL, ANY
DMT_TRD_UGL_ST, ANY DMT_TRD_UGL_ST_LCL, ANY DMT_TRD_UGL_LT, ANY
DMT_TRD_UGL_LT_LCL, ANY ID_ACC_ALT, ANY CD_MTH_CSTNG, ANY CD_CCY_TRD_PRIM, ANY
RT_SPOT, ANY IMNT_CLSS_PRICE_FCTR_RT, ANY ID_IMNT_CL, ANY DMT_TOT_MV_PSN, ANY
TRD_INT_LOCL, ANY DMT_INCM_EXPCTD, ANY DMT_SETT_MV_PSN, ANY CD_CL_OMNI):
rowcount = 4.0612884300000004E7, cumulative cost = {6.071558033000001E8 rows,
6.804975931900001E9 cpu, 0.0 io, 1.6512643830169602E13 network,
3.4019714079999995E8 memory}, id = 117129 01-04
HashToRandomExchange(dist0=[[$2]], dist1=[[$3]]) : rowType = RecordType(ANY
ACTION, ANY ID_TRAN_COLL, ANY ID_ACC, ANY ID_IMNT_STD, ANY CD_TYP_PSN, ANY
DT_ACQS, ANY CD_TX_ACQS, ANY DMT_FED_COST_ACQ_PSN, ANY QY_SETT, ANY
DMT_FED_COST_SETT_LCL, ANY DMT_UNIT_SETT_PSN, ANY QY_TOT, ANY
DMT_FED_COST_TOT_CLNT, ANY DMT_FED_COST_TOT_LCL, ANY DMT_UNIT_TOT_PSN, ANY
TRD_FEDERAL_TAX_COST_LOCL, ANY SET_FEDERAL_TAX_COST_LOCL, ANY
DMT_TRD_GIFT_DATE, ANY DMT_TRD_FMKT_VAL_LOCL, ANY DMT_TRD_FMKT_VAL_BASE, ANY
DMT_SET_GIFT_DATE, ANY DMT_SET_FMKT_VAL_LOCL, ANY DMT_SET_FMKT_VAL_BASE, ANY
DMT_TRD_LOT_LEVEL_COV_IND, ANY DMT_SET_LOT_LEVEL_COV_IND, ANY
DMT_TRD_TRANSFER_CODE, ANY DMT_SET_TRANSFER_CODE, ANY
DMT_TRD_WASH_SALE_ACQ_DATE, ANY DMT_SET_WASH_SALE_ACQ_DATE, ANY
DMT_TRD_LOT_DISALLOWED_DAYS, ANY DMT_SET_LOT_DISALLOWED_DAYS, ANY
DMT_TRD_LOT_FMKT_USAGE_IND, ANY DMT_SET_LOT_FMKT_USAGE_IND, ANY DMT_SET_UGL_ST,
ANY DMT_SET_UGL_ST_LCL, ANY DMT_SET_UGL_LT, ANY DMT_SET_UGL_LT_LCL, ANY
DMT_TRD_UGL_ST, ANY DMT_TRD_UGL_ST_LCL, ANY DMT_TRD_UGL_LT, ANY
DMT_TRD_UGL_LT_LCL, ANY ID_ACC_ALT, ANY CD_MTH_CSTNG, ANY CD_CCY_TRD_PRIM, ANY
RT_SPOT, ANY IMNT_CLSS_PRICE_FCTR_RT, ANY ID_IMNT_CL, ANY DMT_TOT_MV_PSN, ANY
TRD_INT_LOCL, ANY DMT_INCM_EXPCTD, ANY DMT_SETT_MV_PSN, ANY CD_CL_OMNI, ANY
E_X_P_R_H_A_S_H_F_I_E_L_D): rowcount = 4.0612884300000004E7, cumulative cost =
{6.071558033000001E8 rows, 6.804975931900001E9 cpu, 0.0 io,
1.6512643830169602E13 network, 3.4019714079999995E8 memory}, id = 117128
