============================================================================
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 WHERE s.channel IN ('oak', 'cypress') 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 WHERE s.channel IN ('oak', 'cypress') 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 WHERE s.channel IN ('oak', 'cypress') 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(*)}})
      Select(groups=[channel.dbo.service_request AS s], props={SELECT_CRITERIA=s.channel IN ('oak', 'cypress')})
        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(*)}})
      Select(groups=[channel.dbo.service_request AS s], props={SELECT_CRITERIA=s.channel IN ('oak', 'cypress')})
        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 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(*)}})
      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})
          Select(groups=[channel.dbo.service_request AS s], props={SELECT_CRITERIA=s.channel IN ('oak', 'cypress')})
            Source(groups=[channel.dbo.service_request AS s])
        Access(groups=[ops.dbo.manager AS m])
          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])
          Select(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})
          Select(groups=[channel.dbo.service_request AS s], props={SELECT_CRITERIA=s.channel IN ('oak', 'cypress'), 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})
          Select(groups=[channel.dbo.service_request AS s])
            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])
          Select(groups=[channel.dbo.service_request AS s], props={SELECT_CRITERIA=s.channel IN ('oak', 'cypress'), OUTPUT_COLS=null, IS_COPIED=true})
            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})
          Select(groups=[channel.dbo.service_request AS s], props={SELECT_CRITERIA=s.channel IN ('oak', 'cypress'), OUTPUT_COLS=null, IS_COPIED=true})
            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=[channel.dbo.service_request AS s, ops.dbo.manager AS m], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP})
          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=1850.2179, EST_COL_STATS={s.service_request_id=[1850.2179, 1850.2179, 1.0], s.advisor_id=[1.9999999, 925.10895, -1.0], s.staff_id=[1.9999999, 925.10895, -1.0], s.request_type=[1.9999999, 925.10895, -1.0], ...}})
            Select(groups=[channel.dbo.service_request AS s], props={SELECT_CRITERIA=s.channel IN ('oak', 'cypress'), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=1850.2179, EST_COL_STATS={s.service_request_id=[1850.2179, 1850.2179, 1.0], s.advisor_id=[1.9999999, 925.10895, -1.0], s.staff_id=[1.9999999, 925.10895, -1.0], s.request_type=[1.9999999, 925.10895, -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})
          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})


============================================================================
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=[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])
          Select(groups=[channel.dbo.service_request AS s], props={SELECT_CRITERIA=s.channel IN ('oak', 'cypress'), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=1850.2179, EST_COL_STATS={s.service_request_id=[1850.2179, 1850.2179, 1.0], s.advisor_id=[1.9999999, 925.10895, -1.0], s.staff_id=[1.9999999, 925.10895, -1.0], s.request_type=[1.9999999, 925.10895, -1.0], ...}})
            Source(groups=[channel.dbo.service_request AS s])
        Access(groups=[ops.dbo.manager AS m])
          Source(groups=[ops.dbo.manager AS m])


============================================================================
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]})
        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=1850.2179, EST_COL_STATS={s.service_request_id=[1850.2179, 1850.2179, 1.0], s.advisor_id=[1.9999999, 925.10895, -1.0], s.staff_id=[1.9999999, 925.10895, -1.0], s.request_type=[1.9999999, 925.10895, -1.0], ...}})
          Select(groups=[channel.dbo.service_request AS s])
            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, 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])


