============================================================================ USER COMMAND: SELECT s.channel, m.user_name, COUNT(*) FROM channel.dbo.service_request AS s INNER JOIN ops.dbo.manager AS m ON s.staff_id = m.manager_id GROUP BY s.channel, m.user_name LIMIT 200 ---------------------------------------------------------------------------- OPTIMIZE: SELECT s.channel, m.user_name, COUNT(*) FROM channel.dbo.service_request AS s INNER JOIN ops.dbo.manager AS m ON s.staff_id = m.manager_id GROUP BY s.channel, m.user_name LIMIT 200 ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT s.channel, m.user_name, COUNT(*) FROM channel.dbo.service_request AS s INNER JOIN ops.dbo.manager AS m ON s.staff_id = m.manager_id GROUP BY s.channel, m.user_name LIMIT 200 CANONICAL PLAN: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=200}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS channel, anon_grp0.gcol1 AS user_name, anon_grp0.agg0 AS expr3]}) Group(groups=[channel.dbo.service_request AS s, ops.dbo.manager AS m, anon_grp0], props={GROUP_COLS=[s.channel, m.user_name], SYMBOL_MAP={anon_grp0.gcol0=s.channel, anon_grp0.gcol1=m.user_name, anon_grp0.agg0=COUNT(*)}}) Join(groups=[channel.dbo.service_request AS s, ops.dbo.manager AS m], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[s.staff_id = m.manager_id]}) Source(groups=[channel.dbo.service_request AS s]) Source(groups=[ops.dbo.manager AS m]) ============================================================================ EXECUTING PlaceAccess AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=200}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS channel, anon_grp0.gcol1 AS user_name, anon_grp0.agg0 AS expr3]}) Group(groups=[channel.dbo.service_request AS s, ops.dbo.manager AS m, anon_grp0], props={GROUP_COLS=[s.channel, m.user_name], SYMBOL_MAP={anon_grp0.gcol0=s.channel, anon_grp0.gcol1=m.user_name, anon_grp0.agg0=COUNT(*)}}) Join(groups=[channel.dbo.service_request AS s, ops.dbo.manager AS m], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[s.staff_id = m.manager_id]}) Access(groups=[channel.dbo.service_request AS s], props={SOURCE_HINT=null, MODEL_ID=Schema name=channel, nameInSource=null, uuid=tid:cafba140f5cf-2c0b7d03-00000000, IS_MULTI_SOURCE=true}) Source(groups=[channel.dbo.service_request AS s]) Access(groups=[ops.dbo.manager AS m], props={SOURCE_HINT=null, MODEL_ID=Schema name=ops, nameInSource=null, uuid=tid:0015a10b6d7e-0001aeb2-00000000}) Source(groups=[ops.dbo.manager AS m]) ============================================================================ EXECUTING PushNonJoinCriteria AFTER: TupleLimit(groups=[]) Project(groups=[anon_grp0]) Group(groups=[channel.dbo.service_request AS s, ops.dbo.manager AS m, anon_grp0]) Join(groups=[channel.dbo.service_request AS s, ops.dbo.manager AS m], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[s.staff_id = m.manager_id]}) Access(groups=[channel.dbo.service_request AS s]) Source(groups=[channel.dbo.service_request AS s]) Access(groups=[ops.dbo.manager AS m]) Source(groups=[ops.dbo.manager AS m]) ============================================================================ EXECUTING CleanCriteria AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=200, OUTPUT_COLS=null}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS channel, anon_grp0.gcol1 AS user_name, anon_grp0.agg0 AS expr3], OUTPUT_COLS=null}) Group(groups=[channel.dbo.service_request AS s, ops.dbo.manager AS m, anon_grp0], props={GROUP_COLS=[s.channel, m.user_name], SYMBOL_MAP={anon_grp0.gcol0=s.channel, anon_grp0.gcol1=m.user_name, anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=null}) Join(groups=[channel.dbo.service_request AS s, ops.dbo.manager AS m], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[s.staff_id = m.manager_id], OUTPUT_COLS=null}) Access(groups=[channel.dbo.service_request AS s], props={SOURCE_HINT=null, MODEL_ID=Schema name=channel, nameInSource=null, uuid=tid:cafba140f5cf-2c0b7d03-00000000, IS_MULTI_SOURCE=true, OUTPUT_COLS=null}) Source(groups=[channel.dbo.service_request AS s], props={OUTPUT_COLS=null}) Access(groups=[ops.dbo.manager AS m], props={SOURCE_HINT=null, MODEL_ID=Schema name=ops, nameInSource=null, uuid=tid:0015a10b6d7e-0001aeb2-00000000, OUTPUT_COLS=null}) Source(groups=[ops.dbo.manager AS m], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING RaiseAccess AFTER: TupleLimit(groups=[]) Project(groups=[anon_grp0]) Group(groups=[channel.dbo.service_request AS s, ops.dbo.manager AS m, anon_grp0]) Join(groups=[channel.dbo.service_request AS s, ops.dbo.manager AS m], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[s.staff_id = m.manager_id], OUTPUT_COLS=null}) Access(groups=[channel.dbo.service_request AS s], props={SOURCE_HINT=null, MODEL_ID=Schema name=channel, nameInSource=null, uuid=tid:cafba140f5cf-2c0b7d03-00000000, IS_MULTI_SOURCE=true, OUTPUT_COLS=null}) Source(groups=[channel.dbo.service_request AS s]) Access(groups=[ops.dbo.manager AS m], props={SOURCE_HINT=null, MODEL_ID=Schema name=ops, nameInSource=null, uuid=tid:0015a10b6d7e-0001aeb2-00000000, OUTPUT_COLS=null}) Source(groups=[ops.dbo.manager AS m]) ============================================================================ EXECUTING CopyCriteria AFTER: TupleLimit(groups=[]) Project(groups=[anon_grp0]) Group(groups=[channel.dbo.service_request AS s, ops.dbo.manager AS m, anon_grp0]) Join(groups=[channel.dbo.service_request AS s, ops.dbo.manager AS m], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[s.staff_id = m.manager_id], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[channel.dbo.service_request AS s]) Source(groups=[channel.dbo.service_request AS s]) Access(groups=[ops.dbo.manager AS m]) Source(groups=[ops.dbo.manager AS m]) ============================================================================ EXECUTING CleanCriteria AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=200, OUTPUT_COLS=null}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS channel, anon_grp0.gcol1 AS user_name, anon_grp0.agg0 AS expr3], OUTPUT_COLS=null}) Group(groups=[channel.dbo.service_request AS s, ops.dbo.manager AS m, anon_grp0], props={GROUP_COLS=[s.channel, m.user_name], SYMBOL_MAP={anon_grp0.gcol0=s.channel, anon_grp0.gcol1=m.user_name, anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=null}) Join(groups=[channel.dbo.service_request AS s, ops.dbo.manager AS m], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[s.staff_id = m.manager_id], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[channel.dbo.service_request AS s], props={SOURCE_HINT=null, MODEL_ID=Schema name=channel, nameInSource=null, uuid=tid:cafba140f5cf-2c0b7d03-00000000, IS_MULTI_SOURCE=true, OUTPUT_COLS=null}) Source(groups=[channel.dbo.service_request AS s], props={OUTPUT_COLS=null}) Access(groups=[ops.dbo.manager AS m], props={SOURCE_HINT=null, MODEL_ID=Schema name=ops, nameInSource=null, uuid=tid:0015a10b6d7e-0001aeb2-00000000, OUTPUT_COLS=null}) Source(groups=[ops.dbo.manager AS m], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING PlanJoins AFTER: TupleLimit(groups=[]) Project(groups=[anon_grp0]) Group(groups=[channel.dbo.service_request AS s, ops.dbo.manager AS m, anon_grp0], props={GROUP_COLS=[s.channel, m.user_name], SYMBOL_MAP={anon_grp0.gcol0=s.channel, anon_grp0.gcol1=m.user_name, anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=null}) Select(groups=[channel.dbo.service_request AS s, ops.dbo.manager AS m], props={SELECT_CRITERIA=s.staff_id = m.manager_id, EST_SELECTIVITY=0.32382572}) Join(groups=[ops.dbo.manager AS m, channel.dbo.service_request AS s], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP}) Access(groups=[ops.dbo.manager AS m], props={SOURCE_HINT=null, MODEL_ID=Schema name=ops, nameInSource=null, uuid=tid:0015a10b6d7e-0001aeb2-00000000, OUTPUT_COLS=null, EST_CARDINALITY=9258.0, EST_COL_STATS={m.manager_id=[9258.0, 9258.0, 1.0], m.firm_id=[97.0, 4629.0, -1.0], m.email=[97.0, 4629.0, -1.0], m.password=[97.0, 4629.0, -1.0], ...}}) Source(groups=[ops.dbo.manager AS m], props={OUTPUT_COLS=null, EST_COL_STATS={m.manager_id=[9258.0, 9258.0, 0.0], m.firm_id=[97.0, 4629.0, -1.0], m.email=[97.0, 4629.0, -1.0], m.password=[97.0, 4629.0, -1.0], ...}, EST_CARDINALITY=9258.0}) Access(groups=[channel.dbo.service_request AS s], props={SOURCE_HINT=null, MODEL_ID=Schema name=channel, nameInSource=null, uuid=tid:cafba140f5cf-2c0b7d03-00000000, IS_MULTI_SOURCE=true, OUTPUT_COLS=null, EST_CARDINALITY=857576.0, EST_COL_STATS={s.service_request_id=[857576.0, 857576.0, 1.0], s.advisor_id=[927.0, 428788.0, -1.0], s.staff_id=[927.0, 428788.0, -1.0], s.request_type=[927.0, 428788.0, -1.0], ...}}) Source(groups=[channel.dbo.service_request AS s], props={OUTPUT_COLS=null, EST_COL_STATS={s.service_request_id=[857576.0, 857576.0, 0.0], s.advisor_id=[927.0, 428788.0, -1.0], s.staff_id=[927.0, 428788.0, -1.0], s.request_type=[927.0, 428788.0, -1.0], ...}, EST_CARDINALITY=857576.0}) ============================================================================ EXECUTING PushSelectCriteria AFTER: TupleLimit(groups=[]) Project(groups=[anon_grp0]) Group(groups=[channel.dbo.service_request AS s, ops.dbo.manager AS m, anon_grp0], props={GROUP_COLS=[s.channel, m.user_name], SYMBOL_MAP={anon_grp0.gcol0=s.channel, anon_grp0.gcol1=m.user_name, anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=null}) Join(groups=[ops.dbo.manager AS m, channel.dbo.service_request AS s], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[s.staff_id = m.manager_id]}) Access(groups=[ops.dbo.manager AS m]) Source(groups=[ops.dbo.manager AS m]) Access(groups=[channel.dbo.service_request AS s]) Source(groups=[channel.dbo.service_request AS s]) ============================================================================ EXECUTING RaiseAccess AFTER: TupleLimit(groups=[]) Project(groups=[anon_grp0]) Group(groups=[channel.dbo.service_request AS s, ops.dbo.manager AS m, anon_grp0]) Join(groups=[ops.dbo.manager AS m, channel.dbo.service_request AS s], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[s.staff_id = m.manager_id]}) Access(groups=[ops.dbo.manager AS m], props={SOURCE_HINT=null, MODEL_ID=Schema name=ops, nameInSource=null, uuid=tid:0015a10b6d7e-0001aeb2-00000000, OUTPUT_COLS=null, EST_CARDINALITY=9258.0, EST_COL_STATS={m.manager_id=[9258.0, 9258.0, 1.0], m.firm_id=[97.0, 4629.0, -1.0], m.email=[97.0, 4629.0, -1.0], m.password=[97.0, 4629.0, -1.0], ...}}) Source(groups=[ops.dbo.manager AS m]) Access(groups=[channel.dbo.service_request AS s], props={SOURCE_HINT=null, MODEL_ID=Schema name=channel, nameInSource=null, uuid=tid:cafba140f5cf-2c0b7d03-00000000, IS_MULTI_SOURCE=true, OUTPUT_COLS=null, EST_CARDINALITY=857576.0, EST_COL_STATS={s.service_request_id=[857576.0, 857576.0, 1.0], s.advisor_id=[927.0, 428788.0, -1.0], s.staff_id=[927.0, 428788.0, -1.0], s.request_type=[927.0, 428788.0, -1.0], ...}}) Source(groups=[channel.dbo.service_request AS s]) ============================================================================ EXECUTING PlanOuterJoins AFTER: TupleLimit(groups=[]) Project(groups=[anon_grp0]) Group(groups=[channel.dbo.service_request AS s, ops.dbo.manager AS m, anon_grp0]) Join(groups=[ops.dbo.manager AS m, channel.dbo.service_request AS s], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[s.staff_id = m.manager_id]}) Access(groups=[ops.dbo.manager AS m]) Source(groups=[ops.dbo.manager AS m]) Access(groups=[channel.dbo.service_request AS s]) Source(groups=[channel.dbo.service_request AS s]) ============================================================================ EXECUTING ChooseJoinStrategy AFTER: TupleLimit(groups=[]) Project(groups=[anon_grp0]) Group(groups=[channel.dbo.service_request AS s, ops.dbo.manager AS m, anon_grp0]) Join(groups=[ops.dbo.manager AS m, channel.dbo.service_request AS s], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[s.staff_id = m.manager_id], LEFT_EXPRESSIONS=[m.manager_id], RIGHT_EXPRESSIONS=[s.staff_id], NON_EQUI_JOIN_CRITERIA=[]}) Access(groups=[ops.dbo.manager AS m]) Source(groups=[ops.dbo.manager AS m]) Access(groups=[channel.dbo.service_request AS s]) Source(groups=[channel.dbo.service_request AS s]) ============================================================================ EXECUTING ChooseDependent AFTER: TupleLimit(groups=[]) Project(groups=[anon_grp0]) Group(groups=[channel.dbo.service_request AS s, ops.dbo.manager AS m, anon_grp0]) Join(groups=[ops.dbo.manager AS m, channel.dbo.service_request AS s], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[s.staff_id = m.manager_id], LEFT_EXPRESSIONS=[m.manager_id], RIGHT_EXPRESSIONS=[s.staff_id], NON_EQUI_JOIN_CRITERIA=[]}) Access(groups=[ops.dbo.manager AS m]) Source(groups=[ops.dbo.manager AS m]) Access(groups=[channel.dbo.service_request AS s]) Source(groups=[channel.dbo.service_request AS s]) ============================================================================ EXECUTING PushAggregates AFTER: TupleLimit(groups=[]) Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS channel, anon_grp1.gcol1 AS user_name, IFNULL(convert(anon_grp1.agg0, integer), 0) AS expr3], OUTPUT_COLS=null}) Group(groups=[anon_grp2, ops.dbo.manager AS m, anon_grp1], props={GROUP_COLS=[anon_grp2.gcol1, m.user_name], SYMBOL_MAP={anon_grp1.gcol0=anon_grp2.gcol1, anon_grp1.gcol1=m.user_name, anon_grp1.agg0=SUM(IFNULL(anon_grp2.agg0, 1))}, OUTPUT_COLS=null}) Join(groups=[ops.dbo.manager AS m, anon_grp2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[anon_grp2.gcol0 = m.manager_id], LEFT_EXPRESSIONS=[m.manager_id], RIGHT_EXPRESSIONS=[anon_grp2.gcol0], NON_EQUI_JOIN_CRITERIA=[]}) Access(groups=[ops.dbo.manager AS m], props={SOURCE_HINT=null, MODEL_ID=Schema name=ops, nameInSource=null, uuid=tid:0015a10b6d7e-0001aeb2-00000000, OUTPUT_COLS=null, EST_CARDINALITY=9258.0, EST_COL_STATS={m.manager_id=[9258.0, 9258.0, 1.0], m.firm_id=[97.0, 4629.0, -1.0], m.email=[97.0, 4629.0, -1.0], m.password=[97.0, 4629.0, -1.0], ...}}) Source(groups=[ops.dbo.manager AS m]) Access(groups=[channel.dbo.service_request AS s], props={SOURCE_HINT=null, MODEL_ID=Schema name=channel, nameInSource=null, uuid=tid:cafba140f5cf-2c0b7d03-00000000, IS_MULTI_SOURCE=true, OUTPUT_COLS=null, EST_COL_STATS={s.service_request_id=[857576.0, 857576.0, 1.0], s.advisor_id=[927.0, 428788.0, -1.0], s.staff_id=[927.0, 428788.0, -1.0], s.request_type=[927.0, 428788.0, -1.0], ...}}) Group(groups=[channel.dbo.service_request AS s, anon_grp2], props={GROUP_COLS=[s.staff_id, s.channel], SYMBOL_MAP={anon_grp2.gcol0=s.staff_id, anon_grp2.gcol1=s.channel, anon_grp2.agg0=COUNT(*)}}) Source(groups=[channel.dbo.service_request AS s], props={OUTPUT_COLS=null, EST_COL_STATS={s.service_request_id=[857576.0, 857576.0, 0.0], s.advisor_id=[927.0, 428788.0, -1.0], s.staff_id=[927.0, 428788.0, -1.0], s.request_type=[927.0, 428788.0, -1.0], ...}, EST_CARDINALITY=857576.0}) ============================================================================ EXECUTING ChooseDependent AFTER: TupleLimit(groups=[]) Project(groups=[anon_grp1]) Group(groups=[anon_grp2, ops.dbo.manager AS m, anon_grp1]) Join(groups=[ops.dbo.manager AS m, anon_grp2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[anon_grp2.gcol0 = m.manager_id], LEFT_EXPRESSIONS=[m.manager_id], RIGHT_EXPRESSIONS=[anon_grp2.gcol0], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null, DEPENDENT_VALUE_SOURCE=$dsc/id1}) Access(groups=[ops.dbo.manager AS m], props={SOURCE_HINT=null, MODEL_ID=Schema name=ops, nameInSource=null, uuid=tid:0015a10b6d7e-0001aeb2-00000000, OUTPUT_COLS=null, EST_CARDINALITY=9258.0, EST_COL_STATS={m.manager_id=[9258.0, 9258.0, 1.0], m.firm_id=[97.0, 4629.0, -1.0], m.email=[97.0, 4629.0, -1.0], m.password=[97.0, 4629.0, -1.0], ...}}) Source(groups=[ops.dbo.manager AS m], props={OUTPUT_COLS=null, EST_COL_STATS={m.manager_id=[9258.0, 9258.0, 0.0], m.firm_id=[97.0, 4629.0, -1.0], m.email=[97.0, 4629.0, -1.0], m.password=[97.0, 4629.0, -1.0], ...}, EST_CARDINALITY=9258.0}) Select(groups=[anon_grp2], props={SELECT_CRITERIA=anon_grp2.gcol0 IN (), IS_DEPENDENT_SET=true}) Access(groups=[channel.dbo.service_request AS s], props={SOURCE_HINT=null, MODEL_ID=Schema name=channel, nameInSource=null, uuid=tid:cafba140f5cf-2c0b7d03-00000000, IS_MULTI_SOURCE=true, OUTPUT_COLS=null, EST_COL_STATS={anon_grp2.gcol0=[107505.82, 107505.82, -1.0], anon_grp2.gcol1=[107505.82, 107505.82, -1.0], anon_grp2.agg0=[107505.82, 107505.82, -1.0]}, EST_CARDINALITY=322517.47}) Group(groups=[channel.dbo.service_request AS s, anon_grp2], props={GROUP_COLS=[s.staff_id, s.channel], SYMBOL_MAP={anon_grp2.gcol0=s.staff_id, anon_grp2.gcol1=s.channel, anon_grp2.agg0=COUNT(*)}, EST_CARDINALITY=322517.47, EST_COL_STATS={anon_grp2.gcol0=[107505.82, 107505.82, -1.0], anon_grp2.gcol1=[107505.82, 107505.82, -1.0], anon_grp2.agg0=[107505.82, 107505.82, -1.0]}}) Source(groups=[channel.dbo.service_request AS s], props={OUTPUT_COLS=null, EST_COL_STATS={s.service_request_id=[857576.0, 857576.0, 0.0], s.advisor_id=[927.0, 428788.0, -1.0], s.staff_id=[927.0, 428788.0, -1.0], s.request_type=[927.0, 428788.0, -1.0], ...}, EST_CARDINALITY=857576.0}) ============================================================================ EXECUTING PushSelectCriteria AFTER: TupleLimit(groups=[]) Project(groups=[anon_grp1]) Group(groups=[anon_grp2, ops.dbo.manager AS m, anon_grp1]) Join(groups=[ops.dbo.manager AS m, anon_grp2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[anon_grp2.gcol0 = m.manager_id], LEFT_EXPRESSIONS=[m.manager_id], RIGHT_EXPRESSIONS=[anon_grp2.gcol0], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null, DEPENDENT_VALUE_SOURCE=$dsc/id1}) Access(groups=[ops.dbo.manager AS m]) Source(groups=[ops.dbo.manager AS m]) Access(groups=[channel.dbo.service_request AS s], props={SOURCE_HINT=null, MODEL_ID=Schema name=channel, nameInSource=null, uuid=tid:cafba140f5cf-2c0b7d03-00000000, IS_MULTI_SOURCE=true, OUTPUT_COLS=null, EST_COL_STATS={anon_grp2.gcol0=[107505.82, 107505.82, -1.0], anon_grp2.gcol1=[107505.82, 107505.82, -1.0], anon_grp2.agg0=[107505.82, 107505.82, -1.0]}, EST_CARDINALITY=322517.47, IS_DEPENDENT_SET=true}) Group(groups=[channel.dbo.service_request AS s, anon_grp2], props={GROUP_COLS=[s.staff_id, s.channel], SYMBOL_MAP={anon_grp2.gcol0=s.staff_id, anon_grp2.gcol1=s.channel, anon_grp2.agg0=COUNT(*)}, EST_CARDINALITY=322517.47, EST_COL_STATS={anon_grp2.gcol0=[107505.82, 107505.82, -1.0], anon_grp2.gcol1=[107505.82, 107505.82, -1.0], anon_grp2.agg0=[107505.82, 107505.82, -1.0]}}) Select(groups=[channel.dbo.service_request AS s], props={SELECT_CRITERIA=s.staff_id IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true}) Source(groups=[channel.dbo.service_request AS s], props={OUTPUT_COLS=null, EST_COL_STATS={s.service_request_id=[857576.0, 857576.0, 0.0], s.advisor_id=[927.0, 428788.0, -1.0], s.staff_id=[927.0, 428788.0, -1.0], s.request_type=[927.0, 428788.0, -1.0], ...}, EST_CARDINALITY=857576.0}) ============================================================================ EXECUTING CleanCriteria AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=200, OUTPUT_COLS=null}) Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS channel, anon_grp1.gcol1 AS user_name, IFNULL(convert(anon_grp1.agg0, integer), 0) AS expr3], OUTPUT_COLS=null}) Group(groups=[anon_grp2, ops.dbo.manager AS m, anon_grp1], props={GROUP_COLS=[anon_grp2.gcol1, m.user_name], SYMBOL_MAP={anon_grp1.gcol0=anon_grp2.gcol1, anon_grp1.gcol1=m.user_name, anon_grp1.agg0=SUM(IFNULL(anon_grp2.agg0, 1))}, OUTPUT_COLS=null}) Join(groups=[ops.dbo.manager AS m, anon_grp2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[anon_grp2.gcol0 = m.manager_id], LEFT_EXPRESSIONS=[m.manager_id], RIGHT_EXPRESSIONS=[anon_grp2.gcol0], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null, DEPENDENT_VALUE_SOURCE=$dsc/id1, OUTPUT_COLS=null}) Access(groups=[ops.dbo.manager AS m], props={SOURCE_HINT=null, MODEL_ID=Schema name=ops, nameInSource=null, uuid=tid:0015a10b6d7e-0001aeb2-00000000, OUTPUT_COLS=null, EST_CARDINALITY=9258.0, EST_COL_STATS={m.manager_id=[9258.0, 9258.0, 1.0], m.firm_id=[97.0, 4629.0, -1.0], m.email=[97.0, 4629.0, -1.0], m.password=[97.0, 4629.0, -1.0], ...}}) Source(groups=[ops.dbo.manager AS m], props={OUTPUT_COLS=null, EST_COL_STATS={m.manager_id=[9258.0, 9258.0, 0.0], m.firm_id=[97.0, 4629.0, -1.0], m.email=[97.0, 4629.0, -1.0], m.password=[97.0, 4629.0, -1.0], ...}, EST_CARDINALITY=9258.0}) Access(groups=[channel.dbo.service_request AS s], props={SOURCE_HINT=null, MODEL_ID=Schema name=channel, nameInSource=null, uuid=tid:cafba140f5cf-2c0b7d03-00000000, IS_MULTI_SOURCE=true, OUTPUT_COLS=null, EST_COL_STATS={anon_grp2.gcol0=[107505.82, 107505.82, -1.0], anon_grp2.gcol1=[107505.82, 107505.82, -1.0], anon_grp2.agg0=[107505.82, 107505.82, -1.0]}, EST_CARDINALITY=322517.47, IS_DEPENDENT_SET=true}) Group(groups=[channel.dbo.service_request AS s, anon_grp2], props={GROUP_COLS=[s.staff_id, s.channel], SYMBOL_MAP={anon_grp2.gcol0=s.staff_id, anon_grp2.gcol1=s.channel, anon_grp2.agg0=COUNT(*)}, EST_CARDINALITY=322517.47, EST_COL_STATS={anon_grp2.gcol0=[107505.82, 107505.82, -1.0], anon_grp2.gcol1=[107505.82, 107505.82, -1.0], anon_grp2.agg0=[107505.82, 107505.82, -1.0]}, OUTPUT_COLS=null}) Select(groups=[channel.dbo.service_request AS s], props={SELECT_CRITERIA=s.staff_id IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=null}) Source(groups=[channel.dbo.service_request AS s], props={OUTPUT_COLS=null, EST_COL_STATS={s.service_request_id=[857576.0, 857576.0, 0.0], s.advisor_id=[927.0, 428788.0, -1.0], s.staff_id=[927.0, 428788.0, -1.0], s.request_type=[927.0, 428788.0, -1.0], ...}, EST_CARDINALITY=857576.0}) ============================================================================ EXECUTING AssignOutputElements AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=200, OUTPUT_COLS=[anon_grp1.gcol0 AS channel, anon_grp1.gcol1 AS user_name, IFNULL(convert(anon_grp1.agg0, integer), 0) AS expr3]}) Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS channel, anon_grp1.gcol1 AS user_name, IFNULL(convert(anon_grp1.agg0, integer), 0) AS expr3], OUTPUT_COLS=[anon_grp1.gcol0 AS channel, anon_grp1.gcol1 AS user_name, IFNULL(convert(anon_grp1.agg0, integer), 0) AS expr3]}) Group(groups=[anon_grp2, ops.dbo.manager AS m, anon_grp1], props={GROUP_COLS=[anon_grp2.gcol1, m.user_name], SYMBOL_MAP={anon_grp1.gcol0=anon_grp2.gcol1, anon_grp1.gcol1=m.user_name, anon_grp1.agg0=SUM(IFNULL(anon_grp2.agg0, 1))}, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0]}) Join(groups=[ops.dbo.manager AS m, anon_grp2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[anon_grp2.gcol0 = m.manager_id], LEFT_EXPRESSIONS=[m.manager_id], RIGHT_EXPRESSIONS=[anon_grp2.gcol0], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null, DEPENDENT_VALUE_SOURCE=$dsc/id1, OUTPUT_COLS=[anon_grp2.gcol1, m.user_name, anon_grp2.agg0]}) Access(groups=[ops.dbo.manager AS m], props={SOURCE_HINT=null, MODEL_ID=Schema name=ops, nameInSource=null, uuid=tid:0015a10b6d7e-0001aeb2-00000000, OUTPUT_COLS=[m.manager_id, m.user_name], EST_CARDINALITY=9258.0, EST_COL_STATS={m.manager_id=[9258.0, 9258.0, 1.0], m.firm_id=[97.0, 4629.0, -1.0], m.email=[97.0, 4629.0, -1.0], m.password=[97.0, 4629.0, -1.0], ...}}) Source(groups=[ops.dbo.manager AS m], props={OUTPUT_COLS=[m.manager_id, m.user_name], EST_COL_STATS={m.manager_id=[9258.0, 9258.0, 0.0], m.firm_id=[97.0, 4629.0, -1.0], m.email=[97.0, 4629.0, -1.0], m.password=[97.0, 4629.0, -1.0], ...}, EST_CARDINALITY=9258.0}) Access(groups=[channel.dbo.service_request AS s], props={SOURCE_HINT=null, MODEL_ID=Schema name=channel, nameInSource=null, uuid=tid:cafba140f5cf-2c0b7d03-00000000, IS_MULTI_SOURCE=true, OUTPUT_COLS=[], EST_COL_STATS={anon_grp2.gcol0=[107505.82, 107505.82, -1.0], anon_grp2.gcol1=[107505.82, 107505.82, -1.0], anon_grp2.agg0=[107505.82, 107505.82, -1.0]}, EST_CARDINALITY=322517.47, IS_DEPENDENT_SET=true}) Group(groups=[channel.dbo.service_request AS s, anon_grp2], props={GROUP_COLS=[s.staff_id, s.channel], SYMBOL_MAP={anon_grp2.gcol0=s.staff_id, anon_grp2.gcol1=s.channel}, EST_CARDINALITY=322517.47, EST_COL_STATS={anon_grp2.gcol0=[107505.82, 107505.82, -1.0], anon_grp2.gcol1=[107505.82, 107505.82, -1.0], anon_grp2.agg0=[107505.82, 107505.82, -1.0]}, OUTPUT_COLS=[]}) Select(groups=[channel.dbo.service_request AS s], props={SELECT_CRITERIA=s.staff_id IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[s.staff_id, s.channel]}) Source(groups=[channel.dbo.service_request AS s], props={OUTPUT_COLS=[s.staff_id, s.channel], EST_COL_STATS={s.service_request_id=[857576.0, 857576.0, 0.0], s.advisor_id=[927.0, 428788.0, -1.0], s.staff_id=[927.0, 428788.0, -1.0], s.request_type=[927.0, 428788.0, -1.0], ...}, EST_CARDINALITY=857576.0}) ============================================================================ EXECUTING PushLimit AFTER: Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS channel, anon_grp1.gcol1 AS user_name, IFNULL(convert(anon_grp1.agg0, integer), 0) AS expr3], OUTPUT_COLS=[anon_grp1.gcol0 AS channel, anon_grp1.gcol1 AS user_name, IFNULL(convert(anon_grp1.agg0, integer), 0) AS expr3], SOURCE_HINT=null}) TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=200, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0]}) Group(groups=[anon_grp2, ops.dbo.manager AS m, anon_grp1], props={GROUP_COLS=[anon_grp2.gcol1, m.user_name], SYMBOL_MAP={anon_grp1.gcol0=anon_grp2.gcol1, anon_grp1.gcol1=m.user_name, anon_grp1.agg0=SUM(IFNULL(anon_grp2.agg0, 1))}, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0]}) Join(groups=[ops.dbo.manager AS m, anon_grp2]) Access(groups=[ops.dbo.manager AS m]) Source(groups=[ops.dbo.manager AS m]) Access(groups=[channel.dbo.service_request AS s]) Group(groups=[channel.dbo.service_request AS s, anon_grp2]) Select(groups=[channel.dbo.service_request AS s]) Source(groups=[channel.dbo.service_request AS s]) ============================================================================ EXECUTING CalculateCost AFTER: Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS channel, anon_grp1.gcol1 AS user_name, IFNULL(convert(anon_grp1.agg0, integer), 0) AS expr3], OUTPUT_COLS=[anon_grp1.gcol0 AS channel, anon_grp1.gcol1 AS user_name, IFNULL(convert(anon_grp1.agg0, integer), 0) AS expr3], SOURCE_HINT=null, EST_CARDINALITY=200.0, EST_COL_STATS={anon_grp1.gcol0=[66.666664, 66.666664, -1.0], anon_grp1.gcol1=[66.666664, 66.666664, -1.0], IFNULL(convert(anon_grp1.agg0, integer), 0)=[66.666664, 66.666664, -1.0]}}) TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=200, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0], EST_CARDINALITY=200.0, EST_COL_STATS={anon_grp1.gcol0=[66.666664, 66.666664, -1.0], anon_grp1.gcol1=[66.666664, 66.666664, -1.0], anon_grp1.agg0=[66.666664, 66.666664, -1.0]}}) Group(groups=[anon_grp2, ops.dbo.manager AS m, anon_grp1], props={GROUP_COLS=[anon_grp2.gcol1, m.user_name], SYMBOL_MAP={anon_grp1.gcol0=anon_grp2.gcol1, anon_grp1.gcol1=m.user_name, anon_grp1.agg0=SUM(IFNULL(anon_grp2.agg0, 1))}, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0], EST_CARDINALITY=232447.69, EST_COL_STATS={anon_grp1.gcol0=[77482.56, 77482.56, -1.0], anon_grp1.gcol1=[77482.56, 77482.56, -1.0], anon_grp1.agg0=[77482.56, 77482.56, -1.0]}}) Join(groups=[ops.dbo.manager AS m, anon_grp2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[anon_grp2.gcol0 = m.manager_id], LEFT_EXPRESSIONS=[m.manager_id], RIGHT_EXPRESSIONS=[anon_grp2.gcol0], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=232447.69, DEPENDENT_VALUE_SOURCE=$dsc/id1, OUTPUT_COLS=[anon_grp2.gcol1, m.user_name, anon_grp2.agg0], EST_COL_STATS={anon_grp2.gcol1=[232447.69, 232447.69, -1.0], m.user_name=[97.0, 4629.0, -1.0], anon_grp2.agg0=[232447.69, 232447.69, -1.0]}}) Access(groups=[ops.dbo.manager AS m], props={SOURCE_HINT=null, MODEL_ID=Schema name=ops, nameInSource=null, uuid=tid:0015a10b6d7e-0001aeb2-00000000, OUTPUT_COLS=[m.manager_id, m.user_name], EST_CARDINALITY=9258.0, EST_COL_STATS={m.manager_id=[9258.0, 9258.0, 1.0], m.firm_id=[97.0, 4629.0, -1.0], m.email=[97.0, 4629.0, -1.0], m.password=[97.0, 4629.0, -1.0], ...}}) Source(groups=[ops.dbo.manager AS m], props={OUTPUT_COLS=[m.manager_id, m.user_name], EST_COL_STATS={m.manager_id=[9258.0, 9258.0, 0.0], m.firm_id=[97.0, 4629.0, -1.0], m.email=[97.0, 4629.0, -1.0], m.password=[97.0, 4629.0, -1.0], ...}, EST_CARDINALITY=9258.0}) Access(groups=[channel.dbo.service_request AS s], props={SOURCE_HINT=null, MODEL_ID=Schema name=channel, nameInSource=null, uuid=tid:cafba140f5cf-2c0b7d03-00000000, IS_MULTI_SOURCE=true, OUTPUT_COLS=[], EST_COL_STATS={}, EST_CARDINALITY=428788.0, IS_DEPENDENT_SET=true}) Group(groups=[channel.dbo.service_request AS s, anon_grp2], props={GROUP_COLS=[s.staff_id, s.channel], SYMBOL_MAP={anon_grp2.gcol0=s.staff_id, anon_grp2.gcol1=s.channel}, EST_CARDINALITY=428788.0, EST_COL_STATS={}, OUTPUT_COLS=[]}) Select(groups=[channel.dbo.service_request AS s], props={SELECT_CRITERIA=s.staff_id IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[s.staff_id, s.channel], EST_CARDINALITY=857576.0, EST_COL_STATS={s.staff_id=[927.0, 428788.0, -1.0], s.channel=[927.0, 428788.0, 1.0]}}) Source(groups=[channel.dbo.service_request AS s], props={OUTPUT_COLS=[s.staff_id, s.channel], EST_COL_STATS={s.service_request_id=[857576.0, 857576.0, 0.0], s.advisor_id=[927.0, 428788.0, -1.0], s.staff_id=[927.0, 428788.0, -1.0], s.request_type=[927.0, 428788.0, -1.0], ...}, EST_CARDINALITY=857576.0}) ============================================================================ EXECUTING ImplementJoinStrategy AFTER: Project(groups=[anon_grp1]) TupleLimit(groups=[]) Group(groups=[anon_grp2, ops.dbo.manager AS m, anon_grp1]) Join(groups=[ops.dbo.manager AS m, anon_grp2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[anon_grp2.gcol0 = m.manager_id], LEFT_EXPRESSIONS=[m.manager_id], RIGHT_EXPRESSIONS=[anon_grp2.gcol0], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=232447.69, DEPENDENT_VALUE_SOURCE=$dsc/id1, OUTPUT_COLS=[anon_grp2.gcol1, m.user_name, anon_grp2.agg0], EST_COL_STATS={anon_grp2.gcol1=[232447.69, 232447.69, -1.0], m.user_name=[97.0, 4629.0, -1.0], anon_grp2.agg0=[232447.69, 232447.69, -1.0]}, IS_LEFT_DISTINCT=true, SORT_RIGHT=SORT}) Access(groups=[ops.dbo.manager AS m], props={SOURCE_HINT=null, MODEL_ID=Schema name=ops, nameInSource=null, uuid=tid:0015a10b6d7e-0001aeb2-00000000, OUTPUT_COLS=[m.manager_id, m.user_name], EST_CARDINALITY=9258.0, EST_COL_STATS={m.manager_id=[9258.0, 9258.0, 1.0], m.firm_id=[97.0, 4629.0, -1.0], m.email=[97.0, 4629.0, -1.0], m.password=[97.0, 4629.0, -1.0], ...}}) Sort(groups=[], props={SORT_ORDER=ORDER BY m.manager_id, OUTPUT_COLS=[m.manager_id, m.user_name]}) Source(groups=[ops.dbo.manager AS m], props={OUTPUT_COLS=[m.manager_id, m.user_name], EST_COL_STATS={m.manager_id=[9258.0, 9258.0, 0.0], m.firm_id=[97.0, 4629.0, -1.0], m.email=[97.0, 4629.0, -1.0], m.password=[97.0, 4629.0, -1.0], ...}, EST_CARDINALITY=9258.0}) Project(groups=[], props={PROJECT_COLS=[anon_grp2.gcol0], OUTPUT_COLS=[anon_grp2.gcol0]}) Access(groups=[channel.dbo.service_request AS s], props={SOURCE_HINT=null, MODEL_ID=Schema name=channel, nameInSource=null, uuid=tid:cafba140f5cf-2c0b7d03-00000000, IS_MULTI_SOURCE=true, OUTPUT_COLS=[], EST_COL_STATS={}, EST_CARDINALITY=428788.0, IS_DEPENDENT_SET=true}) Group(groups=[channel.dbo.service_request AS s, anon_grp2], props={GROUP_COLS=[s.staff_id, s.channel], SYMBOL_MAP={anon_grp2.gcol0=s.staff_id, anon_grp2.gcol1=s.channel}, EST_CARDINALITY=428788.0, EST_COL_STATS={}, OUTPUT_COLS=[]}) Select(groups=[channel.dbo.service_request AS s], props={SELECT_CRITERIA=s.staff_id IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[s.staff_id, s.channel], EST_CARDINALITY=857576.0, EST_COL_STATS={s.staff_id=[927.0, 428788.0, -1.0], s.channel=[927.0, 428788.0, 1.0]}}) Source(groups=[channel.dbo.service_request AS s], props={OUTPUT_COLS=[s.staff_id, s.channel], EST_COL_STATS={s.service_request_id=[857576.0, 857576.0, 0.0], s.advisor_id=[927.0, 428788.0, -1.0], s.staff_id=[927.0, 428788.0, -1.0], s.request_type=[927.0, 428788.0, -1.0], ...}, EST_CARDINALITY=857576.0}) ============================================================================ EXECUTING MergeCriteria AFTER: Project(groups=[anon_grp1]) TupleLimit(groups=[]) Group(groups=[anon_grp2, ops.dbo.manager AS m, anon_grp1]) Join(groups=[ops.dbo.manager AS m, anon_grp2]) Access(groups=[ops.dbo.manager AS m]) Sort(groups=[]) Source(groups=[ops.dbo.manager AS m]) Project(groups=[]) Access(groups=[channel.dbo.service_request AS s]) Group(groups=[channel.dbo.service_request AS s, anon_grp2]) Select(groups=[channel.dbo.service_request AS s]) Source(groups=[channel.dbo.service_request AS s]) ============================================================================ EXECUTING PlanSorts AFTER: Project(groups=[anon_grp1]) TupleLimit(groups=[]) Group(groups=[anon_grp2, ops.dbo.manager AS m, anon_grp1], props={GROUP_COLS=[anon_grp2.gcol1, m.user_name], SYMBOL_MAP={anon_grp1.gcol0=anon_grp2.gcol1, anon_grp1.gcol1=m.user_name, anon_grp1.agg0=SUM(IFNULL(anon_grp2.agg0, 1))}, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0], EST_CARDINALITY=232447.69, EST_COL_STATS={anon_grp1.gcol0=[77482.56, 77482.56, -1.0], anon_grp1.gcol1=[77482.56, 77482.56, -1.0], anon_grp1.agg0=[77482.56, 77482.56, -1.0]}}) Join(groups=[ops.dbo.manager AS m, anon_grp2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[anon_grp2.gcol0 = m.manager_id], LEFT_EXPRESSIONS=[m.manager_id], RIGHT_EXPRESSIONS=[anon_grp2.gcol0], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=232447.69, DEPENDENT_VALUE_SOURCE=$dsc/id1, OUTPUT_COLS=[anon_grp2.gcol1, m.user_name, anon_grp2.agg0], EST_COL_STATS={anon_grp2.gcol1=[232447.69, 232447.69, -1.0], m.user_name=[97.0, 4629.0, -1.0], anon_grp2.agg0=[232447.69, 232447.69, -1.0]}, IS_LEFT_DISTINCT=true, SORT_RIGHT=SORT}) Access(groups=[ops.dbo.manager AS m]) Sort(groups=[]) Source(groups=[ops.dbo.manager AS m]) Project(groups=[]) Access(groups=[channel.dbo.service_request AS s]) Group(groups=[channel.dbo.service_request AS s, anon_grp2]) Select(groups=[channel.dbo.service_request AS s]) Source(groups=[channel.dbo.service_request AS s]) ============================================================================ EXECUTING CollapseSource AFTER: Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS channel, anon_grp1.gcol1 AS user_name, IFNULL(convert(anon_grp1.agg0, integer), 0) AS expr3], OUTPUT_COLS=[anon_grp1.gcol0 AS channel, anon_grp1.gcol1 AS user_name, IFNULL(convert(anon_grp1.agg0, integer), 0) AS expr3], SOURCE_HINT=null, EST_CARDINALITY=200.0, EST_COL_STATS={anon_grp1.gcol0=[66.666664, 66.666664, -1.0], anon_grp1.gcol1=[66.666664, 66.666664, -1.0], IFNULL(convert(anon_grp1.agg0, integer), 0)=[66.666664, 66.666664, -1.0]}}) TupleLimit(groups=[]) Group(groups=[anon_grp2, ops.dbo.manager AS m, anon_grp1], props={GROUP_COLS=[anon_grp2.gcol1, m.user_name], SYMBOL_MAP={anon_grp1.gcol0=anon_grp2.gcol1, anon_grp1.gcol1=m.user_name, anon_grp1.agg0=SUM(IFNULL(anon_grp2.agg0, 1))}, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0], EST_CARDINALITY=232447.69, EST_COL_STATS={anon_grp1.gcol0=[77482.56, 77482.56, -1.0], anon_grp1.gcol1=[77482.56, 77482.56, -1.0], anon_grp1.agg0=[77482.56, 77482.56, -1.0]}}) Join(groups=[ops.dbo.manager AS m, anon_grp2]) Access(groups=[ops.dbo.manager AS m], props={SOURCE_HINT=null, MODEL_ID=Schema name=ops, nameInSource=null, uuid=tid:0015a10b6d7e-0001aeb2-00000000, OUTPUT_COLS=[m.manager_id, m.user_name], EST_CARDINALITY=9258.0, EST_COL_STATS={m.manager_id=[9258.0, 9258.0, 1.0], m.firm_id=[97.0, 4629.0, -1.0], m.email=[97.0, 4629.0, -1.0], m.password=[97.0, 4629.0, -1.0], ...}, ATOMIC_REQUEST=SELECT m.manager_id, m.user_name FROM ops.dbo.manager AS m ORDER BY m.manager_id}) Project(groups=[], props={PROJECT_COLS=[anon_grp2.gcol0], OUTPUT_COLS=[anon_grp2.gcol0]}) Access(groups=[channel.dbo.service_request AS s], props={SOURCE_HINT=null, MODEL_ID=Schema name=channel, nameInSource=null, uuid=tid:cafba140f5cf-2c0b7d03-00000000, IS_MULTI_SOURCE=true, OUTPUT_COLS=[], EST_COL_STATS={}, EST_CARDINALITY=428788.0, IS_DEPENDENT_SET=true, ATOMIC_REQUEST=SELECT 1 FROM channel.dbo.service_request AS s WHERE s.staff_id IN () GROUP BY s.staff_id, s.channel}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = ProjectNode(3) output=[anon_grp1.gcol0 AS channel, anon_grp1.gcol1 AS user_name, IFNULL(convert(anon_grp1.agg0, integer), 0) AS expr3] [anon_grp1.gcol0 AS channel, anon_grp1.gcol1 AS user_name, IFNULL(convert(anon_grp1.agg0, integer), 0) AS expr3] LimitNode(4) output=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0] limit 200 GroupingNode(5) output=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0] [anon_grp2.gcol1, m.user_name]{anon_grp1.gcol0=anon_grp2.gcol1, anon_grp1.gcol1=m.user_name, anon_grp1.agg0=SUM(IFNULL(anon_grp2.agg0, 1))} JoinNode(6) [Dependent] [ENHANCED SORT JOIN (ALREADY_SORTED/SORT)] [INNER JOIN] criteria=[m.manager_id=anon_grp2.gcol0] output=[anon_grp2.gcol1, m.user_name, anon_grp2.agg0] AccessNode(7) output=[m.manager_id, m.user_name] SELECT g_0.manager_id AS c_0, g_0.user_name AS c_1 FROM ops.dbo.manager AS g_0 ORDER BY c_0 ProjectNode(8) output=[anon_grp2.gcol0] [anon_grp2.gcol0] DependentAccessNode(9) output=[] SELECT 1 FROM channel.dbo.service_request AS g_0 WHERE g_0.staff_id IN () GROUP BY g_0.staff_id, g_0.channel ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: ProjectNode(3) output=[anon_grp1.gcol0 AS channel, anon_grp1.gcol1 AS user_name, IFNULL(convert(anon_grp1.agg0, integer), 0) AS expr3] [anon_grp1.gcol0 AS channel, anon_grp1.gcol1 AS user_name, IFNULL(convert(anon_grp1.agg0, integer), 0) AS expr3] LimitNode(4) output=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0] limit 200 GroupingNode(5) output=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0] [anon_grp2.gcol1, m.user_name]{anon_grp1.gcol0=anon_grp2.gcol1, anon_grp1.gcol1=m.user_name, anon_grp1.agg0=SUM(IFNULL(anon_grp2.agg0, 1))} JoinNode(6) [Dependent] [ENHANCED SORT JOIN (ALREADY_SORTED/SORT)] [INNER JOIN] criteria=[m.manager_id=anon_grp2.gcol0] output=[anon_grp2.gcol1, m.user_name, anon_grp2.agg0] AccessNode(7) output=[m.manager_id, m.user_name] SELECT g_0.manager_id AS c_0, g_0.user_name AS c_1 FROM ops.dbo.manager AS g_0 ORDER BY c_0 ProjectNode(8) output=[anon_grp2.gcol0] [anon_grp2.gcol0] DependentAccessNode(9) output=[] SELECT 1 FROM channel.dbo.service_request AS g_0 WHERE g_0.staff_id IN () GROUP BY g_0.staff_id, g_0.channel ============================================================================