============================================================================
USER COMMAND:
SELECT gd.PatientID, ip.production FROM izisprod.prod_P_GeneralData AS gd INNER JOIN (SELECT X.*, izisviews.pr_patient_in_production.patientid AS patientid FROM (EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid)) AS X) AS ip ON ip.patientid = gd.PatientID WHERE gd.Status = 1 LIMIT 100

----------------------------------------------------------------------------
OPTIMIZE: 
SELECT gd.PatientID, ip.production FROM izisprod.prod_P_GeneralData AS gd INNER JOIN (SELECT X.*, izisviews.pr_patient_in_production.patientid AS patientid FROM (EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid)) AS X) AS ip ON ip.patientid = gd.PatientID WHERE gd.Status = 1 LIMIT 100

----------------------------------------------------------------------------
GENERATE CANONICAL: 
SELECT gd.PatientID, ip.production FROM izisprod.prod_P_GeneralData AS gd INNER JOIN (SELECT X.*, izisviews.pr_patient_in_production.patientid AS patientid FROM (EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid)) AS X) AS ip ON ip.patientid = gd.PatientID WHERE gd.Status = 1 LIMIT 100

----------------------------------------------------------------------------
OPTIMIZE: 
BEGIN
DECLARE boolean VARIABLES.production = (SELECT COUNT(*) = 1 AS production FROM izisprod.prod_P_GeneralData AS gd WHERE (gd.PatientID = izisviews.pr_patient_in_production.patientid) AND ((gd.Status = 1) OR ((gd.Status >= 4) AND (gd.Status <> 5))));
RETURN VARIABLES.production;
END

####################################################
PROCEDURE COMMAND: BEGIN
DECLARE boolean VARIABLES.production = (SELECT COUNT(*) = 1 AS production FROM izisprod.prod_P_GeneralData AS gd WHERE (gd.PatientID = izisviews.pr_patient_in_production.patientid) AND ((gd.Status = 1) OR ((gd.Status >= 4) AND (gd.Status <> 5))));
RETURN VARIABLES.production;
END
OPTIMIZING SUB-COMMANDS: 

----------------------------------------------------------------------------
OPTIMIZE: 
SELECT COUNT(*) = 1 AS production FROM izisprod.prod_P_GeneralData AS gd WHERE (gd.PatientID = izisviews.pr_patient_in_production.patientid) AND ((gd.Status = 1) OR ((gd.Status >= 4) AND (gd.Status <> 5)))

----------------------------------------------------------------------------
GENERATE CANONICAL: 
SELECT COUNT(*) = 1 AS production FROM izisprod.prod_P_GeneralData AS gd WHERE (gd.PatientID = izisviews.pr_patient_in_production.patientid) AND ((gd.Status = 1) OR ((gd.Status >= 4) AND (gd.Status <> 5)))

CANONICAL PLAN: 
Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 = 1 AS production]})
  Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}})
    Select(groups=[izisprod.prod_P_GeneralData AS gd], props={SELECT_CRITERIA=(gd.Status = 1) OR ((gd.Status >= 4) AND (gd.Status <> 5))})
      Select(groups=[izisprod.prod_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.PatientID = izisviews.pr_patient_in_production.patientid})
        Source(groups=[izisprod.prod_P_GeneralData AS gd])


============================================================================
EXECUTING PlaceAccess

AFTER: 
Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 = 1 AS production]})
  Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}})
    Select(groups=[izisprod.prod_P_GeneralData AS gd], props={SELECT_CRITERIA=(gd.Status = 1) OR ((gd.Status >= 4) AND (gd.Status <> 5))})
      Select(groups=[izisprod.prod_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.PatientID = izisviews.pr_patient_in_production.patientid})
        Access(groups=[izisprod.prod_P_GeneralData AS gd], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04})
          Source(groups=[izisprod.prod_P_GeneralData AS gd])


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

AFTER: 
Project(groups=[anon_grp0])
  Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}})
    Access(groups=[izisprod.prod_P_GeneralData AS gd], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04})
      Select(groups=[izisprod.prod_P_GeneralData AS gd], props={SELECT_CRITERIA=(gd.PatientID = izisviews.pr_patient_in_production.patientid) AND ((gd.Status = 1) OR ((gd.Status >= 4) AND (gd.Status <> 5)))})
        Source(groups=[izisprod.prod_P_GeneralData AS gd])


============================================================================
EXECUTING CleanCriteria

AFTER: 
Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 = 1 AS production], OUTPUT_COLS=null})
  Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=null})
    Access(groups=[izisprod.prod_P_GeneralData AS gd], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null})
      Select(groups=[izisprod.prod_P_GeneralData AS gd], props={SELECT_CRITERIA=(gd.PatientID = izisviews.pr_patient_in_production.patientid) AND ((gd.Status = 1) OR ((gd.Status >= 4) AND (gd.Status <> 5))), OUTPUT_COLS=null})
        Source(groups=[izisprod.prod_P_GeneralData AS gd], props={OUTPUT_COLS=null})


============================================================================
EXECUTING RaiseAccess

AFTER: 
Access(groups=[anon_grp0], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null})
  Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 = 1 AS production], OUTPUT_COLS=null})
    Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=null})
      Select(groups=[izisprod.prod_P_GeneralData AS gd], props={SELECT_CRITERIA=(gd.PatientID = izisviews.pr_patient_in_production.patientid) AND ((gd.Status = 1) OR ((gd.Status >= 4) AND (gd.Status <> 5))), OUTPUT_COLS=null})
        Source(groups=[izisprod.prod_P_GeneralData AS gd])


============================================================================
EXECUTING PushAggregates

AFTER: 
Access(groups=[anon_grp0])
  Project(groups=[anon_grp0])
    Group(groups=[anon_grp0])
      Select(groups=[izisprod.prod_P_GeneralData AS gd])
        Source(groups=[izisprod.prod_P_GeneralData AS gd])


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

AFTER: 
Access(groups=[anon_grp0], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[anon_grp0.agg0 = 1 AS production]})
  Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 = 1 AS production], OUTPUT_COLS=[anon_grp0.agg0 = 1 AS production]})
    Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp0.agg0]})
      Select(groups=[izisprod.prod_P_GeneralData AS gd], props={SELECT_CRITERIA=(gd.PatientID = izisviews.pr_patient_in_production.patientid) AND ((gd.Status = 1) OR ((gd.Status >= 4) AND (gd.Status <> 5))), OUTPUT_COLS=[]})
        Source(groups=[izisprod.prod_P_GeneralData AS gd], props={OUTPUT_COLS=[gd.PatientID, gd.Status]})


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

AFTER: 
Access(groups=[anon_grp0], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[anon_grp0.agg0 = 1 AS production], EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp0.agg0 = 1=[1.0, 1.0, -1.0]}})
  Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 = 1 AS production], OUTPUT_COLS=[anon_grp0.agg0 = 1 AS production], EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp0.agg0 = 1=[1.0, 1.0, -1.0]}})
    Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp0.agg0], EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp0.agg0=[1.0, 1.0, -1.0]}})
      Select(groups=[izisprod.prod_P_GeneralData AS gd], props={SELECT_CRITERIA=(gd.PatientID = izisviews.pr_patient_in_production.patientid) AND ((gd.Status = 1) OR ((gd.Status >= 4) AND (gd.Status <> 5))), OUTPUT_COLS=[], EST_CARDINALITY=13.75, EST_COL_STATS={}})
        Source(groups=[izisprod.prod_P_GeneralData AS gd], props={OUTPUT_COLS=[gd.PatientID, gd.Status], EST_COL_STATS={gd.PatientID=[20.0, 200.0, -1.0], gd.Status=[20.0, 200.0, -1.0]}, EST_CARDINALITY=400.0})


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

AFTER: 
Access(groups=[anon_grp0])
  Project(groups=[anon_grp0])
    Group(groups=[anon_grp0])
      Select(groups=[izisprod.prod_P_GeneralData AS gd])
        Source(groups=[izisprod.prod_P_GeneralData AS gd])


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

AFTER: 
Access(groups=[anon_grp0])
  Project(groups=[anon_grp0])
    Group(groups=[anon_grp0])
      Select(groups=[izisprod.prod_P_GeneralData AS gd])
        Source(groups=[izisprod.prod_P_GeneralData AS gd])


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