============================================================================
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=[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])
          Select(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 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=[channel.dbo.service_request AS s, ops.dbo.manager AS m], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[s.staff_id = m.manager_id], LEFT_EXPRESSIONS=[s.staff_id], RIGHT_EXPRESSIONS=[m.manager_id], NON_EQUI_JOIN_CRITERIA=[]})
        Access(groups=[channel.dbo.service_request AS s])
          Select(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 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=[channel.dbo.service_request AS s, ops.dbo.manager AS m], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[s.staff_id = m.manager_id], LEFT_EXPRESSIONS=[s.staff_id], RIGHT_EXPRESSIONS=[m.manager_id], NON_EQUI_JOIN_CRITERIA=[]})
        Access(groups=[channel.dbo.service_request AS s])
          Select(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 PushAggregates

AFTER: 
TupleLimit(groups=[])
  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=MERGE, JOIN_CRITERIA=[s.staff_id = m.manager_id], LEFT_EXPRESSIONS=[s.staff_id], RIGHT_EXPRESSIONS=[m.manager_id], NON_EQUI_JOIN_CRITERIA=[]})
        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=1850.2179, EST_COL_STATS={s.service_request_id=[1850.2179, 1850.2179, 1.0], s.advisor_id=[1.9999999, 925.10895, -1.0], s.staff_id=[1.9999999, 925.10895, -1.0], s.request_type=[1.9999999, 925.10895, -1.0], ...}})
          Select(groups=[channel.dbo.service_request AS s])
            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, 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})


============================================================================
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=[channel.dbo.service_request AS s, ops.dbo.manager AS m], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[s.staff_id = m.manager_id], LEFT_EXPRESSIONS=[s.staff_id], RIGHT_EXPRESSIONS=[m.manager_id], NON_EQUI_JOIN_CRITERIA=[], DEPENDENT_VALUE_SOURCE=$dsc/id2})
        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=1850.2179, EST_COL_STATS={s.service_request_id=[1850.2179, 1850.2179, 1.0], s.advisor_id=[1.9999999, 925.10895, -1.0], s.staff_id=[1.9999999, 925.10895, -1.0], s.request_type=[1.9999999, 925.10895, -1.0], ...}})
          Select(groups=[channel.dbo.service_request AS s], props={SELECT_CRITERIA=s.channel IN ('oak', 'cypress'), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=1850.2179, EST_COL_STATS={s.service_request_id=[1850.2179, 1850.2179, 1.0], s.advisor_id=[1.9999999, 925.10895, -1.0], s.staff_id=[1.9999999, 925.10895, -1.0], s.request_type=[1.9999999, 925.10895, -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})
        Select(groups=[ops.dbo.manager AS m], props={SELECT_CRITERIA=m.manager_id IN (<dependent values>), IS_DEPENDENT_SET=true})
          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})


============================================================================
EXECUTING PushSelectCriteria

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=MERGE, JOIN_CRITERIA=[s.staff_id = m.manager_id], LEFT_EXPRESSIONS=[s.staff_id], RIGHT_EXPRESSIONS=[m.manager_id], NON_EQUI_JOIN_CRITERIA=[], DEPENDENT_VALUE_SOURCE=$dsc/id2})
        Access(groups=[channel.dbo.service_request AS s])
          Select(groups=[channel.dbo.service_request AS s], props={SELECT_CRITERIA=s.channel IN ('oak', 'cypress'), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=1850.2179, EST_COL_STATS={s.service_request_id=[1850.2179, 1850.2179, 1.0], s.advisor_id=[1.9999999, 925.10895, -1.0], s.staff_id=[1.9999999, 925.10895, -1.0], s.request_type=[1.9999999, 925.10895, -1.0], ...}})
            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, 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], ...}, IS_DEPENDENT_SET=true})
          Select(groups=[ops.dbo.manager AS m], props={SELECT_CRITERIA=m.manager_id IN (<dependent values>), IS_DEPENDENT_SET=true, IS_PUSHED=true})
            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})