AFTER: 
Access(groups=[anon_grp0], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[anon_grp0.agg0 = 1 AS production], EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp0.agg0 = 1=[1.0, 1.0, -1.0]}, ATOMIC_REQUEST=SELECT COUNT(*) = 1 AS production FROM izisprod.prod_P_GeneralData AS gd WHERE (gd.PatientID = izisviews.pr_patient_in_production.patientid) AND ((gd.Status = 1) OR ((gd.Status >= 4) AND (gd.Status <> 5)))})


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

PROCESS PLAN = 
AccessNode(1) output=[anon_grp0.agg0 = 1 AS production] SELECT COUNT(*) = 1 FROM izisprod.prod_P_GeneralData AS g_0 WHERE (g_0.PatientID = izisviews.pr_patient_in_production.patientid) AND ((g_0.Status = 1) OR ((g_0.Status >= 4) AND (g_0.Status <> 5)))

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

----------------------------------------------------------------------------
OPTIMIZATION COMPLETE:
PROCESSOR PLAN:
AccessNode(1) output=[anon_grp0.agg0 = 1 AS production] SELECT COUNT(*) = 1 FROM izisprod.prod_P_GeneralData AS g_0 WHERE (g_0.PatientID = izisviews.pr_patient_in_production.patientid) AND ((g_0.Status = 1) OR ((g_0.Status >= 4) AND (g_0.Status <> 5)))

============================================================================
	ASSIGNMENT
DECLARE boolean VARIABLES.production = (SELECT anon_grp0.agg0 = 1 AS production FROM izisprod.prod_P_GeneralData AS gd WHERE (gd.PatientID = izisviews.pr_patient_in_production.patientid) AND ((gd.Status = 1) OR ((gd.Status >= 4) AND (gd.Status <> 5))));
	ASSIGNMENT
RETURN VARIABLES.production;

####################################################
####################################################
PROCEDURE PLAN :ProcedurePlan:
PROGRAM counter 0
0:  ASSIGNMENT INSTRUCTION: VARIABLES.production
1:  ASSIGNMENT INSTRUCTION: izisviews.pr_patient_in_production.production
2:  RETURN

####################################################

----------------------------------------------------------------------------
OPTIMIZATION COMPLETE:
PROCESSOR PLAN:
ProcedurePlan:
PROGRAM counter 0
0:  ASSIGNMENT INSTRUCTION: VARIABLES.production
1:  ASSIGNMENT INSTRUCTION: izisviews.pr_patient_in_production.production
2:  RETURN

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

CANONICAL PLAN: 
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100})
  Project(groups=[izisprod.prod_P_GeneralData AS gd, izisviews.pr_patient_in_production AS ip], props={PROJECT_COLS=[gd.PatientID, ip.production]})
    Select(groups=[izisprod.prod_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.Status = 1})
      Join(groups=[izisprod.prod_P_GeneralData AS gd, izisviews.pr_patient_in_production AS ip], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ip.patientid = gd.PatientID]})
        Source(groups=[izisprod.prod_P_GeneralData AS gd])
        Source(groups=[izisviews.pr_patient_in_production AS ip], props={NESTED_COMMAND=SELECT X.*, izisviews.pr_patient_in_production.patientid AS patientid FROM (EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid)) AS X, SYMBOL_MAP={ip.production=X.production, ip.patientid=izisviews.pr_patient_in_production.patientid}})
          Project(groups=[X], props={PROJECT_COLS=[X.production, izisviews.pr_patient_in_production.patientid AS patientid]})
            Source(groups=[X], props={NESTED_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), SYMBOL_MAP={X.production=izisviews.pr_patient_in_production.production}})
              Project(groups=[izisviews.pr_patient_in_production], props={PROJECT_COLS=[izisviews.pr_patient_in_production.production]})
                Source(groups=[izisviews.pr_patient_in_production], props={VIRTUAL_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), NESTED_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), PROCESSOR_PLAN=ProcedurePlan:
PROGRAM counter 0
0:  ASSIGNMENT INSTRUCTION: VARIABLES.production
1:  ASSIGNMENT INSTRUCTION: izisviews.pr_patient_in_production.production
2:  RETURN
})


============================================================================
EXECUTING PlaceAccess

AFTER: 
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100})
  Project(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1], props={PROJECT_COLS=[gd__1.PatientID, ip.production]})
    Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.Status = 1})
      Join(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ip.patientid = gd__1.PatientID]})
        Access(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04})
          Source(groups=[izisprod.prod_P_GeneralData AS gd__1])
        Source(groups=[izisviews.pr_patient_in_production AS ip], props={NESTED_COMMAND=SELECT X.*, izisviews.pr_patient_in_production.patientid AS patientid FROM (EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid)) AS X, SYMBOL_MAP={ip.production=X.production, ip.patientid=izisviews.pr_patient_in_production.patientid}, ACCESS_PATTERNS=[Access Pattern: Unsatisfied [ip.patientid] History [[ip.patientid]]]})
          Project(groups=[X], props={PROJECT_COLS=[X.production, izisviews.pr_patient_in_production.patientid AS patientid]})
            Source(groups=[X], props={NESTED_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), SYMBOL_MAP={X.production=izisviews.pr_patient_in_production.production}})
              Project(groups=[izisviews.pr_patient_in_production], props={PROJECT_COLS=[izisviews.pr_patient_in_production.production]})
                Access(groups=[izisviews.pr_patient_in_production], props={SOURCE_HINT=null})
                  Source(groups=[izisviews.pr_patient_in_production], props={VIRTUAL_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), NESTED_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), PROCESSOR_PLAN=ProcedurePlan:
PROGRAM counter 0
0:  ASSIGNMENT INSTRUCTION: VARIABLES.production
1:  ASSIGNMENT INSTRUCTION: izisviews.pr_patient_in_production.production
2:  RETURN
})


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

AFTER: 
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=[gd__1.PatientID, ip.production]})
  Project(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1], props={PROJECT_COLS=[gd__1.PatientID, ip.production], OUTPUT_COLS=[gd__1.PatientID, ip.production]})
    Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.Status = 1, OUTPUT_COLS=[gd__1.PatientID, ip.production]})
      Join(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ip.patientid = gd__1.PatientID], OUTPUT_COLS=[gd__1.Status, gd__1.PatientID, ip.production]})
        Access(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[gd__1.PatientID, gd__1.Status]})
          Source(groups=[izisprod.prod_P_GeneralData AS gd__1], props={OUTPUT_COLS=[gd__1.PatientID, gd__1.Status]})
        Source(groups=[izisviews.pr_patient_in_production AS ip], props={NESTED_COMMAND=SELECT X.*, izisviews.pr_patient_in_production.patientid AS patientid FROM (EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid)) AS X, SYMBOL_MAP={ip.patientid=izisviews.pr_patient_in_production.patientid, ip.production=X.production}, ACCESS_PATTERNS=[Access Pattern: Unsatisfied [ip.patientid] History [[ip.patientid]]], OUTPUT_COLS=[ip.patientid, ip.production]})
          Project(groups=[X], props={PROJECT_COLS=[izisviews.pr_patient_in_production.patientid AS patientid, X.production], OUTPUT_COLS=[izisviews.pr_patient_in_production.patientid AS patientid, X.production]})
            Source(groups=[X], props={NESTED_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), SYMBOL_MAP={X.production=izisviews.pr_patient_in_production.production}, OUTPUT_COLS=[X.production]})
              Project(groups=[izisviews.pr_patient_in_production], props={PROJECT_COLS=[izisviews.pr_patient_in_production.production], OUTPUT_COLS=[izisviews.pr_patient_in_production.production]})
                Access(groups=[izisviews.pr_patient_in_production], props={SOURCE_HINT=null, OUTPUT_COLS=[izisviews.pr_patient_in_production.production]})
                  Source(groups=[izisviews.pr_patient_in_production], props={VIRTUAL_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), NESTED_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), PROCESSOR_PLAN=ProcedurePlan:
PROGRAM counter 0
0:  ASSIGNMENT INSTRUCTION: VARIABLES.production
1:  ASSIGNMENT INSTRUCTION: izisviews.pr_patient_in_production.production
2:  RETURN
, OUTPUT_COLS=[izisviews.pr_patient_in_production.production]})


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

AFTER: 
TupleLimit(groups=[])
  Project(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1], props={PROJECT_COLS=[gd__1.PatientID, ip.production], OUTPUT_COLS=[gd__1.PatientID, ip.production]})
    Join(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ip.patientid = gd__1.PatientID], OUTPUT_COLS=[gd__1.Status, gd__1.PatientID, ip.production]})
      Access(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[gd__1.PatientID, gd__1.Status]})
        Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.Status = 1, OUTPUT_COLS=[gd__1.PatientID, ip.production]})
          Source(groups=[izisprod.prod_P_GeneralData AS gd__1], props={OUTPUT_COLS=[gd__1.PatientID, gd__1.Status]})
      Source(groups=[izisviews.pr_patient_in_production AS ip])
        Project(groups=[X])
          Source(groups=[X])
            Project(groups=[izisviews.pr_patient_in_production])
              Access(groups=[izisviews.pr_patient_in_production])
                Source(groups=[izisviews.pr_patient_in_production])


============================================================================
EXECUTING MergeVirtual

AFTER: 
TupleLimit(groups=[])
  Project(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1])
    Join(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1])
      Access(groups=[izisprod.prod_P_GeneralData AS gd__1])
        Select(groups=[izisprod.prod_P_GeneralData AS gd__1])
          Source(groups=[izisprod.prod_P_GeneralData AS gd__1])
      Source(groups=[izisviews.pr_patient_in_production AS ip])
        Project(groups=[X])
          Source(groups=[X])
            Project(groups=[izisviews.pr_patient_in_production])
              Access(groups=[izisviews.pr_patient_in_production])
                Source(groups=[izisviews.pr_patient_in_production], props={VIRTUAL_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), NESTED_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), PROCESSOR_PLAN=ProcedurePlan:
PROGRAM counter 0
0:  ASSIGNMENT INSTRUCTION: VARIABLES.production
1:  ASSIGNMENT INSTRUCTION: izisviews.pr_patient_in_production.production
2:  RETURN
, OUTPUT_COLS=[izisviews.pr_patient_in_production.production]})


============================================================================
EXECUTING PushNonJoinCriteria

AFTER: 
TupleLimit(groups=[])
  Project(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1])
    Join(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ip.patientid = gd__1.PatientID], OUTPUT_COLS=[gd__1.Status, gd__1.PatientID, ip.production]})
      Access(groups=[izisprod.prod_P_GeneralData AS gd__1])
        Select(groups=[izisprod.prod_P_GeneralData AS gd__1])
          Source(groups=[izisprod.prod_P_GeneralData AS gd__1])
      Source(groups=[izisviews.pr_patient_in_production AS ip])
        Project(groups=[X])
          Source(groups=[X])
            Project(groups=[izisviews.pr_patient_in_production])
              Access(groups=[izisviews.pr_patient_in_production])
                Source(groups=[izisviews.pr_patient_in_production])


============================================================================
EXECUTING CleanCriteria

AFTER: 
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=null})
  Project(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1], props={PROJECT_COLS=[gd__1.PatientID, ip.production], OUTPUT_COLS=null})
    Join(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ip.patientid = gd__1.PatientID], OUTPUT_COLS=null})
      Access(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null})
        Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.Status = 1, OUTPUT_COLS=null})
          Source(groups=[izisprod.prod_P_GeneralData AS gd__1], props={OUTPUT_COLS=null})
      Source(groups=[izisviews.pr_patient_in_production AS ip], props={NESTED_COMMAND=SELECT X.*, izisviews.pr_patient_in_production.patientid AS patientid FROM (EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid)) AS X, SYMBOL_MAP={ip.patientid=izisviews.pr_patient_in_production.patientid, ip.production=X.production}, ACCESS_PATTERNS=[Access Pattern: Unsatisfied [ip.patientid] History [[ip.patientid]]], OUTPUT_COLS=null})
        Project(groups=[X], props={PROJECT_COLS=[izisviews.pr_patient_in_production.patientid AS patientid, X.production], OUTPUT_COLS=null})
          Source(groups=[X], props={NESTED_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), SYMBOL_MAP={X.production=izisviews.pr_patient_in_production.production}, OUTPUT_COLS=null})
            Project(groups=[izisviews.pr_patient_in_production], props={PROJECT_COLS=[izisviews.pr_patient_in_production.production], OUTPUT_COLS=null})
              Access(groups=[izisviews.pr_patient_in_production], props={SOURCE_HINT=null, OUTPUT_COLS=null})
                Source(groups=[izisviews.pr_patient_in_production], props={VIRTUAL_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), NESTED_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), PROCESSOR_PLAN=ProcedurePlan:
PROGRAM counter 0
0:  ASSIGNMENT INSTRUCTION: VARIABLES.production
1:  ASSIGNMENT INSTRUCTION: izisviews.pr_patient_in_production.production
2:  RETURN
, OUTPUT_COLS=null})


============================================================================
EXECUTING RaiseAccess

AFTER: 
TupleLimit(groups=[])
  Project(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1])
    Join(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ip.patientid = gd__1.PatientID], OUTPUT_COLS=null})
      Access(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null})
        Select(groups=[izisprod.prod_P_GeneralData AS gd__1])
          Source(groups=[izisprod.prod_P_GeneralData AS gd__1])
      Source(groups=[izisviews.pr_patient_in_production AS ip])
        Project(groups=[X])
          Source(groups=[X])
            Project(groups=[izisviews.pr_patient_in_production])
              Access(groups=[izisviews.pr_patient_in_production])
                Source(groups=[izisviews.pr_patient_in_production])


============================================================================
EXECUTING CopyCriteria

AFTER: 
TupleLimit(groups=[])
  Project(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1])
    Join(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ip.patientid = gd__1.PatientID], OUTPUT_COLS=null, IS_COPIED=true})
      Access(groups=[izisprod.prod_P_GeneralData AS gd__1])
        Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.Status = 1, OUTPUT_COLS=null, IS_COPIED=true})
          Source(groups=[izisprod.prod_P_GeneralData AS gd__1])
      Source(groups=[izisviews.pr_patient_in_production AS ip])
        Project(groups=[X])
          Source(groups=[X])
            Project(groups=[izisviews.pr_patient_in_production])
              Access(groups=[izisviews.pr_patient_in_production])
                Source(groups=[izisviews.pr_patient_in_production])


============================================================================
EXECUTING CleanCriteria

AFTER: 
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=null})
  Project(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1], props={PROJECT_COLS=[gd__1.PatientID, ip.production], OUTPUT_COLS=null})
    Join(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ip.patientid = gd__1.PatientID], OUTPUT_COLS=null, IS_COPIED=true})
      Access(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null})
        Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.Status = 1, OUTPUT_COLS=null, IS_COPIED=true})
          Source(groups=[izisprod.prod_P_GeneralData AS gd__1], props={OUTPUT_COLS=null})
      Source(groups=[izisviews.pr_patient_in_production AS ip], props={NESTED_COMMAND=SELECT X.*, izisviews.pr_patient_in_production.patientid AS patientid FROM (EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid)) AS X, SYMBOL_MAP={ip.patientid=izisviews.pr_patient_in_production.patientid, ip.production=X.production}, ACCESS_PATTERNS=[Access Pattern: Unsatisfied [ip.patientid] History [[ip.patientid]]], OUTPUT_COLS=null})
        Project(groups=[X], props={PROJECT_COLS=[izisviews.pr_patient_in_production.patientid AS patientid, X.production], OUTPUT_COLS=null})
          Source(groups=[X], props={NESTED_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), SYMBOL_MAP={X.production=izisviews.pr_patient_in_production.production}, OUTPUT_COLS=null})
            Project(groups=[izisviews.pr_patient_in_production], props={PROJECT_COLS=[izisviews.pr_patient_in_production.production], OUTPUT_COLS=null})
              Access(groups=[izisviews.pr_patient_in_production], props={SOURCE_HINT=null, OUTPUT_COLS=null})
                Source(groups=[izisviews.pr_patient_in_production], props={VIRTUAL_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), NESTED_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), PROCESSOR_PLAN=ProcedurePlan:
PROGRAM counter 0
0:  ASSIGNMENT INSTRUCTION: VARIABLES.production
1:  ASSIGNMENT INSTRUCTION: izisviews.pr_patient_in_production.production
2:  RETURN
, OUTPUT_COLS=null})


============================================================================
EXECUTING PlanJoins