============================================================================
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=MERGE, JOIN_CRITERIA=[s.staff_id = m.manager_id], LEFT_EXPRESSIONS=[s.staff_id], RIGHT_EXPRESSIONS=[m.manager_id], NON_EQUI_JOIN_CRITERIA=[], DEPENDENT_VALUE_SOURCE=$dsc/id2, 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, EST_CARDINALITY=1850.2179, EST_COL_STATS={s.service_request_id=[1850.2179, 1850.2179, 1.0], s.advisor_id=[1.9999999, 925.10895, -1.0], s.staff_id=[1.9999999, 925.10895, -1.0], s.request_type=[1.9999999, 925.10895, -1.0], ...}})
          Select(groups=[channel.dbo.service_request AS s], props={SELECT_CRITERIA=s.channel IN ('oak', 'cypress'), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=1850.2179, EST_COL_STATS={s.service_request_id=[1850.2179, 1850.2179, 1.0], s.advisor_id=[1.9999999, 925.10895, -1.0], s.staff_id=[1.9999999, 925.10895, -1.0], s.request_type=[1.9999999, 925.10895, -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})
        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], ...}, IS_DEPENDENT_SET=true})
          Select(groups=[ops.dbo.manager AS m], props={SELECT_CRITERIA=m.manager_id IN (<dependent values>), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=null})
            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})


============================================================================
EXECUTING AssignOutputElements

AFTER: 
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=200, OUTPUT_COLS=[anon_grp0.gcol0 AS channel, anon_grp0.gcol1 AS user_name, anon_grp0.agg0 AS expr3]})
  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=[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(*)}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0]})
      Join(groups=[channel.dbo.service_request AS s, ops.dbo.manager AS m], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[s.staff_id = m.manager_id], LEFT_EXPRESSIONS=[s.staff_id], RIGHT_EXPRESSIONS=[m.manager_id], NON_EQUI_JOIN_CRITERIA=[], DEPENDENT_VALUE_SOURCE=$dsc/id2, OUTPUT_COLS=[s.channel, m.user_name]})
        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=[s.staff_id, s.channel], EST_CARDINALITY=1850.2179, EST_COL_STATS={s.service_request_id=[1850.2179, 1850.2179, 1.0], s.advisor_id=[1.9999999, 925.10895, -1.0], s.staff_id=[1.9999999, 925.10895, -1.0], s.request_type=[1.9999999, 925.10895, -1.0], ...}})
          Select(groups=[channel.dbo.service_request AS s], props={SELECT_CRITERIA=s.channel IN ('oak', 'cypress'), OUTPUT_COLS=[s.staff_id, s.channel], IS_COPIED=true, EST_CARDINALITY=1850.2179, EST_COL_STATS={s.service_request_id=[1850.2179, 1850.2179, 1.0], s.advisor_id=[1.9999999, 925.10895, -1.0], s.staff_id=[1.9999999, 925.10895, -1.0], s.request_type=[1.9999999, 925.10895, -1.0], ...}})
            Source(groups=[channel.dbo.service_request AS s], props={OUTPUT_COLS=[s.channel, s.staff_id], 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})
        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], ...}, IS_DEPENDENT_SET=true})
          Select(groups=[ops.dbo.manager AS m], props={SELECT_CRITERIA=m.manager_id IN (<dependent values>), IS_DEPENDENT_SET=true, IS_PUSHED=true, 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})


============================================================================
EXECUTING PushLimit

AFTER: 
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=[anon_grp0.gcol0 AS channel, anon_grp0.gcol1 AS user_name, anon_grp0.agg0 AS expr3], SOURCE_HINT=null})
  TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=200, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0]})
    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=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0]})
      Join(groups=[channel.dbo.service_request AS s, ops.dbo.manager AS m])
        Access(groups=[channel.dbo.service_request AS s])
          Select(groups=[channel.dbo.service_request AS s])
            Source(groups=[channel.dbo.service_request AS s])
        Access(groups=[ops.dbo.manager AS m])
          Select(groups=[ops.dbo.manager AS m])
            Source(groups=[ops.dbo.manager AS m])


============================================================================
EXECUTING CalculateCost

AFTER: 
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=[anon_grp0.gcol0 AS channel, anon_grp0.gcol1 AS user_name, anon_grp0.agg0 AS expr3], SOURCE_HINT=null, EST_CARDINALITY=119.253105, EST_COL_STATS={anon_grp0.gcol0=[39.751034, 39.751034, -1.0], anon_grp0.gcol1=[39.751034, 39.751034, -1.0], anon_grp0.agg0=[39.751034, 39.751034, -1.0]}})
  TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=200, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0], EST_CARDINALITY=119.253105, EST_COL_STATS={anon_grp0.gcol0=[39.751034, 39.751034, -1.0], anon_grp0.gcol1=[39.751034, 39.751034, -1.0], anon_grp0.agg0=[39.751034, 39.751034, -1.0]}})
    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=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0], EST_CARDINALITY=119.253105, EST_COL_STATS={anon_grp0.gcol0=[39.751034, 39.751034, -1.0], anon_grp0.gcol1=[39.751034, 39.751034, -1.0], anon_grp0.agg0=[39.751034, 39.751034, -1.0]}})
      Join(groups=[channel.dbo.service_request AS s, ops.dbo.manager AS m], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[s.staff_id = m.manager_id], LEFT_EXPRESSIONS=[s.staff_id], RIGHT_EXPRESSIONS=[m.manager_id], NON_EQUI_JOIN_CRITERIA=[], DEPENDENT_VALUE_SOURCE=$dsc/id2, OUTPUT_COLS=[s.channel, m.user_name], EST_CARDINALITY=1850.218, EST_COL_STATS={s.channel=[1.0, 1.0, 1.0], m.user_name=[4.8568573, 231.77725, -1.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=[s.staff_id, s.channel], EST_CARDINALITY=1850.2179, EST_COL_STATS={s.service_request_id=[1850.2179, 1850.2179, 1.0], s.advisor_id=[1.9999999, 925.10895, -1.0], s.staff_id=[1.9999999, 925.10895, -1.0], s.request_type=[1.9999999, 925.10895, -1.0], ...}})
          Select(groups=[channel.dbo.service_request AS s], props={SELECT_CRITERIA=s.channel IN ('oak', 'cypress'), OUTPUT_COLS=[s.staff_id, s.channel], IS_COPIED=true, EST_CARDINALITY=1850.2179, EST_COL_STATS={s.service_request_id=[1850.2179, 1850.2179, 1.0], s.advisor_id=[1.9999999, 925.10895, -1.0], s.staff_id=[1.9999999, 925.10895, -1.0], s.request_type=[1.9999999, 925.10895, -1.0], ...}})
            Source(groups=[channel.dbo.service_request AS s], props={OUTPUT_COLS=[s.channel, s.staff_id], 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})
        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=463.5545, EST_COL_STATS={m.manager_id=[463.5545, 463.5545, 1.0], m.user_name=[4.8568573, 231.77725, -1.0]}, IS_DEPENDENT_SET=true})
          Select(groups=[ops.dbo.manager AS m], props={SELECT_CRITERIA=m.manager_id IN (<dependent values>), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[m.manager_id, m.user_name], EST_CARDINALITY=463.5545, EST_COL_STATS={m.manager_id=[463.5545, 463.5545, 1.0], m.user_name=[4.8568573, 231.77725, -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})


============================================================================
EXECUTING ImplementJoinStrategy

AFTER: 
Project(groups=[anon_grp0])
  TupleLimit(groups=[])
    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=ENHANCED_SORT, JOIN_CRITERIA=[s.staff_id = m.manager_id], LEFT_EXPRESSIONS=[s.staff_id], RIGHT_EXPRESSIONS=[m.manager_id], NON_EQUI_JOIN_CRITERIA=[], DEPENDENT_VALUE_SOURCE=$dsc/id2, OUTPUT_COLS=[s.channel, m.user_name], EST_CARDINALITY=1850.218, EST_COL_STATS={s.channel=[1.0, 1.0, 1.0], m.user_name=[4.8568573, 231.77725, -1.0]}, SORT_LEFT=SORT, IS_RIGHT_DISTINCT=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=[s.staff_id, s.channel], EST_CARDINALITY=1850.2179, EST_COL_STATS={s.service_request_id=[1850.2179, 1850.2179, 1.0], s.advisor_id=[1.9999999, 925.10895, -1.0], s.staff_id=[1.9999999, 925.10895, -1.0], s.request_type=[1.9999999, 925.10895, -1.0], ...}})
          Select(groups=[channel.dbo.service_request AS s], props={SELECT_CRITERIA=s.channel IN ('oak', 'cypress'), OUTPUT_COLS=[s.staff_id, s.channel], IS_COPIED=true, EST_CARDINALITY=1850.2179, EST_COL_STATS={s.service_request_id=[1850.2179, 1850.2179, 1.0], s.advisor_id=[1.9999999, 925.10895, -1.0], s.staff_id=[1.9999999, 925.10895, -1.0], s.request_type=[1.9999999, 925.10895, -1.0], ...}})
            Source(groups=[channel.dbo.service_request AS s], props={OUTPUT_COLS=[s.channel, s.staff_id], 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})
        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=463.5545, EST_COL_STATS={m.manager_id=[463.5545, 463.5545, 1.0], m.user_name=[4.8568573, 231.77725, -1.0]}, IS_DEPENDENT_SET=true})
          Sort(groups=[], props={SORT_ORDER=ORDER BY m.manager_id, OUTPUT_COLS=[m.manager_id, m.user_name]})
            Select(groups=[ops.dbo.manager AS m], props={SELECT_CRITERIA=m.manager_id IN (<dependent values>), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[m.manager_id, m.user_name], EST_CARDINALITY=463.5545, EST_COL_STATS={m.manager_id=[463.5545, 463.5545, 1.0], m.user_name=[4.8568573, 231.77725, -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})


============================================================================
EXECUTING MergeCriteria

AFTER: 
Project(groups=[anon_grp0])
  TupleLimit(groups=[])
    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])
        Access(groups=[channel.dbo.service_request AS s])
          Select(groups=[channel.dbo.service_request AS s])
            Source(groups=[channel.dbo.service_request AS s])
        Access(groups=[ops.dbo.manager AS m])
          Sort(groups=[])
            Select(groups=[ops.dbo.manager AS m])
              Source(groups=[ops.dbo.manager AS m])