AFTER: 
TupleLimit(groups=[])
  Project(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1], props={PROJECT_COLS=[gd__1.PatientID, ip.production], OUTPUT_COLS=null})
    Select(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=ip.patientid = gd__1.PatientID, EST_SELECTIVITY=0.07033334})
      Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisviews.pr_patient_in_production AS ip], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP})
        Access(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null, EST_CARDINALITY=20.0, EST_COL_STATS={gd__1.Address=[1.0, 10.0, -1.0], gd__1.AdmissionTime=[1.0, 10.0, -1.0], gd__1.AdmissionWard=[1.0, 10.0, -1.0], gd__1.BedID=[1.0, 10.0, -1.0], ...}})
          Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.Status = 1, OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=20.0, EST_COL_STATS={gd__1.Address=[1.0, 10.0, -1.0], gd__1.AdmissionTime=[1.0, 10.0, -1.0], gd__1.AdmissionWard=[1.0, 10.0, -1.0], gd__1.BedID=[1.0, 10.0, -1.0], ...}})
            Source(groups=[izisprod.prod_P_GeneralData AS gd__1], props={OUTPUT_COLS=null, EST_COL_STATS={gd__1.Address=[20.0, 200.0, -1.0], gd__1.AdmissionTime=[20.0, 200.0, -1.0], gd__1.AdmissionWard=[20.0, 200.0, -1.0], gd__1.BedID=[20.0, 200.0, -1.0], ...}, EST_CARDINALITY=400.0})
        Source(groups=[izisviews.pr_patient_in_production AS ip], props={NESTED_COMMAND=SELECT X.*, izisviews.pr_patient_in_production.patientid AS patientid FROM (EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid)) AS X, SYMBOL_MAP={ip.patientid=izisviews.pr_patient_in_production.patientid, ip.production=X.production}, ACCESS_PATTERNS=[Access Pattern: Unsatisfied [ip.patientid] History [[ip.patientid]]], OUTPUT_COLS=null, ACCESS_PATTERN_USED=Access Pattern: Unsatisfied [ip.patientid] History [[ip.patientid]], REQUIRED_ACCESS_PATTERN_GROUPS=[izisprod.prod_P_GeneralData AS gd__1], EST_CARDINALITY=-1.0, EST_COL_STATS={ip.production=[2.0, 2.0, -1.0], ip.patientid=[-1.0, -1.0, -1.0]}})
          Project(groups=[X], props={PROJECT_COLS=[izisviews.pr_patient_in_production.patientid AS patientid, X.production], OUTPUT_COLS=null, EST_CARDINALITY=-1.0})
            Source(groups=[X], props={NESTED_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), SYMBOL_MAP={X.production=izisviews.pr_patient_in_production.production}, OUTPUT_COLS=null, EST_CARDINALITY=-1.0, EST_COL_STATS={X.production=[2.0, 2.0, -1.0]}})
              Project(groups=[izisviews.pr_patient_in_production], props={PROJECT_COLS=[izisviews.pr_patient_in_production.production], OUTPUT_COLS=null, EST_CARDINALITY=-1.0})
                Access(groups=[izisviews.pr_patient_in_production], props={SOURCE_HINT=null, OUTPUT_COLS=null, EST_CARDINALITY=-1.0})
                  Source(groups=[izisviews.pr_patient_in_production], props={VIRTUAL_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), NESTED_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), PROCESSOR_PLAN=ProcedurePlan:
PROGRAM counter 0
0:  ASSIGNMENT INSTRUCTION: VARIABLES.production
1:  ASSIGNMENT INSTRUCTION: izisviews.pr_patient_in_production.production
2:  RETURN
, OUTPUT_COLS=null, EST_COL_STATS={izisviews.pr_patient_in_production.production=[2.0, 2.0, -1.0]}, EST_CARDINALITY=-1.0})


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

AFTER: 
TupleLimit(groups=[])
  Project(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1], props={PROJECT_COLS=[gd__1.PatientID, ip.production], OUTPUT_COLS=null})
    Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisviews.pr_patient_in_production AS ip], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ip.patientid = gd__1.PatientID]})
      Access(groups=[izisprod.prod_P_GeneralData AS gd__1])
        Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.Status = 1, OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=20.0, EST_COL_STATS={gd__1.Address=[1.0, 10.0, -1.0], gd__1.AdmissionTime=[1.0, 10.0, -1.0], gd__1.AdmissionWard=[1.0, 10.0, -1.0], gd__1.BedID=[1.0, 10.0, -1.0], ...}})
          Source(groups=[izisprod.prod_P_GeneralData AS gd__1])
      Source(groups=[izisviews.pr_patient_in_production AS ip])
        Project(groups=[X])
          Source(groups=[X])
            Project(groups=[izisviews.pr_patient_in_production])
              Access(groups=[izisviews.pr_patient_in_production])
                Source(groups=[izisviews.pr_patient_in_production])


============================================================================
EXECUTING RaiseAccess

AFTER: 
TupleLimit(groups=[])
  Project(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1])
    Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisviews.pr_patient_in_production AS ip], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ip.patientid = gd__1.PatientID]})
      Access(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null, EST_CARDINALITY=20.0, EST_COL_STATS={gd__1.Address=[1.0, 10.0, -1.0], gd__1.AdmissionTime=[1.0, 10.0, -1.0], gd__1.AdmissionWard=[1.0, 10.0, -1.0], gd__1.BedID=[1.0, 10.0, -1.0], ...}})
        Select(groups=[izisprod.prod_P_GeneralData AS gd__1])
          Source(groups=[izisprod.prod_P_GeneralData AS gd__1])
      Source(groups=[izisviews.pr_patient_in_production AS ip])
        Project(groups=[X])
          Source(groups=[X])
            Project(groups=[izisviews.pr_patient_in_production])
              Access(groups=[izisviews.pr_patient_in_production])
                Source(groups=[izisviews.pr_patient_in_production])


============================================================================
EXECUTING PlanOuterJoins

AFTER: 
TupleLimit(groups=[])
  Project(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1])
    Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisviews.pr_patient_in_production AS ip], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ip.patientid = gd__1.PatientID]})
      Access(groups=[izisprod.prod_P_GeneralData AS gd__1])
        Select(groups=[izisprod.prod_P_GeneralData AS gd__1])
          Source(groups=[izisprod.prod_P_GeneralData AS gd__1])
      Source(groups=[izisviews.pr_patient_in_production AS ip])
        Project(groups=[X])
          Source(groups=[X])
            Project(groups=[izisviews.pr_patient_in_production])
              Access(groups=[izisviews.pr_patient_in_production])
                Source(groups=[izisviews.pr_patient_in_production])


============================================================================
EXECUTING ChooseJoinStrategy

AFTER: 
TupleLimit(groups=[])
  Project(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1])
    Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisviews.pr_patient_in_production AS ip], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[ip.patientid = gd__1.PatientID], LEFT_EXPRESSIONS=[gd__1.PatientID], RIGHT_EXPRESSIONS=[ip.patientid], NON_EQUI_JOIN_CRITERIA=[]})
      Access(groups=[izisprod.prod_P_GeneralData AS gd__1])
        Select(groups=[izisprod.prod_P_GeneralData AS gd__1])
          Source(groups=[izisprod.prod_P_GeneralData AS gd__1])
      Source(groups=[izisviews.pr_patient_in_production AS ip])
        Project(groups=[X])
          Source(groups=[X])
            Project(groups=[izisviews.pr_patient_in_production])
              Access(groups=[izisviews.pr_patient_in_production])
                Source(groups=[izisviews.pr_patient_in_production])


============================================================================
EXECUTING ChooseDependent
LOW [Relational Planner] unsatisfied access pattern detected - marking as dependent side of join Source(groups=[izisviews.pr_patient_in_production AS ip], props={NESTED_COMMAND=SELECT X.*, izisviews.pr_patient_in_production.patientid AS patientid FROM (EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid)) AS X, SYMBOL_MAP={ip.patientid=izisviews.pr_patient_in_production.patientid, ip.production=X.production}, ACCESS_PATTERNS=[Access Pattern: Unsatisfied [ip.patientid] History [[ip.patientid]]], OUTPUT_COLS=null, ACCESS_PATTERN_USED=Access Pattern: Unsatisfied [ip.patientid] History [[ip.patientid]], REQUIRED_ACCESS_PATTERN_GROUPS=[izisprod.prod_P_GeneralData AS gd__1], EST_CARDINALITY=-1.0, EST_COL_STATS={ip.production=[2.0, 2.0, -1.0], ip.patientid=[-1.0, -1.0, -1.0]}}

AFTER: 
TupleLimit(groups=[])
  Project(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1])
    Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisviews.pr_patient_in_production AS ip], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[ip.patientid = gd__1.PatientID], LEFT_EXPRESSIONS=[gd__1.PatientID], RIGHT_EXPRESSIONS=[ip.patientid], NON_EQUI_JOIN_CRITERIA=[], DEPENDENT_VALUE_SOURCE=$dsc/id104})
      Access(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null, EST_CARDINALITY=20.0, EST_COL_STATS={gd__1.Address=[1.0, 10.0, -1.0], gd__1.AdmissionTime=[1.0, 10.0, -1.0], gd__1.AdmissionWard=[1.0, 10.0, -1.0], gd__1.BedID=[1.0, 10.0, -1.0], ...}})
        Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.Status = 1, OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=20.0, EST_COL_STATS={gd__1.Address=[1.0, 10.0, -1.0], gd__1.AdmissionTime=[1.0, 10.0, -1.0], gd__1.AdmissionWard=[1.0, 10.0, -1.0], gd__1.BedID=[1.0, 10.0, -1.0], ...}})
          Source(groups=[izisprod.prod_P_GeneralData AS gd__1], props={OUTPUT_COLS=null, EST_COL_STATS={gd__1.Address=[20.0, 200.0, -1.0], gd__1.AdmissionTime=[20.0, 200.0, -1.0], gd__1.AdmissionWard=[20.0, 200.0, -1.0], gd__1.BedID=[20.0, 200.0, -1.0], ...}, EST_CARDINALITY=400.0})
      Select(groups=[izisviews.pr_patient_in_production AS ip], props={SELECT_CRITERIA=ip.patientid IN (<dependent values>), IS_DEPENDENT_SET=true})
        Source(groups=[izisviews.pr_patient_in_production AS ip], props={NESTED_COMMAND=SELECT X.*, izisviews.pr_patient_in_production.patientid AS patientid FROM (EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid)) AS X, SYMBOL_MAP={ip.patientid=izisviews.pr_patient_in_production.patientid, ip.production=X.production}, ACCESS_PATTERNS=[Access Pattern: Unsatisfied [ip.patientid] History [[ip.patientid]]], OUTPUT_COLS=null, ACCESS_PATTERN_USED=Access Pattern: Unsatisfied [ip.patientid] History [[ip.patientid]], REQUIRED_ACCESS_PATTERN_GROUPS=[izisprod.prod_P_GeneralData AS gd__1], EST_CARDINALITY=-1.0, EST_COL_STATS={ip.production=[2.0, 2.0, -1.0], ip.patientid=[-1.0, -1.0, -1.0]}})
          Project(groups=[X])
            Source(groups=[X])
              Project(groups=[izisviews.pr_patient_in_production])
                Access(groups=[izisviews.pr_patient_in_production])
                  Source(groups=[izisviews.pr_patient_in_production])


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

AFTER: 
TupleLimit(groups=[])
  Project(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1])
    Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisviews.pr_patient_in_production AS ip])
      Access(groups=[izisprod.prod_P_GeneralData AS gd__1])
        Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.Status = 1, OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=20.0, EST_COL_STATS={gd__1.Address=[1.0, 10.0, -1.0], gd__1.AdmissionTime=[1.0, 10.0, -1.0], gd__1.AdmissionWard=[1.0, 10.0, -1.0], gd__1.BedID=[1.0, 10.0, -1.0], ...}})
          Source(groups=[izisprod.prod_P_GeneralData AS gd__1])
      Select(groups=[izisviews.pr_patient_in_production AS ip], props={SELECT_CRITERIA=ip.patientid IN (<dependent values>), IS_DEPENDENT_SET=true, IS_PHANTOM=true})
        Source(groups=[izisviews.pr_patient_in_production AS ip], props={NESTED_COMMAND=SELECT X.*, izisviews.pr_patient_in_production.patientid AS patientid FROM (EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid)) AS X, SYMBOL_MAP={ip.patientid=izisviews.pr_patient_in_production.patientid, ip.production=X.production}, OUTPUT_COLS=null, ACCESS_PATTERN_USED=Access Pattern: Unsatisfied [] History [[ip.patientid]], REQUIRED_ACCESS_PATTERN_GROUPS=[izisprod.prod_P_GeneralData AS gd__1], EST_CARDINALITY=-1.0, EST_COL_STATS={ip.production=[2.0, 2.0, -1.0], ip.patientid=[-1.0, -1.0, -1.0]}})
          Project(groups=[X], props={PROJECT_COLS=[izisviews.pr_patient_in_production.patientid AS patientid, X.production], OUTPUT_COLS=null, EST_CARDINALITY=-1.0})
            Select(groups=[], props={SELECT_CRITERIA=izisviews.pr_patient_in_production.patientid IN (<dependent values>), IS_DEPENDENT_SET=true})
              Source(groups=[X], props={NESTED_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), SYMBOL_MAP={X.production=izisviews.pr_patient_in_production.production}, OUTPUT_COLS=null, EST_CARDINALITY=-1.0, EST_COL_STATS={X.production=[2.0, 2.0, -1.0]}})
                Project(groups=[izisviews.pr_patient_in_production])
                  Access(groups=[izisviews.pr_patient_in_production])
                    Source(groups=[izisviews.pr_patient_in_production])


============================================================================
EXECUTING CleanCriteria

AFTER: 
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=null})
  Project(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1], props={PROJECT_COLS=[gd__1.PatientID, ip.production], OUTPUT_COLS=null})
    Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisviews.pr_patient_in_production AS ip], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[ip.patientid = gd__1.PatientID], LEFT_EXPRESSIONS=[gd__1.PatientID], RIGHT_EXPRESSIONS=[ip.patientid], NON_EQUI_JOIN_CRITERIA=[], DEPENDENT_VALUE_SOURCE=$dsc/id104, OUTPUT_COLS=null})
      Access(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null, EST_CARDINALITY=20.0, EST_COL_STATS={gd__1.Address=[1.0, 10.0, -1.0], gd__1.AdmissionTime=[1.0, 10.0, -1.0], gd__1.AdmissionWard=[1.0, 10.0, -1.0], gd__1.BedID=[1.0, 10.0, -1.0], ...}})
        Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.Status = 1, OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=20.0, EST_COL_STATS={gd__1.Address=[1.0, 10.0, -1.0], gd__1.AdmissionTime=[1.0, 10.0, -1.0], gd__1.AdmissionWard=[1.0, 10.0, -1.0], gd__1.BedID=[1.0, 10.0, -1.0], ...}})
          Source(groups=[izisprod.prod_P_GeneralData AS gd__1], props={OUTPUT_COLS=null, EST_COL_STATS={gd__1.Address=[20.0, 200.0, -1.0], gd__1.AdmissionTime=[20.0, 200.0, -1.0], gd__1.AdmissionWard=[20.0, 200.0, -1.0], gd__1.BedID=[20.0, 200.0, -1.0], ...}, EST_CARDINALITY=400.0})
      Source(groups=[izisviews.pr_patient_in_production AS ip], props={NESTED_COMMAND=SELECT X.*, izisviews.pr_patient_in_production.patientid AS patientid FROM (EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid)) AS X, SYMBOL_MAP={ip.patientid=izisviews.pr_patient_in_production.patientid, ip.production=X.production}, OUTPUT_COLS=null, ACCESS_PATTERN_USED=Access Pattern: Unsatisfied [] History [[ip.patientid]], REQUIRED_ACCESS_PATTERN_GROUPS=[izisprod.prod_P_GeneralData AS gd__1], EST_CARDINALITY=-1.0, EST_COL_STATS={ip.production=[2.0, 2.0, -1.0], ip.patientid=[-1.0, -1.0, -1.0]}})
        Project(groups=[X], props={PROJECT_COLS=[izisviews.pr_patient_in_production.patientid AS patientid, X.production], OUTPUT_COLS=null, EST_CARDINALITY=-1.0})
          Select(groups=[], props={SELECT_CRITERIA=izisviews.pr_patient_in_production.patientid IN (<dependent values>), IS_DEPENDENT_SET=true, OUTPUT_COLS=null})
            Source(groups=[X], props={NESTED_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), SYMBOL_MAP={X.production=izisviews.pr_patient_in_production.production}, OUTPUT_COLS=null, EST_CARDINALITY=-1.0, EST_COL_STATS={X.production=[2.0, 2.0, -1.0]}})
              Project(groups=[izisviews.pr_patient_in_production], props={PROJECT_COLS=[izisviews.pr_patient_in_production.production], OUTPUT_COLS=null, EST_CARDINALITY=-1.0})
                Access(groups=[izisviews.pr_patient_in_production], props={SOURCE_HINT=null, OUTPUT_COLS=null, EST_CARDINALITY=-1.0})
                  Source(groups=[izisviews.pr_patient_in_production], props={VIRTUAL_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), NESTED_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), PROCESSOR_PLAN=ProcedurePlan:
PROGRAM counter 0
0:  ASSIGNMENT INSTRUCTION: VARIABLES.production
1:  ASSIGNMENT INSTRUCTION: izisviews.pr_patient_in_production.production
2:  RETURN
, OUTPUT_COLS=null, EST_COL_STATS={izisviews.pr_patient_in_production.production=[2.0, 2.0, -1.0]}, EST_CARDINALITY=-1.0})


============================================================================
EXECUTING PlanProcedures

AFTER: 
TupleLimit(groups=[])
  Project(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1])
    Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisviews.pr_patient_in_production AS ip])
      Access(groups=[izisprod.prod_P_GeneralData AS gd__1])
        Select(groups=[izisprod.prod_P_GeneralData AS gd__1])
          Source(groups=[izisprod.prod_P_GeneralData AS gd__1])
      Source(groups=[izisviews.pr_patient_in_production AS ip])
        Project(groups=[X], props={PROJECT_COLS=[izisviews.pr_patient_in_production.patientid AS patientid, X.production], OUTPUT_COLS=null, EST_CARDINALITY=-1.0})
          Source(groups=[X], props={NESTED_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), SYMBOL_MAP={X.production=izisviews.pr_patient_in_production.production}, OUTPUT_COLS=null, EST_CARDINALITY=-1.0, EST_COL_STATS={X.production=[2.0, 2.0, -1.0]}})
            Project(groups=[izisviews.pr_patient_in_production])
              Access(groups=[izisviews.pr_patient_in_production], props={SOURCE_HINT=null, OUTPUT_COLS=null, EST_CARDINALITY=-1.0, PROCEDURE_CRITERIA=izisviews.pr_patient_in_production.patientid IN (<dependent values>), PROCEDURE_INPUTS=[izisviews.pr_patient_in_production.patientid], PROCEDURE_DEFAULTS=[null], IS_DEPENDENT_SET=true})
                Source(groups=[izisviews.pr_patient_in_production], props={VIRTUAL_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), NESTED_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), PROCESSOR_PLAN=ProcedurePlan:
PROGRAM counter 0
0:  ASSIGNMENT INSTRUCTION: VARIABLES.production
1:  ASSIGNMENT INSTRUCTION: izisviews.pr_patient_in_production.production
2:  RETURN
, OUTPUT_COLS=null, EST_COL_STATS={izisviews.pr_patient_in_production.production=[2.0, 2.0, -1.0]}, EST_CARDINALITY=-1.0})


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

AFTER: 
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=[gd__1.PatientID, ip.production]})
  Project(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1], props={PROJECT_COLS=[gd__1.PatientID, ip.production], OUTPUT_COLS=[gd__1.PatientID, ip.production]})
    Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisviews.pr_patient_in_production AS ip], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[ip.patientid = gd__1.PatientID], LEFT_EXPRESSIONS=[gd__1.PatientID], RIGHT_EXPRESSIONS=[ip.patientid], NON_EQUI_JOIN_CRITERIA=[], DEPENDENT_VALUE_SOURCE=$dsc/id104, OUTPUT_COLS=[gd__1.PatientID, ip.production]})
      Access(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[gd__1.PatientID], EST_CARDINALITY=20.0, EST_COL_STATS={gd__1.Address=[1.0, 10.0, -1.0], gd__1.AdmissionTime=[1.0, 10.0, -1.0], gd__1.AdmissionWard=[1.0, 10.0, -1.0], gd__1.BedID=[1.0, 10.0, -1.0], ...}})
        Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.Status = 1, OUTPUT_COLS=[gd__1.PatientID], IS_COPIED=true, EST_CARDINALITY=20.0, EST_COL_STATS={gd__1.Address=[1.0, 10.0, -1.0], gd__1.AdmissionTime=[1.0, 10.0, -1.0], gd__1.AdmissionWard=[1.0, 10.0, -1.0], gd__1.BedID=[1.0, 10.0, -1.0], ...}})
          Source(groups=[izisprod.prod_P_GeneralData AS gd__1], props={OUTPUT_COLS=[gd__1.Status, gd__1.PatientID], EST_COL_STATS={gd__1.Address=[20.0, 200.0, -1.0], gd__1.AdmissionTime=[20.0, 200.0, -1.0], gd__1.AdmissionWard=[20.0, 200.0, -1.0], gd__1.BedID=[20.0, 200.0, -1.0], ...}, EST_CARDINALITY=400.0})
      Source(groups=[izisviews.pr_patient_in_production AS ip], props={NESTED_COMMAND=SELECT X.*, izisviews.pr_patient_in_production.patientid AS patientid FROM (EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid)) AS X, SYMBOL_MAP={ip.patientid=izisviews.pr_patient_in_production.patientid, ip.production=X.production}, OUTPUT_COLS=[ip.patientid, ip.production], ACCESS_PATTERN_USED=Access Pattern: Unsatisfied [] History [[ip.patientid]], REQUIRED_ACCESS_PATTERN_GROUPS=[izisprod.prod_P_GeneralData AS gd__1], EST_CARDINALITY=-1.0, EST_COL_STATS={ip.production=[2.0, 2.0, -1.0], ip.patientid=[-1.0, -1.0, -1.0]}})
        Project(groups=[X], props={PROJECT_COLS=[izisviews.pr_patient_in_production.patientid AS patientid, X.production], OUTPUT_COLS=[izisviews.pr_patient_in_production.patientid AS patientid, X.production], EST_CARDINALITY=-1.0})
          Source(groups=[X], props={NESTED_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), SYMBOL_MAP={X.production=izisviews.pr_patient_in_production.production}, OUTPUT_COLS=[X.production], EST_CARDINALITY=-1.0, EST_COL_STATS={X.production=[2.0, 2.0, -1.0]}})
            Project(groups=[izisviews.pr_patient_in_production], props={PROJECT_COLS=[izisviews.pr_patient_in_production.production], OUTPUT_COLS=[izisviews.pr_patient_in_production.production], EST_CARDINALITY=-1.0})
              Access(groups=[izisviews.pr_patient_in_production], props={SOURCE_HINT=null, OUTPUT_COLS=[izisviews.pr_patient_in_production.production], EST_CARDINALITY=-1.0, PROCEDURE_CRITERIA=izisviews.pr_patient_in_production.patientid IN (<dependent values>), PROCEDURE_INPUTS=[izisviews.pr_patient_in_production.patientid], PROCEDURE_DEFAULTS=[null], IS_DEPENDENT_SET=true})
                Source(groups=[izisviews.pr_patient_in_production], props={VIRTUAL_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), NESTED_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), PROCESSOR_PLAN=ProcedurePlan:
PROGRAM counter 0
0:  ASSIGNMENT INSTRUCTION: VARIABLES.production
1:  ASSIGNMENT INSTRUCTION: izisviews.pr_patient_in_production.production
2:  RETURN
, OUTPUT_COLS=[izisviews.pr_patient_in_production.production], EST_COL_STATS={izisviews.pr_patient_in_production.production=[2.0, 2.0, -1.0]}, EST_CARDINALITY=-1.0})


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