============================================================================
EXECUTING PlanSorts

AFTER: 
Project(groups=[anon_grp0])
  TupleLimit(groups=[])
    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=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0], EST_CARDINALITY=119.253105, EST_COL_STATS={anon_grp0.gcol0=[39.751034, 39.751034, -1.0], anon_grp0.gcol1=[39.751034, 39.751034, -1.0], anon_grp0.agg0=[39.751034, 39.751034, -1.0]}})
      Join(groups=[channel.dbo.service_request AS s, ops.dbo.manager AS m], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[s.staff_id = m.manager_id], LEFT_EXPRESSIONS=[s.staff_id], RIGHT_EXPRESSIONS=[m.manager_id], NON_EQUI_JOIN_CRITERIA=[], DEPENDENT_VALUE_SOURCE=$dsc/id2, OUTPUT_COLS=[s.channel, m.user_name], EST_CARDINALITY=1850.218, EST_COL_STATS={s.channel=[1.0, 1.0, 1.0], m.user_name=[4.8568573, 231.77725, -1.0]}, SORT_LEFT=SORT, IS_RIGHT_DISTINCT=true})
        Access(groups=[channel.dbo.service_request AS s])
          Select(groups=[channel.dbo.service_request AS s])
            Source(groups=[channel.dbo.service_request AS s])
        Access(groups=[ops.dbo.manager AS m])
          Sort(groups=[])
            Select(groups=[ops.dbo.manager AS m])
              Source(groups=[ops.dbo.manager AS m])


============================================================================
EXECUTING CollapseSource