AFTER: 
Project(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1], props={PROJECT_COLS=[gd__1.PatientID, ip.production], OUTPUT_COLS=[gd__1.PatientID, ip.production], SOURCE_HINT=null})
  TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=[gd__1.PatientID, ip.production]})
    Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisviews.pr_patient_in_production AS ip], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[ip.patientid = gd__1.PatientID], LEFT_EXPRESSIONS=[gd__1.PatientID], RIGHT_EXPRESSIONS=[ip.patientid], NON_EQUI_JOIN_CRITERIA=[], DEPENDENT_VALUE_SOURCE=$dsc/id104, OUTPUT_COLS=[gd__1.PatientID, ip.production]})
      Access(groups=[izisprod.prod_P_GeneralData AS gd__1])
        Select(groups=[izisprod.prod_P_GeneralData AS gd__1])
          Source(groups=[izisprod.prod_P_GeneralData AS gd__1])
      Source(groups=[izisviews.pr_patient_in_production AS ip])
        Project(groups=[X])
          Source(groups=[X])
            Project(groups=[izisviews.pr_patient_in_production])
              Access(groups=[izisviews.pr_patient_in_production])
                Source(groups=[izisviews.pr_patient_in_production])


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

AFTER: 
Project(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1], props={PROJECT_COLS=[gd__1.PatientID, ip.production], OUTPUT_COLS=[gd__1.PatientID, ip.production], SOURCE_HINT=null, EST_CARDINALITY=100.0, EST_COL_STATS={gd__1.PatientID=[100.0, 100.0, 1.0], ip.production=[100.0, 100.0, 1.0]}})
  TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=[gd__1.PatientID, ip.production], EST_CARDINALITY=100.0, EST_COL_STATS={gd__1.PatientID=[100.0, 100.0, 0.0], ip.production=[100.0, 100.0, 0.0]}})
    Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisviews.pr_patient_in_production AS ip], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[ip.patientid = gd__1.PatientID], LEFT_EXPRESSIONS=[gd__1.PatientID], RIGHT_EXPRESSIONS=[ip.patientid], NON_EQUI_JOIN_CRITERIA=[], DEPENDENT_VALUE_SOURCE=$dsc/id104, OUTPUT_COLS=[gd__1.PatientID, ip.production], EST_CARDINALITY=-1.0})
      Access(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[gd__1.PatientID], EST_CARDINALITY=20.0, EST_COL_STATS={gd__1.Address=[1.0, 10.0, -1.0], gd__1.AdmissionTime=[1.0, 10.0, -1.0], gd__1.AdmissionWard=[1.0, 10.0, -1.0], gd__1.BedID=[1.0, 10.0, -1.0], ...}})
        Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.Status = 1, OUTPUT_COLS=[gd__1.PatientID], IS_COPIED=true, EST_CARDINALITY=20.0, EST_COL_STATS={gd__1.Address=[1.0, 10.0, -1.0], gd__1.AdmissionTime=[1.0, 10.0, -1.0], gd__1.AdmissionWard=[1.0, 10.0, -1.0], gd__1.BedID=[1.0, 10.0, -1.0], ...}})
          Source(groups=[izisprod.prod_P_GeneralData AS gd__1], props={OUTPUT_COLS=[gd__1.Status, gd__1.PatientID], EST_COL_STATS={gd__1.Address=[20.0, 200.0, -1.0], gd__1.AdmissionTime=[20.0, 200.0, -1.0], gd__1.AdmissionWard=[20.0, 200.0, -1.0], gd__1.BedID=[20.0, 200.0, -1.0], ...}, EST_CARDINALITY=400.0})
      Source(groups=[izisviews.pr_patient_in_production AS ip], props={NESTED_COMMAND=SELECT X.*, izisviews.pr_patient_in_production.patientid AS patientid FROM (EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid)) AS X, SYMBOL_MAP={ip.patientid=izisviews.pr_patient_in_production.patientid, ip.production=X.production}, OUTPUT_COLS=[ip.patientid, ip.production], ACCESS_PATTERN_USED=Access Pattern: Unsatisfied [] History [[ip.patientid]], REQUIRED_ACCESS_PATTERN_GROUPS=[izisprod.prod_P_GeneralData AS gd__1], EST_CARDINALITY=-1.0, EST_COL_STATS={ip.production=[2.0, 2.0, -1.0], ip.patientid=[-1.0, -1.0, -1.0]}})
        Project(groups=[X], props={PROJECT_COLS=[izisviews.pr_patient_in_production.patientid AS patientid, X.production], OUTPUT_COLS=[izisviews.pr_patient_in_production.patientid AS patientid, X.production], EST_CARDINALITY=-1.0})
          Source(groups=[X], props={NESTED_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), SYMBOL_MAP={X.production=izisviews.pr_patient_in_production.production}, OUTPUT_COLS=[X.production], EST_CARDINALITY=-1.0, EST_COL_STATS={X.production=[2.0, 2.0, -1.0]}})
            Project(groups=[izisviews.pr_patient_in_production], props={PROJECT_COLS=[izisviews.pr_patient_in_production.production], OUTPUT_COLS=[izisviews.pr_patient_in_production.production], EST_CARDINALITY=-1.0})
              Access(groups=[izisviews.pr_patient_in_production], props={SOURCE_HINT=null, OUTPUT_COLS=[izisviews.pr_patient_in_production.production], EST_CARDINALITY=-1.0, PROCEDURE_CRITERIA=izisviews.pr_patient_in_production.patientid IN (<dependent values>), PROCEDURE_INPUTS=[izisviews.pr_patient_in_production.patientid], PROCEDURE_DEFAULTS=[null], IS_DEPENDENT_SET=true})
                Source(groups=[izisviews.pr_patient_in_production], props={VIRTUAL_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), NESTED_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), PROCESSOR_PLAN=ProcedurePlan:
PROGRAM counter 0
0:  ASSIGNMENT INSTRUCTION: VARIABLES.production
1:  ASSIGNMENT INSTRUCTION: izisviews.pr_patient_in_production.production
2:  RETURN
, OUTPUT_COLS=[izisviews.pr_patient_in_production.production], EST_COL_STATS={izisviews.pr_patient_in_production.production=[2.0, 2.0, -1.0]}, EST_CARDINALITY=-1.0})


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

AFTER: 
Project(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1])
  TupleLimit(groups=[])
    Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisviews.pr_patient_in_production AS ip], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[ip.patientid = gd__1.PatientID], LEFT_EXPRESSIONS=[gd__1.PatientID], RIGHT_EXPRESSIONS=[ip.patientid], NON_EQUI_JOIN_CRITERIA=[], DEPENDENT_VALUE_SOURCE=$dsc/id104, OUTPUT_COLS=[gd__1.PatientID, ip.production], EST_CARDINALITY=-1.0, SORT_RIGHT=SORT})
      Access(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[gd__1.PatientID], EST_CARDINALITY=20.0, EST_COL_STATS={gd__1.Address=[1.0, 10.0, -1.0], gd__1.AdmissionTime=[1.0, 10.0, -1.0], gd__1.AdmissionWard=[1.0, 10.0, -1.0], gd__1.BedID=[1.0, 10.0, -1.0], ...}})
        Sort(groups=[], props={SORT_ORDER=ORDER BY gd__1.PatientID, OUTPUT_COLS=[gd__1.PatientID]})
          Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.Status = 1, OUTPUT_COLS=[gd__1.PatientID], IS_COPIED=true, EST_CARDINALITY=20.0, EST_COL_STATS={gd__1.Address=[1.0, 10.0, -1.0], gd__1.AdmissionTime=[1.0, 10.0, -1.0], gd__1.AdmissionWard=[1.0, 10.0, -1.0], gd__1.BedID=[1.0, 10.0, -1.0], ...}})
            Source(groups=[izisprod.prod_P_GeneralData AS gd__1], props={OUTPUT_COLS=[gd__1.Status, gd__1.PatientID], EST_COL_STATS={gd__1.Address=[20.0, 200.0, -1.0], gd__1.AdmissionTime=[20.0, 200.0, -1.0], gd__1.AdmissionWard=[20.0, 200.0, -1.0], gd__1.BedID=[20.0, 200.0, -1.0], ...}, EST_CARDINALITY=400.0})
      Source(groups=[izisviews.pr_patient_in_production AS ip], props={NESTED_COMMAND=SELECT X.*, izisviews.pr_patient_in_production.patientid AS patientid FROM (EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid)) AS X, SYMBOL_MAP={ip.patientid=izisviews.pr_patient_in_production.patientid, ip.production=X.production}, OUTPUT_COLS=[ip.patientid, ip.production], ACCESS_PATTERN_USED=Access Pattern: Unsatisfied [] History [[ip.patientid]], REQUIRED_ACCESS_PATTERN_GROUPS=[izisprod.prod_P_GeneralData AS gd__1], EST_CARDINALITY=-1.0, EST_COL_STATS={ip.production=[2.0, 2.0, -1.0], ip.patientid=[-1.0, -1.0, -1.0]}})
        Project(groups=[X], props={PROJECT_COLS=[izisviews.pr_patient_in_production.patientid AS patientid, X.production], OUTPUT_COLS=[izisviews.pr_patient_in_production.patientid AS patientid, X.production], EST_CARDINALITY=-1.0})
          Source(groups=[X], props={NESTED_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), SYMBOL_MAP={X.production=izisviews.pr_patient_in_production.production}, OUTPUT_COLS=[X.production], EST_CARDINALITY=-1.0, EST_COL_STATS={X.production=[2.0, 2.0, -1.0]}})
            Project(groups=[izisviews.pr_patient_in_production], props={PROJECT_COLS=[izisviews.pr_patient_in_production.production], OUTPUT_COLS=[izisviews.pr_patient_in_production.production], EST_CARDINALITY=-1.0})
              Access(groups=[izisviews.pr_patient_in_production], props={SOURCE_HINT=null, OUTPUT_COLS=[izisviews.pr_patient_in_production.production], EST_CARDINALITY=-1.0, PROCEDURE_CRITERIA=izisviews.pr_patient_in_production.patientid IN (<dependent values>), PROCEDURE_INPUTS=[izisviews.pr_patient_in_production.patientid], PROCEDURE_DEFAULTS=[null], IS_DEPENDENT_SET=true})
                Source(groups=[izisviews.pr_patient_in_production], props={VIRTUAL_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), NESTED_COMMAND=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid), PROCESSOR_PLAN=ProcedurePlan:
PROGRAM counter 0
0:  ASSIGNMENT INSTRUCTION: VARIABLES.production
1:  ASSIGNMENT INSTRUCTION: izisviews.pr_patient_in_production.production
2:  RETURN
, OUTPUT_COLS=[izisviews.pr_patient_in_production.production], EST_COL_STATS={izisviews.pr_patient_in_production.production=[2.0, 2.0, -1.0]}, EST_CARDINALITY=-1.0})


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

AFTER: 
Project(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1])
  TupleLimit(groups=[])
    Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisviews.pr_patient_in_production AS ip])
      Access(groups=[izisprod.prod_P_GeneralData AS gd__1])
        Sort(groups=[])
          Select(groups=[izisprod.prod_P_GeneralData AS gd__1])
            Source(groups=[izisprod.prod_P_GeneralData AS gd__1])
      Source(groups=[izisviews.pr_patient_in_production AS ip])
        Project(groups=[X])
          Source(groups=[X])
            Project(groups=[izisviews.pr_patient_in_production])
              Access(groups=[izisviews.pr_patient_in_production])
                Source(groups=[izisviews.pr_patient_in_production])


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

AFTER: 
Project(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1])
  TupleLimit(groups=[])
    Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisviews.pr_patient_in_production AS ip], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[ip.patientid = gd__1.PatientID], LEFT_EXPRESSIONS=[gd__1.PatientID], RIGHT_EXPRESSIONS=[ip.patientid], NON_EQUI_JOIN_CRITERIA=[], DEPENDENT_VALUE_SOURCE=$dsc/id104, OUTPUT_COLS=[gd__1.PatientID, ip.production], EST_CARDINALITY=-1.0, SORT_RIGHT=SORT})
      Access(groups=[izisprod.prod_P_GeneralData AS gd__1])
        Sort(groups=[])
          Select(groups=[izisprod.prod_P_GeneralData AS gd__1])
            Source(groups=[izisprod.prod_P_GeneralData AS gd__1])
      Source(groups=[izisviews.pr_patient_in_production AS ip])
        Project(groups=[X])
          Source(groups=[X])
            Project(groups=[izisviews.pr_patient_in_production])
              Access(groups=[izisviews.pr_patient_in_production])
                Source(groups=[izisviews.pr_patient_in_production])


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

AFTER: 
Project(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1])
  TupleLimit(groups=[])
    Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisviews.pr_patient_in_production AS ip])
      Access(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[gd__1.PatientID], EST_CARDINALITY=20.0, EST_COL_STATS={gd__1.Address=[1.0, 10.0, -1.0], gd__1.AdmissionTime=[1.0, 10.0, -1.0], gd__1.AdmissionWard=[1.0, 10.0, -1.0], gd__1.BedID=[1.0, 10.0, -1.0], ...}, ATOMIC_REQUEST=SELECT gd__1.PatientID FROM izisprod.prod_P_GeneralData AS gd__1 WHERE gd__1.Status = 1 ORDER BY gd__1.PatientID})
      Source(groups=[izisviews.pr_patient_in_production AS ip])
        Project(groups=[X])
          Source(groups=[X])
            Project(groups=[izisviews.pr_patient_in_production])
              Access(groups=[izisviews.pr_patient_in_production], props={SOURCE_HINT=null, OUTPUT_COLS=[izisviews.pr_patient_in_production.production], EST_CARDINALITY=-1.0, PROCEDURE_CRITERIA=izisviews.pr_patient_in_production.patientid IN (<dependent values>), PROCEDURE_INPUTS=[izisviews.pr_patient_in_production.patientid], PROCEDURE_DEFAULTS=[null], IS_DEPENDENT_SET=true, PROCESSOR_PLAN=ProcedurePlan:
PROGRAM counter 0
0:  ASSIGNMENT INSTRUCTION: VARIABLES.production
1:  ASSIGNMENT INSTRUCTION: izisviews.pr_patient_in_production.production
2:  RETURN
, ATOMIC_REQUEST=EXEC izisviews.pr_patient_in_production(izisviews.pr_patient_in_production.patientid)})


============================================================================
EXECUTING AccessPatternValidation

AFTER: 
Project(groups=[izisviews.pr_patient_in_production AS ip, izisprod.prod_P_GeneralData AS gd__1])
  TupleLimit(groups=[])
    Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisviews.pr_patient_in_production AS ip])
      Access(groups=[izisprod.prod_P_GeneralData AS gd__1])
      Source(groups=[izisviews.pr_patient_in_production AS ip])
        Project(groups=[X])
          Source(groups=[X])
            Project(groups=[izisviews.pr_patient_in_production])
              Access(groups=[izisviews.pr_patient_in_production])


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

PROCESS PLAN = 
ProjectNode(2) output=[gd__1.PatientID, ip.production] [gd__1.PatientID, ip.production]
  LimitNode(3) output=[gd__1.PatientID, ip.production] limit 100
    JoinNode(4) [Dependent] [ENHANCED SORT JOIN (ALREADY_SORTED/SORT)] [INNER JOIN] criteria=[gd__1.PatientID=ip.patientid] output=[gd__1.PatientID, ip.production]
      AccessNode(5) output=[gd__1.PatientID] SELECT g_0.PatientID AS c_0 FROM izisprod.prod_P_GeneralData AS g_0 WHERE g_0.Status = 1 ORDER BY c_0
      ProjectNode(6) output=[ip.patientid, ip.production] [izisviews.pr_patient_in_production.patientid AS patientid, X.production]
        ProjectNode(7) output=[X.production] [izisviews.pr_patient_in_production.production]
          DependentProcedureExecutionNode(8) output=[izisviews.pr_patient_in_production.production] 

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

----------------------------------------------------------------------------
OPTIMIZATION COMPLETE:
PROCESSOR PLAN:
ProjectNode(2) output=[gd__1.PatientID, ip.production] [gd__1.PatientID, ip.production]
  LimitNode(3) output=[gd__1.PatientID, ip.production] limit 100
    JoinNode(4) [Dependent] [ENHANCED SORT JOIN (ALREADY_SORTED/SORT)] [INNER JOIN] criteria=[gd__1.PatientID=ip.patientid] output=[gd__1.PatientID, ip.production]
      AccessNode(5) output=[gd__1.PatientID] SELECT g_0.PatientID AS c_0 FROM izisprod.prod_P_GeneralData AS g_0 WHERE g_0.Status = 1 ORDER BY c_0
      ProjectNode(6) output=[ip.patientid, ip.production] [izisviews.pr_patient_in_production.patientid AS patientid, X.production]
        ProjectNode(7) output=[X.production] [izisviews.pr_patient_in_production.production]
          DependentProcedureExecutionNode(8) output=[izisviews.pr_patient_in_production.production] 

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