AFTER: 
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=[anon_grp0.gcol0 AS channel, anon_grp0.gcol1 AS user_name, anon_grp0.agg0 AS expr3], SOURCE_HINT=null, EST_CARDINALITY=119.253105, EST_COL_STATS={anon_grp0.gcol0=[39.751034, 39.751034, -1.0], anon_grp0.gcol1=[39.751034, 39.751034, -1.0], anon_grp0.agg0=[39.751034, 39.751034, -1.0]}})
  TupleLimit(groups=[])
    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=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0], EST_CARDINALITY=119.253105, EST_COL_STATS={anon_grp0.gcol0=[39.751034, 39.751034, -1.0], anon_grp0.gcol1=[39.751034, 39.751034, -1.0], anon_grp0.agg0=[39.751034, 39.751034, -1.0]}})
      Join(groups=[channel.dbo.service_request AS s, 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=[s.staff_id, s.channel], EST_CARDINALITY=1850.2179, EST_COL_STATS={s.service_request_id=[1850.2179, 1850.2179, 1.0], s.advisor_id=[1.9999999, 925.10895, -1.0], s.staff_id=[1.9999999, 925.10895, -1.0], s.request_type=[1.9999999, 925.10895, -1.0], ...}, ATOMIC_REQUEST=SELECT s.staff_id, s.channel FROM channel.dbo.service_request AS s WHERE s.channel IN ('oak', 'cypress')})
        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=463.5545, EST_COL_STATS={m.manager_id=[463.5545, 463.5545, 1.0], m.user_name=[4.8568573, 231.77725, -1.0]}, IS_DEPENDENT_SET=true, ATOMIC_REQUEST=SELECT m.manager_id, m.user_name FROM ops.dbo.manager AS m WHERE m.manager_id IN (<dependent values>) ORDER BY m.manager_id})


============================================================================
CONVERTING PLAN TREE TO PROCESS TREE

PROCESS PLAN = 
ProjectNode(1) output=[anon_grp0.gcol0 AS channel, anon_grp0.gcol1 AS user_name, anon_grp0.agg0 AS expr3] [anon_grp0.gcol0 AS channel, anon_grp0.gcol1 AS user_name, anon_grp0.agg0 AS expr3]
  LimitNode(2) output=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0] limit 200
    GroupingNode(3) output=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0] [s.channel, m.user_name]{anon_grp0.gcol0=s.channel, anon_grp0.gcol1=m.user_name, anon_grp0.agg0=COUNT(*)}
      JoinNode(4) [Dependent] [ENHANCED SORT JOIN (SORT/ALREADY_SORTED)] [INNER JOIN] criteria=[s.staff_id=m.manager_id] output=[s.channel, m.user_name]
        AccessNode(5) output=[s.staff_id, s.channel] SELECT g_0.staff_id, g_0.channel FROM channel.dbo.service_request AS g_0 WHERE g_0.channel IN ('oak', 'cypress')
        DependentAccessNode(6) 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 WHERE g_0.manager_id IN (<dependent values>) ORDER BY c_0

============================================================================

----------------------------------------------------------------------------
OPTIMIZATION COMPLETE:
PROCESSOR PLAN:
ProjectNode(1) output=[anon_grp0.gcol0 AS channel, anon_grp0.gcol1 AS user_name, anon_grp0.agg0 AS expr3] [anon_grp0.gcol0 AS channel, anon_grp0.gcol1 AS user_name, anon_grp0.agg0 AS expr3]
  LimitNode(2) output=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0] limit 200
    GroupingNode(3) output=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0] [s.channel, m.user_name]{anon_grp0.gcol0=s.channel, anon_grp0.gcol1=m.user_name, anon_grp0.agg0=COUNT(*)}
      JoinNode(4) [Dependent] [ENHANCED SORT JOIN (SORT/ALREADY_SORTED)] [INNER JOIN] criteria=[s.staff_id=m.manager_id] output=[s.channel, m.user_name]
        AccessNode(5) output=[s.staff_id, s.channel] SELECT g_0.staff_id, g_0.channel FROM channel.dbo.service_request AS g_0 WHERE g_0.channel IN ('oak', 'cypress')
        DependentAccessNode(6) 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 WHERE g_0.manager_id IN (<dependent values>) ORDER BY c_0

============================================================================