============================================================================ USER COMMAND: SELECT v.admissionid, v.patgroup, v.ward, v.admtime, v.distime, v.origin FROM (SELECT gd.PatientID AS admissionid, gd.PatGroup AS patgroup, wr.Abbreviation AS ward, gd.AdmissionTime AS admtime, dd.DischargeTime AS distime, 'wh' AS origin FROM (iziswh.wh_P_GeneralData AS gd INNER JOIN iziswh.wh_P_DischargeData AS dd ON gd.PatientID = dd.PatientID) INNER JOIN izisprod.prod_S_WardRef AS wr ON wr.WardID = gd.WardID WHERE gd.PatientID IN (SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID) GROUP BY gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime UNION ALL SELECT gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime, 'prod' FROM (izisprod.prod_P_GeneralData AS gd INNER JOIN izisprod.prod_P_DischargeData AS dd ON gd.PatientID = dd.PatientID) INNER JOIN izisprod.prod_S_WardRef AS wr ON wr.WardID = gd.WardID WHERE (gd.PatientID IN (SELECT pr.PatientID FROM izisprod.prod_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID)) AND (gd.Status >= 4) AND (gd.Status <> 5) GROUP BY gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime) AS v ORDER BY v.admtime LIMIT 100 ---------------------------------------------------------------------------- OPTIMIZE: SELECT v.admissionid, v.patgroup, v.ward, v.admtime, v.distime, v.origin FROM (SELECT gd.PatientID AS admissionid, gd.PatGroup AS patgroup, wr.Abbreviation AS ward, gd.AdmissionTime AS admtime, dd.DischargeTime AS distime, 'wh' AS origin FROM (iziswh.wh_P_GeneralData AS gd INNER JOIN iziswh.wh_P_DischargeData AS dd ON gd.PatientID = dd.PatientID) INNER JOIN izisprod.prod_S_WardRef AS wr ON wr.WardID = gd.WardID WHERE gd.PatientID IN (SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID) GROUP BY gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime UNION ALL SELECT gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime, 'prod' FROM (izisprod.prod_P_GeneralData AS gd INNER JOIN izisprod.prod_P_DischargeData AS dd ON gd.PatientID = dd.PatientID) INNER JOIN izisprod.prod_S_WardRef AS wr ON wr.WardID = gd.WardID WHERE (gd.PatientID IN (SELECT pr.PatientID FROM izisprod.prod_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID)) AND (gd.Status >= 4) AND (gd.Status <> 5) GROUP BY gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime) AS v ORDER BY v.admtime LIMIT 100 ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT v.admissionid, v.patgroup, v.ward, v.admtime, v.distime, v.origin FROM (SELECT gd.PatientID AS admissionid, gd.PatGroup AS patgroup, wr.Abbreviation AS ward, gd.AdmissionTime AS admtime, dd.DischargeTime AS distime, 'wh' AS origin FROM (iziswh.wh_P_GeneralData AS gd INNER JOIN iziswh.wh_P_DischargeData AS dd ON gd.PatientID = dd.PatientID) INNER JOIN izisprod.prod_S_WardRef AS wr ON wr.WardID = gd.WardID WHERE gd.PatientID IN (SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID) GROUP BY gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime UNION ALL SELECT gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime, 'prod' FROM (izisprod.prod_P_GeneralData AS gd INNER JOIN izisprod.prod_P_DischargeData AS dd ON gd.PatientID = dd.PatientID) INNER JOIN izisprod.prod_S_WardRef AS wr ON wr.WardID = gd.WardID WHERE (gd.PatientID IN (SELECT pr.PatientID FROM izisprod.prod_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID)) AND (gd.Status >= 4) AND (gd.Status <> 5) GROUP BY gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime) AS v ORDER BY v.admtime LIMIT 100 CANONICAL PLAN: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100}) Sort(groups=[v], props={SORT_ORDER=ORDER BY v.admtime}) Project(groups=[v], props={PROJECT_COLS=[v.admissionid, v.patgroup, v.ward, v.admtime, v.distime, v.origin]}) Source(groups=[v], props={NESTED_COMMAND=SELECT anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin FROM (iziswh.wh_P_GeneralData AS gd INNER JOIN iziswh.wh_P_DischargeData AS dd ON gd.PatientID = dd.PatientID) INNER JOIN izisprod.prod_S_WardRef AS wr ON wr.WardID = gd.WardID WHERE gd.PatientID IN (SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID) GROUP BY gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime UNION ALL SELECT anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS PatGroup, anon_grp1.gcol2 AS Abbreviation, anon_grp1.gcol3 AS AdmissionTime, anon_grp1.gcol4 AS DischargeTime, 'prod' FROM (izisprod.prod_P_GeneralData AS gd INNER JOIN izisprod.prod_P_DischargeData AS dd ON gd.PatientID = dd.PatientID) INNER JOIN izisprod.prod_S_WardRef AS wr ON wr.WardID = gd.WardID WHERE (gd.PatientID IN (SELECT pr.PatientID FROM izisprod.prod_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID)) AND (gd.Status >= 4) AND (gd.Status <> 5) GROUP BY gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime, SYMBOL_MAP={v.admissionid=anon_grp0.gcol0, v.patgroup=anon_grp0.gcol1, v.ward=anon_grp0.gcol2, v.admtime=anon_grp0.gcol3, v.distime=anon_grp0.gcol4, v.origin='wh'}, PARTITION_INFO={v.origin=[['wh'], ['prod']]}}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin]}) Group(groups=[iziswh.wh_P_DischargeData AS dd, iziswh.wh_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr, anon_grp0], props={GROUP_COLS=[gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime], SYMBOL_MAP={anon_grp0.gcol0=gd.PatientID, anon_grp0.gcol1=gd.PatGroup, anon_grp0.gcol2=wr.Abbreviation, anon_grp0.gcol3=gd.AdmissionTime, anon_grp0.gcol4=dd.DischargeTime}}) Select(groups=[iziswh.wh_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.PatientID IN (SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID)}) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd, izisprod.prod_S_WardRef AS wr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[wr.WardID = gd.WardID]}) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd.PatientID = dd.PatientID]}) Source(groups=[iziswh.wh_P_GeneralData AS gd]) Source(groups=[iziswh.wh_P_DischargeData AS dd]) Source(groups=[izisprod.prod_S_WardRef AS wr]) Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS PatGroup, anon_grp1.gcol2 AS Abbreviation, anon_grp1.gcol3 AS AdmissionTime, anon_grp1.gcol4 AS DischargeTime, 'prod']}) Group(groups=[izisprod.prod_P_DischargeData AS dd, izisprod.prod_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr, anon_grp1], props={GROUP_COLS=[gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime], SYMBOL_MAP={anon_grp1.gcol0=gd.PatientID, anon_grp1.gcol1=gd.PatGroup, anon_grp1.gcol2=wr.Abbreviation, anon_grp1.gcol3=gd.AdmissionTime, anon_grp1.gcol4=dd.DischargeTime}}) Select(groups=[izisprod.prod_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.Status <> 5}) Select(groups=[izisprod.prod_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.Status >= 4}) Select(groups=[izisprod.prod_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.PatientID IN (SELECT pr.PatientID FROM izisprod.prod_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID)}) Join(groups=[izisprod.prod_P_GeneralData AS gd, izisprod.prod_P_DischargeData AS dd, izisprod.prod_S_WardRef AS wr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[wr.WardID = gd.WardID]}) Join(groups=[izisprod.prod_P_GeneralData AS gd, izisprod.prod_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd.PatientID = dd.PatientID]}) Source(groups=[izisprod.prod_P_GeneralData AS gd]) Source(groups=[izisprod.prod_P_DischargeData AS dd]) Source(groups=[izisprod.prod_S_WardRef AS wr]) ---------------------------------------------------------------------------- OPTIMIZE: SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID CANONICAL PLAN: Project(groups=[anon_grp2], props={PROJECT_COLS=[anon_grp2.gcol0 AS PatientID]}) Group(groups=[iziswh.wh_P_PharmaRec AS pr, anon_grp2], props={GROUP_COLS=[pr.PatientID], SYMBOL_MAP={anon_grp2.gcol0=pr.PatientID}}) Select(groups=[iziswh.wh_P_PharmaRec AS pr], props={SELECT_CRITERIA=bitand(convert(pr.Status, integer), 2) <> 2}) Select(groups=[iziswh.wh_P_PharmaRec AS pr], props={SELECT_CRITERIA=pr.PharmaID = 1002463}) Source(groups=[iziswh.wh_P_PharmaRec AS pr]) ============================================================================ EXECUTING PlaceAccess AFTER: Project(groups=[anon_grp2], props={PROJECT_COLS=[anon_grp2.gcol0 AS PatientID]}) Group(groups=[iziswh.wh_P_PharmaRec AS pr, anon_grp2], props={GROUP_COLS=[pr.PatientID], SYMBOL_MAP={anon_grp2.gcol0=pr.PatientID}}) Select(groups=[iziswh.wh_P_PharmaRec AS pr], props={SELECT_CRITERIA=bitand(convert(pr.Status, integer), 2) <> 2}) Select(groups=[iziswh.wh_P_PharmaRec AS pr], props={SELECT_CRITERIA=pr.PharmaID = 1002463}) Access(groups=[iziswh.wh_P_PharmaRec AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac}) Source(groups=[iziswh.wh_P_PharmaRec AS pr]) ============================================================================ EXECUTING PushSelectCriteria AFTER: Project(groups=[anon_grp2]) Group(groups=[iziswh.wh_P_PharmaRec AS pr, anon_grp2], props={GROUP_COLS=[pr.PatientID], SYMBOL_MAP={anon_grp2.gcol0=pr.PatientID}}) Select(groups=[iziswh.wh_P_PharmaRec AS pr], props={SELECT_CRITERIA=bitand(convert(pr.Status, integer), 2) <> 2}) Access(groups=[iziswh.wh_P_PharmaRec AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac}) Select(groups=[iziswh.wh_P_PharmaRec AS pr], props={SELECT_CRITERIA=pr.PharmaID = 1002463}) Source(groups=[iziswh.wh_P_PharmaRec AS pr]) ============================================================================ EXECUTING CleanCriteria AFTER: Project(groups=[anon_grp2], props={PROJECT_COLS=[anon_grp2.gcol0 AS PatientID], OUTPUT_COLS=null}) Group(groups=[iziswh.wh_P_PharmaRec AS pr, anon_grp2], props={GROUP_COLS=[pr.PatientID], SYMBOL_MAP={anon_grp2.gcol0=pr.PatientID}, OUTPUT_COLS=null}) Select(groups=[iziswh.wh_P_PharmaRec AS pr], props={SELECT_CRITERIA=bitand(convert(pr.Status, integer), 2) <> 2, OUTPUT_COLS=null}) Access(groups=[iziswh.wh_P_PharmaRec AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null}) Select(groups=[iziswh.wh_P_PharmaRec AS pr], props={SELECT_CRITERIA=pr.PharmaID = 1002463, OUTPUT_COLS=null}) Source(groups=[iziswh.wh_P_PharmaRec AS pr], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING RaiseAccess LOW Relational Planner bitand function not supported by source iziswh - bitand(convert(pr.Status, integer), 2) was not pushed AFTER: Project(groups=[anon_grp2]) Group(groups=[iziswh.wh_P_PharmaRec AS pr, anon_grp2]) Select(groups=[iziswh.wh_P_PharmaRec AS pr], props={SELECT_CRITERIA=bitand(convert(pr.Status, integer), 2) <> 2, OUTPUT_COLS=null}) Access(groups=[iziswh.wh_P_PharmaRec AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null}) Select(groups=[iziswh.wh_P_PharmaRec AS pr]) Source(groups=[iziswh.wh_P_PharmaRec AS pr]) ============================================================================ EXECUTING PushAggregates AFTER: Project(groups=[anon_grp2], props={PROJECT_COLS=[anon_grp2.gcol0 AS PatientID], OUTPUT_COLS=null}) Group(groups=[iziswh.wh_P_PharmaRec AS pr, anon_grp2], props={GROUP_COLS=[pr.PatientID], SYMBOL_MAP={anon_grp2.gcol0=pr.PatientID}, OUTPUT_COLS=null}) Select(groups=[iziswh.wh_P_PharmaRec AS pr]) Access(groups=[iziswh.wh_P_PharmaRec AS pr]) Select(groups=[iziswh.wh_P_PharmaRec AS pr]) Source(groups=[iziswh.wh_P_PharmaRec AS pr]) ============================================================================ EXECUTING AssignOutputElements AFTER: Project(groups=[anon_grp2], props={PROJECT_COLS=[anon_grp2.gcol0 AS PatientID], OUTPUT_COLS=[anon_grp2.gcol0 AS PatientID]}) Group(groups=[iziswh.wh_P_PharmaRec AS pr, anon_grp2], props={GROUP_COLS=[pr.PatientID], SYMBOL_MAP={anon_grp2.gcol0=pr.PatientID}, OUTPUT_COLS=[anon_grp2.gcol0]}) Select(groups=[iziswh.wh_P_PharmaRec AS pr], props={SELECT_CRITERIA=bitand(convert(pr.Status, integer), 2) <> 2, OUTPUT_COLS=[pr.PatientID]}) Access(groups=[iziswh.wh_P_PharmaRec AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[pr.Status, pr.PatientID]}) Select(groups=[iziswh.wh_P_PharmaRec AS pr], props={SELECT_CRITERIA=pr.PharmaID = 1002463, OUTPUT_COLS=[pr.Status, pr.PatientID]}) Source(groups=[iziswh.wh_P_PharmaRec AS pr], props={OUTPUT_COLS=[pr.PharmaID, pr.Status, pr.PatientID]}) ============================================================================ EXECUTING CalculateCost AFTER: Project(groups=[anon_grp2], props={PROJECT_COLS=[anon_grp2.gcol0 AS PatientID], OUTPUT_COLS=[anon_grp2.gcol0 AS PatientID], EST_CARDINALITY=7292.85, EST_COL_STATS={anon_grp2.gcol0 AS PatientID=[2430.95, -1.0]}}) Group(groups=[iziswh.wh_P_PharmaRec AS pr, anon_grp2], props={GROUP_COLS=[pr.PatientID], SYMBOL_MAP={anon_grp2.gcol0=pr.PatientID}, OUTPUT_COLS=[anon_grp2.gcol0], EST_CARDINALITY=7292.85, EST_COL_STATS={anon_grp2.gcol0=[2430.95, -1.0]}}) Select(groups=[iziswh.wh_P_PharmaRec AS pr], props={SELECT_CRITERIA=bitand(convert(pr.Status, integer), 2) <> 2, OUTPUT_COLS=[pr.PatientID], EST_CARDINALITY=14585.7, EST_COL_STATS={pr.PatientID=[-1.0, -1.0]}}) Access(groups=[iziswh.wh_P_PharmaRec AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[pr.Status, pr.PatientID], EST_CARDINALITY=14828.795, EST_COL_STATS={pr.Status=[-1.0, -1.0], pr.PatientID=[-1.0, -1.0]}}) Select(groups=[iziswh.wh_P_PharmaRec AS pr], props={SELECT_CRITERIA=pr.PharmaID = 1002463, OUTPUT_COLS=[pr.Status, pr.PatientID], EST_CARDINALITY=14828.795, EST_COL_STATS={pr.Status=[-1.0, -1.0], pr.PatientID=[-1.0, -1.0]}}) Source(groups=[iziswh.wh_P_PharmaRec AS pr], props={OUTPUT_COLS=[pr.PharmaID, pr.Status, pr.PatientID], EST_COL_STATS={pr.PharmaID=[-1.0, -1.0], pr.Status=[-1.0, -1.0], pr.PatientID=[-1.0, -1.0]}, EST_CARDINALITY=5.5E7}) ============================================================================ EXECUTING MergeCriteria AFTER: Project(groups=[anon_grp2]) Group(groups=[iziswh.wh_P_PharmaRec AS pr, anon_grp2]) Select(groups=[iziswh.wh_P_PharmaRec AS pr], props={SELECT_CRITERIA=bitand(convert(pr.Status, integer), 2) <> 2, OUTPUT_COLS=[pr.PatientID], EST_CARDINALITY=14585.7, EST_COL_STATS={pr.PatientID=[-1.0, -1.0]}}) Access(groups=[iziswh.wh_P_PharmaRec AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[pr.Status, pr.PatientID], EST_CARDINALITY=14828.795, EST_COL_STATS={pr.Status=[-1.0, -1.0], pr.PatientID=[-1.0, -1.0]}}) Select(groups=[iziswh.wh_P_PharmaRec AS pr], props={SELECT_CRITERIA=pr.PharmaID = 1002463, OUTPUT_COLS=[pr.Status, pr.PatientID], EST_CARDINALITY=14828.795, EST_COL_STATS={pr.Status=[-1.0, -1.0], pr.PatientID=[-1.0, -1.0]}}) Source(groups=[iziswh.wh_P_PharmaRec AS pr], props={OUTPUT_COLS=[pr.PharmaID, pr.Status, pr.PatientID], EST_COL_STATS={pr.PharmaID=[-1.0, -1.0], pr.Status=[-1.0, -1.0], pr.PatientID=[-1.0, -1.0]}, EST_CARDINALITY=5.5E7}) ============================================================================ EXECUTING PlanSorts AFTER: Project(groups=[anon_grp2]) Group(groups=[iziswh.wh_P_PharmaRec AS pr, anon_grp2], props={GROUP_COLS=[pr.PatientID], SYMBOL_MAP={anon_grp2.gcol0=pr.PatientID}, OUTPUT_COLS=[anon_grp2.gcol0], EST_CARDINALITY=7292.85, EST_COL_STATS={anon_grp2.gcol0=[2430.95, -1.0]}}) Select(groups=[iziswh.wh_P_PharmaRec AS pr]) Access(groups=[iziswh.wh_P_PharmaRec AS pr]) Select(groups=[iziswh.wh_P_PharmaRec AS pr]) Source(groups=[iziswh.wh_P_PharmaRec AS pr]) ============================================================================ EXECUTING CollapseSource AFTER: Project(groups=[anon_grp2], props={PROJECT_COLS=[anon_grp2.gcol0 AS PatientID], OUTPUT_COLS=[anon_grp2.gcol0 AS PatientID], EST_CARDINALITY=7292.85, EST_COL_STATS={anon_grp2.gcol0 AS PatientID=[2430.95, -1.0]}}) Group(groups=[iziswh.wh_P_PharmaRec AS pr, anon_grp2], props={GROUP_COLS=[pr.PatientID], SYMBOL_MAP={anon_grp2.gcol0=pr.PatientID}, OUTPUT_COLS=[anon_grp2.gcol0], EST_CARDINALITY=7292.85, EST_COL_STATS={anon_grp2.gcol0=[2430.95, -1.0]}}) Select(groups=[iziswh.wh_P_PharmaRec AS pr]) Access(groups=[iziswh.wh_P_PharmaRec AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[pr.Status, pr.PatientID], EST_CARDINALITY=14828.795, EST_COL_STATS={pr.Status=[-1.0, -1.0], pr.PatientID=[-1.0, -1.0]}, ATOMIC_REQUEST=SELECT pr.Status, pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE pr.PharmaID = 1002463}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = ProjectNode(3) output=[anon_grp2.gcol0 AS PatientID] [anon_grp2.gcol0 AS PatientID] GroupingNode(4) output=[anon_grp2.gcol0] [pr.PatientID]{anon_grp2.gcol0=pr.PatientID} SelectNode(5) output=[pr.PatientID] bitand(convert(pr.Status, integer), 2) <> 2 AccessNode(6) output=[pr.Status, pr.PatientID] SELECT g_0.Status, g_0.PatientID FROM iziswh.wh_P_PharmaRec AS g_0 WHERE g_0.PharmaID = 1002463 ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: ProjectNode(3) output=[anon_grp2.gcol0 AS PatientID] [anon_grp2.gcol0 AS PatientID] GroupingNode(4) output=[anon_grp2.gcol0] [pr.PatientID]{anon_grp2.gcol0=pr.PatientID} SelectNode(5) output=[pr.PatientID] bitand(convert(pr.Status, integer), 2) <> 2 AccessNode(6) output=[pr.Status, pr.PatientID] SELECT g_0.Status, g_0.PatientID FROM iziswh.wh_P_PharmaRec AS g_0 WHERE g_0.PharmaID = 1002463 ============================================================================ ---------------------------------------------------------------------------- OPTIMIZE: SELECT pr.PatientID FROM izisprod.prod_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT pr.PatientID FROM izisprod.prod_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID CANONICAL PLAN: Project(groups=[anon_grp7], props={PROJECT_COLS=[anon_grp7.gcol0 AS PatientID]}) Group(groups=[izisprod.prod_P_PharmaRec AS pr, anon_grp7], props={GROUP_COLS=[pr.PatientID], SYMBOL_MAP={anon_grp7.gcol0=pr.PatientID}}) Select(groups=[izisprod.prod_P_PharmaRec AS pr], props={SELECT_CRITERIA=bitand(convert(pr.Status, integer), 2) <> 2}) Select(groups=[izisprod.prod_P_PharmaRec AS pr], props={SELECT_CRITERIA=pr.PharmaID = 1002463}) Source(groups=[izisprod.prod_P_PharmaRec AS pr]) ============================================================================ EXECUTING PlaceAccess AFTER: Project(groups=[anon_grp7], props={PROJECT_COLS=[anon_grp7.gcol0 AS PatientID]}) Group(groups=[anon_grp7, izisprod.prod_P_PharmaRec AS pr__1], props={GROUP_COLS=[pr__1.PatientID], SYMBOL_MAP={anon_grp7.gcol0=pr__1.PatientID}}) Select(groups=[izisprod.prod_P_PharmaRec AS pr__1], props={SELECT_CRITERIA=bitand(convert(pr__1.Status, integer), 2) <> 2}) Select(groups=[izisprod.prod_P_PharmaRec AS pr__1], props={SELECT_CRITERIA=pr__1.PharmaID = 1002463}) Access(groups=[izisprod.prod_P_PharmaRec AS pr__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04}) Source(groups=[izisprod.prod_P_PharmaRec AS pr__1]) ============================================================================ EXECUTING PushSelectCriteria AFTER: Project(groups=[anon_grp7]) Group(groups=[anon_grp7, izisprod.prod_P_PharmaRec AS pr__1], props={GROUP_COLS=[pr__1.PatientID], SYMBOL_MAP={anon_grp7.gcol0=pr__1.PatientID}}) Select(groups=[izisprod.prod_P_PharmaRec AS pr__1], props={SELECT_CRITERIA=bitand(convert(pr__1.Status, integer), 2) <> 2}) Access(groups=[izisprod.prod_P_PharmaRec AS pr__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04}) Select(groups=[izisprod.prod_P_PharmaRec AS pr__1], props={SELECT_CRITERIA=pr__1.PharmaID = 1002463}) Source(groups=[izisprod.prod_P_PharmaRec AS pr__1]) ============================================================================ EXECUTING CleanCriteria AFTER: Project(groups=[anon_grp7], props={PROJECT_COLS=[anon_grp7.gcol0 AS PatientID], OUTPUT_COLS=null}) Group(groups=[anon_grp7, izisprod.prod_P_PharmaRec AS pr__1], props={GROUP_COLS=[pr__1.PatientID], SYMBOL_MAP={anon_grp7.gcol0=pr__1.PatientID}, OUTPUT_COLS=null}) Select(groups=[izisprod.prod_P_PharmaRec AS pr__1], props={SELECT_CRITERIA=bitand(convert(pr__1.Status, integer), 2) <> 2, OUTPUT_COLS=null}) Access(groups=[izisprod.prod_P_PharmaRec AS pr__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_PharmaRec AS pr__1], props={SELECT_CRITERIA=pr__1.PharmaID = 1002463, OUTPUT_COLS=null}) Source(groups=[izisprod.prod_P_PharmaRec AS pr__1], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING RaiseAccess LOW Relational Planner bitand function not supported by source izisprod - bitand(convert(pr__1.Status, integer), 2) was not pushed AFTER: Project(groups=[anon_grp7]) Group(groups=[anon_grp7, izisprod.prod_P_PharmaRec AS pr__1]) Select(groups=[izisprod.prod_P_PharmaRec AS pr__1], props={SELECT_CRITERIA=bitand(convert(pr__1.Status, integer), 2) <> 2, OUTPUT_COLS=null}) Access(groups=[izisprod.prod_P_PharmaRec AS pr__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_PharmaRec AS pr__1]) Source(groups=[izisprod.prod_P_PharmaRec AS pr__1]) ============================================================================ EXECUTING PushAggregates AFTER: Project(groups=[anon_grp7], props={PROJECT_COLS=[anon_grp7.gcol0 AS PatientID], OUTPUT_COLS=null}) Group(groups=[anon_grp7, izisprod.prod_P_PharmaRec AS pr__1], props={GROUP_COLS=[pr__1.PatientID], SYMBOL_MAP={anon_grp7.gcol0=pr__1.PatientID}, OUTPUT_COLS=null}) Select(groups=[izisprod.prod_P_PharmaRec AS pr__1]) Access(groups=[izisprod.prod_P_PharmaRec AS pr__1]) Select(groups=[izisprod.prod_P_PharmaRec AS pr__1]) Source(groups=[izisprod.prod_P_PharmaRec AS pr__1]) ============================================================================ EXECUTING AssignOutputElements AFTER: Project(groups=[anon_grp7], props={PROJECT_COLS=[anon_grp7.gcol0 AS PatientID], OUTPUT_COLS=[anon_grp7.gcol0 AS PatientID]}) Group(groups=[anon_grp7, izisprod.prod_P_PharmaRec AS pr__1], props={GROUP_COLS=[pr__1.PatientID], SYMBOL_MAP={anon_grp7.gcol0=pr__1.PatientID}, OUTPUT_COLS=[anon_grp7.gcol0]}) Select(groups=[izisprod.prod_P_PharmaRec AS pr__1], props={SELECT_CRITERIA=bitand(convert(pr__1.Status, integer), 2) <> 2, OUTPUT_COLS=[pr__1.PatientID]}) Access(groups=[izisprod.prod_P_PharmaRec AS pr__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[pr__1.Status, pr__1.PatientID]}) Select(groups=[izisprod.prod_P_PharmaRec AS pr__1], props={SELECT_CRITERIA=pr__1.PharmaID = 1002463, OUTPUT_COLS=[pr__1.Status, pr__1.PatientID]}) Source(groups=[izisprod.prod_P_PharmaRec AS pr__1], props={OUTPUT_COLS=[pr__1.PharmaID, pr__1.Status, pr__1.PatientID]}) ============================================================================ EXECUTING CalculateCost AFTER: Project(groups=[anon_grp7], props={PROJECT_COLS=[anon_grp7.gcol0 AS PatientID], OUTPUT_COLS=[anon_grp7.gcol0 AS PatientID], EST_CARDINALITY=734.5361, EST_COL_STATS={anon_grp7.gcol0 AS PatientID=[244.84535, -1.0]}}) Group(groups=[anon_grp7, izisprod.prod_P_PharmaRec AS pr__1], props={GROUP_COLS=[pr__1.PatientID], SYMBOL_MAP={anon_grp7.gcol0=pr__1.PatientID}, OUTPUT_COLS=[anon_grp7.gcol0], EST_CARDINALITY=734.5361, EST_COL_STATS={anon_grp7.gcol0=[244.84535, -1.0]}}) Select(groups=[izisprod.prod_P_PharmaRec AS pr__1], props={SELECT_CRITERIA=bitand(convert(pr__1.Status, integer), 2) <> 2, OUTPUT_COLS=[pr__1.PatientID], EST_CARDINALITY=1469.0721, EST_COL_STATS={pr__1.PatientID=[-1.0, -1.0]}}) Access(groups=[izisprod.prod_P_PharmaRec AS pr__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[pr__1.Status, pr__1.PatientID], EST_CARDINALITY=1546.3917, EST_COL_STATS={pr__1.Status=[-1.0, -1.0], pr__1.PatientID=[-1.0, -1.0]}}) Select(groups=[izisprod.prod_P_PharmaRec AS pr__1], props={SELECT_CRITERIA=pr__1.PharmaID = 1002463, OUTPUT_COLS=[pr__1.Status, pr__1.PatientID], EST_CARDINALITY=1546.3917, EST_COL_STATS={pr__1.Status=[-1.0, -1.0], pr__1.PatientID=[-1.0, -1.0]}}) Source(groups=[izisprod.prod_P_PharmaRec AS pr__1], props={OUTPUT_COLS=[pr__1.PharmaID, pr__1.Status, pr__1.PatientID], EST_COL_STATS={pr__1.PharmaID=[-1.0, -1.0], pr__1.Status=[-1.0, -1.0], pr__1.PatientID=[-1.0, -1.0]}, EST_CARDINALITY=600000.0}) ============================================================================ EXECUTING MergeCriteria AFTER: Project(groups=[anon_grp7]) Group(groups=[anon_grp7, izisprod.prod_P_PharmaRec AS pr__1]) Select(groups=[izisprod.prod_P_PharmaRec AS pr__1], props={SELECT_CRITERIA=bitand(convert(pr__1.Status, integer), 2) <> 2, OUTPUT_COLS=[pr__1.PatientID], EST_CARDINALITY=1469.0721, EST_COL_STATS={pr__1.PatientID=[-1.0, -1.0]}}) Access(groups=[izisprod.prod_P_PharmaRec AS pr__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[pr__1.Status, pr__1.PatientID], EST_CARDINALITY=1546.3917, EST_COL_STATS={pr__1.Status=[-1.0, -1.0], pr__1.PatientID=[-1.0, -1.0]}}) Select(groups=[izisprod.prod_P_PharmaRec AS pr__1], props={SELECT_CRITERIA=pr__1.PharmaID = 1002463, OUTPUT_COLS=[pr__1.Status, pr__1.PatientID], EST_CARDINALITY=1546.3917, EST_COL_STATS={pr__1.Status=[-1.0, -1.0], pr__1.PatientID=[-1.0, -1.0]}}) Source(groups=[izisprod.prod_P_PharmaRec AS pr__1], props={OUTPUT_COLS=[pr__1.PharmaID, pr__1.Status, pr__1.PatientID], EST_COL_STATS={pr__1.PharmaID=[-1.0, -1.0], pr__1.Status=[-1.0, -1.0], pr__1.PatientID=[-1.0, -1.0]}, EST_CARDINALITY=600000.0}) ============================================================================ EXECUTING PlanSorts AFTER: Project(groups=[anon_grp7]) Group(groups=[anon_grp7, izisprod.prod_P_PharmaRec AS pr__1], props={GROUP_COLS=[pr__1.PatientID], SYMBOL_MAP={anon_grp7.gcol0=pr__1.PatientID}, OUTPUT_COLS=[anon_grp7.gcol0], EST_CARDINALITY=734.5361, EST_COL_STATS={anon_grp7.gcol0=[244.84535, -1.0]}}) Select(groups=[izisprod.prod_P_PharmaRec AS pr__1]) Access(groups=[izisprod.prod_P_PharmaRec AS pr__1]) Select(groups=[izisprod.prod_P_PharmaRec AS pr__1]) Source(groups=[izisprod.prod_P_PharmaRec AS pr__1]) ============================================================================ EXECUTING CollapseSource AFTER: Project(groups=[anon_grp7], props={PROJECT_COLS=[anon_grp7.gcol0 AS PatientID], OUTPUT_COLS=[anon_grp7.gcol0 AS PatientID], EST_CARDINALITY=734.5361, EST_COL_STATS={anon_grp7.gcol0 AS PatientID=[244.84535, -1.0]}}) Group(groups=[anon_grp7, izisprod.prod_P_PharmaRec AS pr__1], props={GROUP_COLS=[pr__1.PatientID], SYMBOL_MAP={anon_grp7.gcol0=pr__1.PatientID}, OUTPUT_COLS=[anon_grp7.gcol0], EST_CARDINALITY=734.5361, EST_COL_STATS={anon_grp7.gcol0=[244.84535, -1.0]}}) Select(groups=[izisprod.prod_P_PharmaRec AS pr__1]) Access(groups=[izisprod.prod_P_PharmaRec AS pr__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[pr__1.Status, pr__1.PatientID], EST_CARDINALITY=1546.3917, EST_COL_STATS={pr__1.Status=[-1.0, -1.0], pr__1.PatientID=[-1.0, -1.0]}, ATOMIC_REQUEST=SELECT pr__1.Status, pr__1.PatientID FROM izisprod.prod_P_PharmaRec AS pr__1 WHERE pr__1.PharmaID = 1002463}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = ProjectNode(8) output=[anon_grp7.gcol0 AS PatientID] [anon_grp7.gcol0 AS PatientID] GroupingNode(9) output=[anon_grp7.gcol0] [pr__1.PatientID]{anon_grp7.gcol0=pr__1.PatientID} SelectNode(10) output=[pr__1.PatientID] bitand(convert(pr__1.Status, integer), 2) <> 2 AccessNode(11) output=[pr__1.Status, pr__1.PatientID] SELECT g_0.Status, g_0.PatientID FROM izisprod.prod_P_PharmaRec AS g_0 WHERE g_0.PharmaID = 1002463 ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: ProjectNode(8) output=[anon_grp7.gcol0 AS PatientID] [anon_grp7.gcol0 AS PatientID] GroupingNode(9) output=[anon_grp7.gcol0] [pr__1.PatientID]{anon_grp7.gcol0=pr__1.PatientID} SelectNode(10) output=[pr__1.PatientID] bitand(convert(pr__1.Status, integer), 2) <> 2 AccessNode(11) output=[pr__1.Status, pr__1.PatientID] SELECT g_0.Status, g_0.PatientID FROM izisprod.prod_P_PharmaRec AS g_0 WHERE g_0.PharmaID = 1002463 ============================================================================ ============================================================================ EXECUTING PlaceAccess AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100}) Sort(groups=[v], props={SORT_ORDER=ORDER BY v.admtime}) Project(groups=[v], props={PROJECT_COLS=[v.admissionid, v.patgroup, v.ward, v.admtime, v.distime, v.origin]}) Source(groups=[v], props={NESTED_COMMAND=SELECT anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin FROM (iziswh.wh_P_GeneralData AS gd INNER JOIN iziswh.wh_P_DischargeData AS dd ON gd.PatientID = dd.PatientID) INNER JOIN izisprod.prod_S_WardRef AS wr ON wr.WardID = gd.WardID WHERE gd.PatientID IN (SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID) GROUP BY gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime UNION ALL SELECT anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS PatGroup, anon_grp1.gcol2 AS Abbreviation, anon_grp1.gcol3 AS AdmissionTime, anon_grp1.gcol4 AS DischargeTime, 'prod' FROM (izisprod.prod_P_GeneralData AS gd INNER JOIN izisprod.prod_P_DischargeData AS dd ON gd__1.PatientID = dd__1.PatientID) INNER JOIN izisprod.prod_S_WardRef AS wr ON wr__1.WardID = gd__1.WardID WHERE (gd__1.PatientID IN (SELECT pr.PatientID FROM izisprod.prod_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID)) AND (gd__1.Status >= 4) AND (gd__1.Status <> 5) GROUP BY gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime, SYMBOL_MAP={v.admissionid=anon_grp0.gcol0, v.patgroup=anon_grp0.gcol1, v.ward=anon_grp0.gcol2, v.admtime=anon_grp0.gcol3, v.distime=anon_grp0.gcol4, v.origin='wh'}, PARTITION_INFO={v.origin=[['wh'], ['prod']]}}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin]}) Group(groups=[iziswh.wh_P_DischargeData AS dd, iziswh.wh_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr, anon_grp0], props={GROUP_COLS=[gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime], SYMBOL_MAP={anon_grp0.gcol0=gd.PatientID, anon_grp0.gcol1=gd.PatGroup, anon_grp0.gcol2=wr.Abbreviation, anon_grp0.gcol3=gd.AdmissionTime, anon_grp0.gcol4=dd.DischargeTime}}) Select(groups=[iziswh.wh_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.PatientID IN (SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID)}) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd, izisprod.prod_S_WardRef AS wr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[wr.WardID = gd.WardID]}) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd.PatientID = dd.PatientID]}) Access(groups=[iziswh.wh_P_GeneralData AS gd], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac}) Source(groups=[iziswh.wh_P_GeneralData AS gd]) Access(groups=[iziswh.wh_P_DischargeData AS dd], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac}) Source(groups=[iziswh.wh_P_DischargeData AS dd]) Access(groups=[izisprod.prod_S_WardRef AS wr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04}) Source(groups=[izisprod.prod_S_WardRef AS wr]) Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS PatGroup, anon_grp1.gcol2 AS Abbreviation, anon_grp1.gcol3 AS AdmissionTime, anon_grp1.gcol4 AS DischargeTime, 'prod']}) Group(groups=[anon_grp1, izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1], props={GROUP_COLS=[gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime], SYMBOL_MAP={anon_grp1.gcol0=gd__1.PatientID, anon_grp1.gcol1=gd__1.PatGroup, anon_grp1.gcol2=wr__1.Abbreviation, anon_grp1.gcol3=gd__1.AdmissionTime, anon_grp1.gcol4=dd__1.DischargeTime}}) Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.Status <> 5}) Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.Status >= 4}) Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.PatientID IN (SELECT pr.PatientID FROM izisprod.prod_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID)}) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[wr__1.WardID = gd__1.WardID]}) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd__1.PatientID = dd__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]) Access(groups=[izisprod.prod_P_DischargeData AS dd__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04}) Source(groups=[izisprod.prod_P_DischargeData AS dd__1]) Access(groups=[izisprod.prod_S_WardRef AS wr__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04}) Source(groups=[izisprod.prod_S_WardRef AS wr__1]) ============================================================================ EXECUTING AssignOutputElements AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=[v.admissionid, v.patgroup, v.ward, v.admtime, v.distime, v.origin]}) Sort(groups=[v], props={SORT_ORDER=ORDER BY v.admtime, OUTPUT_COLS=[v.admissionid, v.patgroup, v.ward, v.admtime, v.distime, v.origin], UNRELATED_SORT=false}) Project(groups=[v], props={PROJECT_COLS=[v.admissionid, v.patgroup, v.ward, v.admtime, v.distime, v.origin], OUTPUT_COLS=[v.admissionid, v.patgroup, v.ward, v.admtime, v.distime, v.origin]}) Source(groups=[v], props={NESTED_COMMAND=SELECT anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin FROM (iziswh.wh_P_GeneralData AS gd INNER JOIN iziswh.wh_P_DischargeData AS dd ON gd.PatientID = dd.PatientID) INNER JOIN izisprod.prod_S_WardRef AS wr ON wr.WardID = gd.WardID WHERE gd.PatientID IN (SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID) GROUP BY gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime UNION ALL SELECT anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS PatGroup, anon_grp1.gcol2 AS Abbreviation, anon_grp1.gcol3 AS AdmissionTime, anon_grp1.gcol4 AS DischargeTime, 'prod' FROM (izisprod.prod_P_GeneralData AS gd INNER JOIN izisprod.prod_P_DischargeData AS dd ON gd__1.PatientID = dd__1.PatientID) INNER JOIN izisprod.prod_S_WardRef AS wr ON wr__1.WardID = gd__1.WardID WHERE (gd__1.PatientID IN (SELECT pr.PatientID FROM izisprod.prod_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID)) AND (gd__1.Status >= 4) AND (gd__1.Status <> 5) GROUP BY gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime, SYMBOL_MAP={v.admissionid=anon_grp0.gcol0, v.patgroup=anon_grp0.gcol1, v.ward=anon_grp0.gcol2, v.admtime=anon_grp0.gcol3, v.distime=anon_grp0.gcol4, v.origin='wh'}, PARTITION_INFO={v.origin=[['wh'], ['prod']]}, OUTPUT_COLS=[v.admissionid, v.patgroup, v.ward, v.admtime, v.distime, v.origin]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin]}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin], OUTPUT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin]}) Group(groups=[iziswh.wh_P_DischargeData AS dd, iziswh.wh_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr, anon_grp0], props={GROUP_COLS=[gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime], SYMBOL_MAP={anon_grp0.gcol0=gd.PatientID, anon_grp0.gcol1=gd.PatGroup, anon_grp0.gcol2=wr.Abbreviation, anon_grp0.gcol3=gd.AdmissionTime, anon_grp0.gcol4=dd.DischargeTime}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.gcol2, anon_grp0.gcol3, anon_grp0.gcol4]}) Select(groups=[iziswh.wh_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.PatientID IN (SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID), OUTPUT_COLS=[gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime]}) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd, izisprod.prod_S_WardRef AS wr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[wr.WardID = gd.WardID], OUTPUT_COLS=[gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime]}) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd.PatientID = dd.PatientID], OUTPUT_COLS=[gd.WardID, gd.PatientID, gd.PatGroup, gd.AdmissionTime, dd.DischargeTime]}) Access(groups=[iziswh.wh_P_GeneralData AS gd], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[gd.PatientID, gd.WardID, gd.PatGroup, gd.AdmissionTime]}) Source(groups=[iziswh.wh_P_GeneralData AS gd], props={OUTPUT_COLS=[gd.PatientID, gd.WardID, gd.PatGroup, gd.AdmissionTime]}) Access(groups=[iziswh.wh_P_DischargeData AS dd], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[dd.PatientID, dd.DischargeTime]}) Source(groups=[iziswh.wh_P_DischargeData AS dd], props={OUTPUT_COLS=[dd.PatientID, dd.DischargeTime]}) Access(groups=[izisprod.prod_S_WardRef AS wr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[wr.WardID, wr.Abbreviation]}) Source(groups=[izisprod.prod_S_WardRef AS wr], props={OUTPUT_COLS=[wr.WardID, wr.Abbreviation]}) Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS PatGroup, anon_grp1.gcol2 AS Abbreviation, anon_grp1.gcol3 AS AdmissionTime, anon_grp1.gcol4 AS DischargeTime, 'prod'], OUTPUT_COLS=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS PatGroup, anon_grp1.gcol2 AS Abbreviation, anon_grp1.gcol3 AS AdmissionTime, anon_grp1.gcol4 AS DischargeTime, 'prod']}) Group(groups=[anon_grp1, izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1], props={GROUP_COLS=[gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime], SYMBOL_MAP={anon_grp1.gcol0=gd__1.PatientID, anon_grp1.gcol1=gd__1.PatGroup, anon_grp1.gcol2=wr__1.Abbreviation, anon_grp1.gcol3=gd__1.AdmissionTime, anon_grp1.gcol4=dd__1.DischargeTime}, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3, anon_grp1.gcol4]}) Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.Status <> 5, OUTPUT_COLS=[gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime]}) Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.Status >= 4, OUTPUT_COLS=[gd__1.Status, gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime]}) Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.PatientID IN (SELECT pr.PatientID FROM izisprod.prod_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID), OUTPUT_COLS=[gd__1.Status, gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime]}) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[wr__1.WardID = gd__1.WardID], OUTPUT_COLS=[gd__1.PatientID, gd__1.Status, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime]}) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd__1.PatientID = dd__1.PatientID], OUTPUT_COLS=[gd__1.WardID, gd__1.PatientID, gd__1.Status, gd__1.PatGroup, gd__1.AdmissionTime, dd__1.DischargeTime]}) 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.WardID, gd__1.Status, gd__1.PatGroup, gd__1.AdmissionTime]}) Source(groups=[izisprod.prod_P_GeneralData AS gd__1], props={OUTPUT_COLS=[gd__1.PatientID, gd__1.WardID, gd__1.Status, gd__1.PatGroup, gd__1.AdmissionTime]}) Access(groups=[izisprod.prod_P_DischargeData AS dd__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[dd__1.PatientID, dd__1.DischargeTime]}) Source(groups=[izisprod.prod_P_DischargeData AS dd__1], props={OUTPUT_COLS=[dd__1.PatientID, dd__1.DischargeTime]}) Access(groups=[izisprod.prod_S_WardRef AS wr__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[wr__1.WardID, wr__1.Abbreviation]}) Source(groups=[izisprod.prod_S_WardRef AS wr__1], props={OUTPUT_COLS=[wr__1.WardID, wr__1.Abbreviation]}) ============================================================================ EXECUTING MergeVirtual AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0], props={SORT_ORDER=ORDER BY admtime, OUTPUT_COLS=[v.admissionid, v.patgroup, v.ward, v.admtime, v.distime, v.origin], UNRELATED_SORT=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin]}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin], OUTPUT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin]}) Group(groups=[iziswh.wh_P_DischargeData AS dd, iziswh.wh_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr, anon_grp0]) Select(groups=[iziswh.wh_P_GeneralData AS gd]) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd, izisprod.prod_S_WardRef AS wr]) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd]) Access(groups=[iziswh.wh_P_GeneralData AS gd]) Source(groups=[iziswh.wh_P_GeneralData AS gd]) Access(groups=[iziswh.wh_P_DischargeData AS dd]) Source(groups=[iziswh.wh_P_DischargeData AS dd]) Access(groups=[izisprod.prod_S_WardRef AS wr]) Source(groups=[izisprod.prod_S_WardRef AS wr]) Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS PatGroup, anon_grp1.gcol2 AS Abbreviation, anon_grp1.gcol3 AS AdmissionTime, anon_grp1.gcol4 AS DischargeTime, 'prod'], OUTPUT_COLS=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS PatGroup, anon_grp1.gcol2 AS Abbreviation, anon_grp1.gcol3 AS AdmissionTime, anon_grp1.gcol4 AS DischargeTime, 'prod']}) Group(groups=[anon_grp1, izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Select(groups=[izisprod.prod_P_GeneralData AS gd__1]) Select(groups=[izisprod.prod_P_GeneralData AS gd__1]) Select(groups=[izisprod.prod_P_GeneralData AS gd__1]) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1]) Access(groups=[izisprod.prod_P_GeneralData AS gd__1]) Source(groups=[izisprod.prod_P_GeneralData AS gd__1]) Access(groups=[izisprod.prod_P_DischargeData AS dd__1]) Source(groups=[izisprod.prod_P_DischargeData AS dd__1]) Access(groups=[izisprod.prod_S_WardRef AS wr__1]) Source(groups=[izisprod.prod_S_WardRef AS wr__1]) ============================================================================ EXECUTING DecomposeJoin AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) SetOperation(groups=[]) Project(groups=[anon_grp0]) Group(groups=[iziswh.wh_P_DischargeData AS dd, iziswh.wh_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr, anon_grp0]) Select(groups=[iziswh.wh_P_GeneralData AS gd]) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd, izisprod.prod_S_WardRef AS wr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[wr.WardID = gd.WardID], OUTPUT_COLS=[gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime]}) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd.PatientID = dd.PatientID], OUTPUT_COLS=[gd.WardID, gd.PatientID, gd.PatGroup, gd.AdmissionTime, dd.DischargeTime]}) Access(groups=[iziswh.wh_P_GeneralData AS gd]) Source(groups=[iziswh.wh_P_GeneralData AS gd]) Access(groups=[iziswh.wh_P_DischargeData AS dd]) Source(groups=[iziswh.wh_P_DischargeData AS dd]) Access(groups=[izisprod.prod_S_WardRef AS wr]) Source(groups=[izisprod.prod_S_WardRef AS wr]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Select(groups=[izisprod.prod_P_GeneralData AS gd__1]) Select(groups=[izisprod.prod_P_GeneralData AS gd__1]) Select(groups=[izisprod.prod_P_GeneralData AS gd__1]) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[wr__1.WardID = gd__1.WardID], OUTPUT_COLS=[gd__1.PatientID, gd__1.Status, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime]}) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd__1.PatientID = dd__1.PatientID], OUTPUT_COLS=[gd__1.WardID, gd__1.PatientID, gd__1.Status, gd__1.PatGroup, gd__1.AdmissionTime, dd__1.DischargeTime]}) Access(groups=[izisprod.prod_P_GeneralData AS gd__1]) Source(groups=[izisprod.prod_P_GeneralData AS gd__1]) Access(groups=[izisprod.prod_P_DischargeData AS dd__1]) Source(groups=[izisprod.prod_P_DischargeData AS dd__1]) Access(groups=[izisprod.prod_S_WardRef AS wr__1]) Source(groups=[izisprod.prod_S_WardRef AS wr__1]) ============================================================================ EXECUTING PushSelectCriteria AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) SetOperation(groups=[]) Project(groups=[anon_grp0]) Group(groups=[iziswh.wh_P_DischargeData AS dd, iziswh.wh_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr, anon_grp0], props={GROUP_COLS=[gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime], SYMBOL_MAP={anon_grp0.gcol0=gd.PatientID, anon_grp0.gcol1=gd.PatGroup, anon_grp0.gcol2=wr.Abbreviation, anon_grp0.gcol3=gd.AdmissionTime, anon_grp0.gcol4=dd.DischargeTime}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.gcol2, anon_grp0.gcol3, anon_grp0.gcol4]}) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd, izisprod.prod_S_WardRef AS wr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[wr.WardID = gd.WardID], OUTPUT_COLS=[gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime]}) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd.PatientID = dd.PatientID], OUTPUT_COLS=[gd.WardID, gd.PatientID, gd.PatGroup, gd.AdmissionTime, dd.DischargeTime]}) Select(groups=[iziswh.wh_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.PatientID IN (SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID), OUTPUT_COLS=[gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime]}) Access(groups=[iziswh.wh_P_GeneralData AS gd], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[gd.PatientID, gd.WardID, gd.PatGroup, gd.AdmissionTime]}) Source(groups=[iziswh.wh_P_GeneralData AS gd]) Access(groups=[iziswh.wh_P_DischargeData AS dd]) Source(groups=[iziswh.wh_P_DischargeData AS dd]) Access(groups=[izisprod.prod_S_WardRef AS wr]) Source(groups=[izisprod.prod_S_WardRef AS wr]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1], props={GROUP_COLS=[gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime], SYMBOL_MAP={anon_grp1.gcol0=gd__1.PatientID, anon_grp1.gcol1=gd__1.PatGroup, anon_grp1.gcol2=wr__1.Abbreviation, anon_grp1.gcol3=gd__1.AdmissionTime, anon_grp1.gcol4=dd__1.DischargeTime}, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3, anon_grp1.gcol4]}) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[wr__1.WardID = gd__1.WardID], OUTPUT_COLS=[gd__1.PatientID, gd__1.Status, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime]}) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd__1.PatientID = dd__1.PatientID], OUTPUT_COLS=[gd__1.WardID, gd__1.PatientID, gd__1.Status, gd__1.PatGroup, gd__1.AdmissionTime, dd__1.DischargeTime]}) Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.PatientID IN (SELECT pr.PatientID FROM izisprod.prod_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID), OUTPUT_COLS=[gd__1.Status, gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime]}) 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.WardID, gd__1.Status, gd__1.PatGroup, gd__1.AdmissionTime]}) Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=(gd__1.Status >= 4) AND (gd__1.Status <> 5), OUTPUT_COLS=[gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime]}) Source(groups=[izisprod.prod_P_GeneralData AS gd__1], props={OUTPUT_COLS=[gd__1.PatientID, gd__1.WardID, gd__1.Status, gd__1.PatGroup, gd__1.AdmissionTime]}) Access(groups=[izisprod.prod_P_DischargeData AS dd__1]) Source(groups=[izisprod.prod_P_DischargeData AS dd__1]) Access(groups=[izisprod.prod_S_WardRef AS wr__1]) Source(groups=[izisprod.prod_S_WardRef AS wr__1]) ============================================================================ EXECUTING MergeVirtual AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) SetOperation(groups=[]) Project(groups=[anon_grp0]) Group(groups=[iziswh.wh_P_DischargeData AS dd, iziswh.wh_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr, anon_grp0]) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd, izisprod.prod_S_WardRef AS wr]) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd]) Select(groups=[iziswh.wh_P_GeneralData AS gd]) Access(groups=[iziswh.wh_P_GeneralData AS gd]) Source(groups=[iziswh.wh_P_GeneralData AS gd]) Access(groups=[iziswh.wh_P_DischargeData AS dd]) Source(groups=[iziswh.wh_P_DischargeData AS dd]) Access(groups=[izisprod.prod_S_WardRef AS wr]) Source(groups=[izisprod.prod_S_WardRef AS wr]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1]) Select(groups=[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]) Access(groups=[izisprod.prod_P_DischargeData AS dd__1]) Source(groups=[izisprod.prod_P_DischargeData AS dd__1]) Access(groups=[izisprod.prod_S_WardRef AS wr__1]) Source(groups=[izisprod.prod_S_WardRef AS wr__1]) ============================================================================ EXECUTING PushNonJoinCriteria AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) SetOperation(groups=[]) Project(groups=[anon_grp0]) Group(groups=[iziswh.wh_P_DischargeData AS dd, iziswh.wh_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr, anon_grp0]) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd, izisprod.prod_S_WardRef AS wr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[wr.WardID = gd.WardID], OUTPUT_COLS=[gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime]}) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd.PatientID = dd.PatientID], OUTPUT_COLS=[gd.WardID, gd.PatientID, gd.PatGroup, gd.AdmissionTime, dd.DischargeTime]}) Select(groups=[iziswh.wh_P_GeneralData AS gd]) Access(groups=[iziswh.wh_P_GeneralData AS gd]) Source(groups=[iziswh.wh_P_GeneralData AS gd]) Access(groups=[iziswh.wh_P_DischargeData AS dd]) Source(groups=[iziswh.wh_P_DischargeData AS dd]) Access(groups=[izisprod.prod_S_WardRef AS wr]) Source(groups=[izisprod.prod_S_WardRef AS wr]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[wr__1.WardID = gd__1.WardID], OUTPUT_COLS=[gd__1.PatientID, gd__1.Status, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime]}) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd__1.PatientID = dd__1.PatientID], OUTPUT_COLS=[gd__1.WardID, gd__1.PatientID, gd__1.Status, gd__1.PatGroup, gd__1.AdmissionTime, dd__1.DischargeTime]}) Select(groups=[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]) Access(groups=[izisprod.prod_P_DischargeData AS dd__1]) Source(groups=[izisprod.prod_P_DischargeData AS dd__1]) Access(groups=[izisprod.prod_S_WardRef AS wr__1]) Source(groups=[izisprod.prod_S_WardRef AS wr__1]) ============================================================================ EXECUTING CleanCriteria AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=null}) Sort(groups=[anon_grp0], props={SORT_ORDER=ORDER BY admtime, OUTPUT_COLS=null, UNRELATED_SORT=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=null}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin], OUTPUT_COLS=null}) Group(groups=[iziswh.wh_P_DischargeData AS dd, iziswh.wh_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr, anon_grp0], props={GROUP_COLS=[gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime], SYMBOL_MAP={anon_grp0.gcol0=gd.PatientID, anon_grp0.gcol1=gd.PatGroup, anon_grp0.gcol2=wr.Abbreviation, anon_grp0.gcol3=gd.AdmissionTime, anon_grp0.gcol4=dd.DischargeTime}, OUTPUT_COLS=null}) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd, izisprod.prod_S_WardRef AS wr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[wr.WardID = gd.WardID], OUTPUT_COLS=null}) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd.PatientID = dd.PatientID], OUTPUT_COLS=null}) Select(groups=[iziswh.wh_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.PatientID IN (SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID), OUTPUT_COLS=null}) Access(groups=[iziswh.wh_P_GeneralData AS gd], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null}) Source(groups=[iziswh.wh_P_GeneralData AS gd], props={OUTPUT_COLS=null}) Access(groups=[iziswh.wh_P_DischargeData AS dd], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null}) Source(groups=[iziswh.wh_P_DischargeData AS dd], props={OUTPUT_COLS=null}) Access(groups=[izisprod.prod_S_WardRef AS wr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null}) Source(groups=[izisprod.prod_S_WardRef AS wr], props={OUTPUT_COLS=null}) Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS PatGroup, anon_grp1.gcol2 AS Abbreviation, anon_grp1.gcol3 AS AdmissionTime, anon_grp1.gcol4 AS DischargeTime, 'prod'], OUTPUT_COLS=null}) Group(groups=[anon_grp1, izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1], props={GROUP_COLS=[gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime], SYMBOL_MAP={anon_grp1.gcol0=gd__1.PatientID, anon_grp1.gcol1=gd__1.PatGroup, anon_grp1.gcol2=wr__1.Abbreviation, anon_grp1.gcol3=gd__1.AdmissionTime, anon_grp1.gcol4=dd__1.DischargeTime}, OUTPUT_COLS=null}) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[wr__1.WardID = gd__1.WardID], OUTPUT_COLS=null}) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd__1.PatientID = dd__1.PatientID], OUTPUT_COLS=null}) Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.PatientID IN (SELECT pr.PatientID FROM izisprod.prod_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.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 >= 4) AND (gd__1.Status <> 5), OUTPUT_COLS=null}) Source(groups=[izisprod.prod_P_GeneralData AS gd__1], props={OUTPUT_COLS=null}) Access(groups=[izisprod.prod_P_DischargeData AS dd__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null}) Source(groups=[izisprod.prod_P_DischargeData AS dd__1], props={OUTPUT_COLS=null}) Access(groups=[izisprod.prod_S_WardRef AS wr__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null}) Source(groups=[izisprod.prod_S_WardRef AS wr__1], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING PlanUnions AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=null}) Project(groups=[anon_grp0]) Group(groups=[iziswh.wh_P_DischargeData AS dd, iziswh.wh_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr, anon_grp0]) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd, izisprod.prod_S_WardRef AS wr]) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd]) Select(groups=[iziswh.wh_P_GeneralData AS gd]) Access(groups=[iziswh.wh_P_GeneralData AS gd], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null}) Source(groups=[iziswh.wh_P_GeneralData AS gd]) Access(groups=[iziswh.wh_P_DischargeData AS dd], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null}) Source(groups=[iziswh.wh_P_DischargeData AS dd]) Access(groups=[izisprod.prod_S_WardRef AS wr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null}) Source(groups=[izisprod.prod_S_WardRef AS wr]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1]) Select(groups=[izisprod.prod_P_GeneralData AS gd__1]) 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]) Access(groups=[izisprod.prod_P_DischargeData AS dd__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null}) Source(groups=[izisprod.prod_P_DischargeData AS dd__1]) Access(groups=[izisprod.prod_S_WardRef AS wr__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null}) Source(groups=[izisprod.prod_S_WardRef AS wr__1]) ============================================================================ EXECUTING RaiseAccess LOW Relational Planner Subquery cannot be pushed down iziswh - SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID was not pushed LOW Relational Planner Subquery cannot be pushed down iziswh - SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID was not pushed LOW Relational Planner Subquery cannot be pushed down izisprod - SELECT pr.PatientID FROM izisprod.prod_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID was not pushed LOW Relational Planner Subquery cannot be pushed down izisprod - SELECT pr.PatientID FROM izisprod.prod_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID was not pushed LOW Relational Planner Subquery cannot be pushed down izisprod - SELECT pr.PatientID FROM izisprod.prod_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID was not pushed AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) SetOperation(groups=[]) Project(groups=[anon_grp0]) Group(groups=[iziswh.wh_P_DischargeData AS dd, iziswh.wh_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr, anon_grp0]) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd, izisprod.prod_S_WardRef AS wr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[wr.WardID = gd.WardID], OUTPUT_COLS=null}) Select(groups=[iziswh.wh_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.PatientID IN (SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID), OUTPUT_COLS=null}) Access(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null, CONFORMED_SOURCES=null}) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd.PatientID = dd.PatientID], OUTPUT_COLS=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac}) Source(groups=[iziswh.wh_P_GeneralData AS gd], props={OUTPUT_COLS=null}) Source(groups=[iziswh.wh_P_DischargeData AS dd], props={OUTPUT_COLS=null}) Access(groups=[izisprod.prod_S_WardRef AS wr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null}) Source(groups=[izisprod.prod_S_WardRef AS wr]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1], props={GROUP_COLS=[gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime], SYMBOL_MAP={anon_grp1.gcol0=gd__1.PatientID, anon_grp1.gcol1=gd__1.PatGroup, anon_grp1.gcol2=wr__1.Abbreviation, anon_grp1.gcol3=gd__1.AdmissionTime, anon_grp1.gcol4=dd__1.DischargeTime}, OUTPUT_COLS=null}) Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.PatientID IN (SELECT pr.PatientID FROM izisprod.prod_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID), OUTPUT_COLS=null}) Access(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null, CONFORMED_SOURCES=null}) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[wr__1.WardID = gd__1.WardID], OUTPUT_COLS=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04}) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd__1.PatientID = dd__1.PatientID], OUTPUT_COLS=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04}) Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=(gd__1.Status >= 4) AND (gd__1.Status <> 5), OUTPUT_COLS=null}) Source(groups=[izisprod.prod_P_GeneralData AS gd__1]) Source(groups=[izisprod.prod_P_DischargeData AS dd__1], props={OUTPUT_COLS=null}) Source(groups=[izisprod.prod_S_WardRef AS wr__1], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING CopyCriteria AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) SetOperation(groups=[]) Project(groups=[anon_grp0]) Group(groups=[iziswh.wh_P_DischargeData AS dd, iziswh.wh_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr, anon_grp0]) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd, izisprod.prod_S_WardRef AS wr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[wr.WardID = gd.WardID], OUTPUT_COLS=null, IS_COPIED=true}) Select(groups=[iziswh.wh_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.PatientID IN (SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID), OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd]) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd.PatientID = dd.PatientID], OUTPUT_COLS=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, IS_COPIED=true}) Source(groups=[iziswh.wh_P_GeneralData AS gd]) Source(groups=[iziswh.wh_P_DischargeData AS dd]) Access(groups=[izisprod.prod_S_WardRef AS wr]) Source(groups=[izisprod.prod_S_WardRef AS wr]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.PatientID IN (SELECT pr.PatientID FROM izisprod.prod_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID), OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[wr__1.WardID = gd__1.WardID], OUTPUT_COLS=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, IS_COPIED=true}) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd__1.PatientID = dd__1.PatientID], OUTPUT_COLS=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, IS_COPIED=true}) Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=(gd__1.Status >= 4) AND (gd__1.Status <> 5), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[izisprod.prod_P_GeneralData AS gd__1]) Source(groups=[izisprod.prod_P_DischargeData AS dd__1]) Source(groups=[izisprod.prod_S_WardRef AS wr__1]) ============================================================================ EXECUTING CleanCriteria AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=null}) Sort(groups=[anon_grp0], props={SORT_ORDER=ORDER BY admtime, OUTPUT_COLS=null, UNRELATED_SORT=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=null}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin], OUTPUT_COLS=null}) Group(groups=[iziswh.wh_P_DischargeData AS dd, iziswh.wh_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr, anon_grp0], props={GROUP_COLS=[gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime], SYMBOL_MAP={anon_grp0.gcol0=gd.PatientID, anon_grp0.gcol1=gd.PatGroup, anon_grp0.gcol2=wr.Abbreviation, anon_grp0.gcol3=gd.AdmissionTime, anon_grp0.gcol4=dd.DischargeTime}, OUTPUT_COLS=null}) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd, izisprod.prod_S_WardRef AS wr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[wr.WardID = gd.WardID], OUTPUT_COLS=null, IS_COPIED=true}) Select(groups=[iziswh.wh_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.PatientID IN (SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID), OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null, CONFORMED_SOURCES=null}) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd.PatientID = dd.PatientID], OUTPUT_COLS=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, IS_COPIED=true}) Source(groups=[iziswh.wh_P_GeneralData AS gd], props={OUTPUT_COLS=null}) Source(groups=[iziswh.wh_P_DischargeData AS dd], props={OUTPUT_COLS=null}) Access(groups=[izisprod.prod_S_WardRef AS wr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null}) Source(groups=[izisprod.prod_S_WardRef AS wr], props={OUTPUT_COLS=null}) Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS PatGroup, anon_grp1.gcol2 AS Abbreviation, anon_grp1.gcol3 AS AdmissionTime, anon_grp1.gcol4 AS DischargeTime, 'prod'], OUTPUT_COLS=null}) Group(groups=[anon_grp1, izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1], props={GROUP_COLS=[gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime], SYMBOL_MAP={anon_grp1.gcol0=gd__1.PatientID, anon_grp1.gcol1=gd__1.PatGroup, anon_grp1.gcol2=wr__1.Abbreviation, anon_grp1.gcol3=gd__1.AdmissionTime, anon_grp1.gcol4=dd__1.DischargeTime}, OUTPUT_COLS=null}) Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.PatientID IN (SELECT pr.PatientID FROM izisprod.prod_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID), OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null, CONFORMED_SOURCES=null}) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[wr__1.WardID = gd__1.WardID], OUTPUT_COLS=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, IS_COPIED=true}) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd__1.PatientID = dd__1.PatientID], OUTPUT_COLS=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, IS_COPIED=true}) Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=(gd__1.Status >= 4) AND (gd__1.Status <> 5), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[izisprod.prod_P_GeneralData AS gd__1], props={OUTPUT_COLS=null}) Source(groups=[izisprod.prod_P_DischargeData AS dd__1], props={OUTPUT_COLS=null}) Source(groups=[izisprod.prod_S_WardRef AS wr__1], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING PlanJoins AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) SetOperation(groups=[]) Project(groups=[anon_grp0]) Group(groups=[iziswh.wh_P_DischargeData AS dd, iziswh.wh_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr, anon_grp0], props={GROUP_COLS=[gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime], SYMBOL_MAP={anon_grp0.gcol0=gd.PatientID, anon_grp0.gcol1=gd.PatGroup, anon_grp0.gcol2=wr.Abbreviation, anon_grp0.gcol3=gd.AdmissionTime, anon_grp0.gcol4=dd.DischargeTime}, OUTPUT_COLS=null}) Select(groups=[iziswh.wh_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr], props={SELECT_CRITERIA=wr.WardID = gd.WardID, EST_SELECTIVITY=0.037}) Join(groups=[izisprod.prod_S_WardRef AS wr, iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP}) Access(groups=[izisprod.prod_S_WardRef AS wr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null, EST_CARDINALITY=70.0, EST_COL_STATS={wr.Abbreviation=[-1.0, -1.0], wr.Address=[-1.0, -1.0], wr.ArchStatus=[-1.0, -1.0], wr.ArchTime=[-1.0, -1.0], ...}}) Source(groups=[izisprod.prod_S_WardRef AS wr], props={OUTPUT_COLS=null, EST_COL_STATS={wr.Abbreviation=[-1.0, -1.0], wr.Address=[-1.0, -1.0], wr.ArchStatus=[-1.0, -1.0], wr.ArchTime=[-1.0, -1.0], ...}, EST_CARDINALITY=70.0}) Select(groups=[iziswh.wh_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.PatientID IN (SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=15000.0, EST_COL_STATS={gd.Address=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], gd.AdmissionWard=[-1.0, -1.0], gd.BedID=[-1.0, -1.0], ...}}) Access(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=45000.0, EST_COL_STATS={gd.Address=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], gd.AdmissionWard=[-1.0, -1.0], gd.BedID=[-1.0, -1.0], ...}}) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd.PatientID = dd.PatientID], OUTPUT_COLS=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, IS_COPIED=true, EST_CARDINALITY=45000.0, EST_COL_STATS={gd.Address=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], gd.AdmissionWard=[-1.0, -1.0], gd.BedID=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_GeneralData AS gd], props={OUTPUT_COLS=null, EST_COL_STATS={gd.Address=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], gd.AdmissionWard=[-1.0, -1.0], gd.BedID=[-1.0, -1.0], ...}, EST_CARDINALITY=45000.0}) Source(groups=[iziswh.wh_P_DischargeData AS dd], props={OUTPUT_COLS=null, EST_COL_STATS={dd.ActorID=[-1.0, -1.0], dd.DischargeTime=[-1.0, -1.0], dd.DischargedTo=[-1.0, -1.0], dd.ICUDiagnosis=[-1.0, -1.0], ...}, EST_CARDINALITY=45000.0}) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Select(groups=[izisprod.prod_P_GeneralData AS gd__1]) Access(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1]) Select(groups=[izisprod.prod_P_GeneralData AS gd__1]) Source(groups=[izisprod.prod_P_GeneralData AS gd__1]) Source(groups=[izisprod.prod_P_DischargeData AS dd__1]) Source(groups=[izisprod.prod_S_WardRef AS wr__1]) ============================================================================ EXECUTING PushSelectCriteria AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) SetOperation(groups=[]) Project(groups=[anon_grp0]) Group(groups=[iziswh.wh_P_DischargeData AS dd, iziswh.wh_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr, anon_grp0], props={GROUP_COLS=[gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime], SYMBOL_MAP={anon_grp0.gcol0=gd.PatientID, anon_grp0.gcol1=gd.PatGroup, anon_grp0.gcol2=wr.Abbreviation, anon_grp0.gcol3=gd.AdmissionTime, anon_grp0.gcol4=dd.DischargeTime}, OUTPUT_COLS=null}) Join(groups=[izisprod.prod_S_WardRef AS wr, iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[wr.WardID = gd.WardID]}) Access(groups=[izisprod.prod_S_WardRef AS wr]) Source(groups=[izisprod.prod_S_WardRef AS wr]) Select(groups=[iziswh.wh_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.PatientID IN (SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=15000.0, EST_COL_STATS={gd.Address=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], gd.AdmissionWard=[-1.0, -1.0], gd.BedID=[-1.0, -1.0], ...}}) Access(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd]) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd]) Source(groups=[iziswh.wh_P_GeneralData AS gd]) Source(groups=[iziswh.wh_P_DischargeData AS dd]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.PatientID IN (SELECT pr.PatientID FROM izisprod.prod_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID), OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1]) Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=(gd__1.Status >= 4) AND (gd__1.Status <> 5), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[izisprod.prod_P_GeneralData AS gd__1]) Source(groups=[izisprod.prod_P_DischargeData AS dd__1]) Source(groups=[izisprod.prod_S_WardRef AS wr__1]) ============================================================================ EXECUTING RaiseAccess LOW Relational Planner Subquery cannot be pushed down iziswh - SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID was not pushed LOW Relational Planner Subquery cannot be pushed down izisprod - SELECT pr.PatientID FROM izisprod.prod_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID was not pushed AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) SetOperation(groups=[]) Project(groups=[anon_grp0]) Group(groups=[iziswh.wh_P_DischargeData AS dd, iziswh.wh_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr, anon_grp0]) Join(groups=[izisprod.prod_S_WardRef AS wr, iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[wr.WardID = gd.WardID]}) Access(groups=[izisprod.prod_S_WardRef AS wr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null, EST_CARDINALITY=70.0, EST_COL_STATS={wr.Abbreviation=[-1.0, -1.0], wr.Address=[-1.0, -1.0], wr.ArchStatus=[-1.0, -1.0], wr.ArchTime=[-1.0, -1.0], ...}}) Source(groups=[izisprod.prod_S_WardRef AS wr]) Select(groups=[iziswh.wh_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.PatientID IN (SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=15000.0, EST_COL_STATS={gd.Address=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], gd.AdmissionWard=[-1.0, -1.0], gd.BedID=[-1.0, -1.0], ...}}) Access(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=45000.0, EST_COL_STATS={gd.Address=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], gd.AdmissionWard=[-1.0, -1.0], gd.BedID=[-1.0, -1.0], ...}}) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd]) Source(groups=[iziswh.wh_P_GeneralData AS gd]) Source(groups=[iziswh.wh_P_DischargeData AS dd]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.PatientID IN (SELECT pr.PatientID FROM izisprod.prod_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID), OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null, CONFORMED_SOURCES=null}) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1]) Select(groups=[izisprod.prod_P_GeneralData AS gd__1]) Source(groups=[izisprod.prod_P_GeneralData AS gd__1]) Source(groups=[izisprod.prod_P_DischargeData AS dd__1]) Source(groups=[izisprod.prod_S_WardRef AS wr__1]) ============================================================================ EXECUTING ChooseJoinStrategy AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) SetOperation(groups=[]) Project(groups=[anon_grp0]) Group(groups=[iziswh.wh_P_DischargeData AS dd, iziswh.wh_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr, anon_grp0]) Join(groups=[izisprod.prod_S_WardRef AS wr, iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[wr.WardID = gd.WardID], LEFT_EXPRESSIONS=[wr.WardID], RIGHT_EXPRESSIONS=[gd.WardID], NON_EQUI_JOIN_CRITERIA=[]}) Access(groups=[izisprod.prod_S_WardRef AS wr]) Source(groups=[izisprod.prod_S_WardRef AS wr]) Select(groups=[iziswh.wh_P_GeneralData AS gd]) Access(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd]) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd]) Source(groups=[iziswh.wh_P_GeneralData AS gd]) Source(groups=[iziswh.wh_P_DischargeData AS dd]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Select(groups=[izisprod.prod_P_GeneralData AS gd__1]) Access(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1]) Select(groups=[izisprod.prod_P_GeneralData AS gd__1]) Source(groups=[izisprod.prod_P_GeneralData AS gd__1]) Source(groups=[izisprod.prod_P_DischargeData AS dd__1]) Source(groups=[izisprod.prod_S_WardRef AS wr__1]) ============================================================================ EXECUTING ChooseDependent AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) SetOperation(groups=[]) Project(groups=[anon_grp0]) Group(groups=[iziswh.wh_P_DischargeData AS dd, iziswh.wh_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr, anon_grp0]) Join(groups=[izisprod.prod_S_WardRef AS wr, iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[wr.WardID = gd.WardID], LEFT_EXPRESSIONS=[wr.WardID], RIGHT_EXPRESSIONS=[gd.WardID], NON_EQUI_JOIN_CRITERIA=[]}) Access(groups=[izisprod.prod_S_WardRef AS wr]) Source(groups=[izisprod.prod_S_WardRef AS wr]) Select(groups=[iziswh.wh_P_GeneralData AS gd]) Access(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd]) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd]) Source(groups=[iziswh.wh_P_GeneralData AS gd]) Source(groups=[iziswh.wh_P_DischargeData AS dd]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Select(groups=[izisprod.prod_P_GeneralData AS gd__1]) Access(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1]) Select(groups=[izisprod.prod_P_GeneralData AS gd__1]) Source(groups=[izisprod.prod_P_GeneralData AS gd__1]) Source(groups=[izisprod.prod_P_DischargeData AS dd__1]) Source(groups=[izisprod.prod_S_WardRef AS wr__1]) ============================================================================ EXECUTING PushAggregates AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) SetOperation(groups=[]) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin], OUTPUT_COLS=null}) Group(groups=[iziswh.wh_P_DischargeData AS dd, iziswh.wh_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr, anon_grp0], props={GROUP_COLS=[gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime], SYMBOL_MAP={anon_grp0.gcol0=gd.PatientID, anon_grp0.gcol1=gd.PatGroup, anon_grp0.gcol2=wr.Abbreviation, anon_grp0.gcol3=gd.AdmissionTime, anon_grp0.gcol4=dd.DischargeTime}, OUTPUT_COLS=null}) Join(groups=[izisprod.prod_S_WardRef AS wr, iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[wr.WardID = gd.WardID], LEFT_EXPRESSIONS=[wr.WardID], RIGHT_EXPRESSIONS=[gd.WardID], NON_EQUI_JOIN_CRITERIA=[]}) Access(groups=[izisprod.prod_S_WardRef AS wr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null, EST_CARDINALITY=70.0, EST_COL_STATS={wr.Abbreviation=[-1.0, -1.0], wr.Address=[-1.0, -1.0], wr.ArchStatus=[-1.0, -1.0], wr.ArchTime=[-1.0, -1.0], ...}}) Source(groups=[izisprod.prod_S_WardRef AS wr], props={OUTPUT_COLS=null, EST_COL_STATS={wr.Abbreviation=[-1.0, -1.0], wr.Address=[-1.0, -1.0], wr.ArchStatus=[-1.0, -1.0], wr.ArchTime=[-1.0, -1.0], ...}, EST_CARDINALITY=70.0}) Select(groups=[iziswh.wh_P_GeneralData AS gd]) Access(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd]) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd]) Source(groups=[iziswh.wh_P_GeneralData AS gd]) Source(groups=[iziswh.wh_P_DischargeData AS dd]) Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS PatGroup, anon_grp1.gcol2 AS Abbreviation, anon_grp1.gcol3 AS AdmissionTime, anon_grp1.gcol4 AS DischargeTime, 'prod'], OUTPUT_COLS=null}) Group(groups=[anon_grp1, izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1], props={GROUP_COLS=[gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime], SYMBOL_MAP={anon_grp1.gcol0=gd__1.PatientID, anon_grp1.gcol1=gd__1.PatGroup, anon_grp1.gcol2=wr__1.Abbreviation, anon_grp1.gcol3=gd__1.AdmissionTime, anon_grp1.gcol4=dd__1.DischargeTime}, OUTPUT_COLS=null}) Select(groups=[izisprod.prod_P_GeneralData AS gd__1]) Access(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1]) Select(groups=[izisprod.prod_P_GeneralData AS gd__1]) Source(groups=[izisprod.prod_P_GeneralData AS gd__1]) Source(groups=[izisprod.prod_P_DischargeData AS dd__1]) Source(groups=[izisprod.prod_S_WardRef AS wr__1]) ============================================================================ EXECUTING ChooseDependent AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) SetOperation(groups=[]) Project(groups=[anon_grp0]) Group(groups=[iziswh.wh_P_DischargeData AS dd, iziswh.wh_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr, anon_grp0]) Join(groups=[izisprod.prod_S_WardRef AS wr, iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[wr.WardID = gd.WardID], LEFT_EXPRESSIONS=[wr.WardID], RIGHT_EXPRESSIONS=[gd.WardID], NON_EQUI_JOIN_CRITERIA=[], DEPENDENT_VALUE_SOURCE=$dsc/id743}) Access(groups=[izisprod.prod_S_WardRef AS wr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null, EST_CARDINALITY=70.0, EST_COL_STATS={wr.Abbreviation=[-1.0, -1.0], wr.Address=[-1.0, -1.0], wr.ArchStatus=[-1.0, -1.0], wr.ArchTime=[-1.0, -1.0], ...}}) Source(groups=[izisprod.prod_S_WardRef AS wr], props={OUTPUT_COLS=null, EST_COL_STATS={wr.Abbreviation=[-1.0, -1.0], wr.Address=[-1.0, -1.0], wr.ArchStatus=[-1.0, -1.0], wr.ArchTime=[-1.0, -1.0], ...}, EST_CARDINALITY=70.0}) Select(groups=[iziswh.wh_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.WardID IN (), IS_DEPENDENT_SET=true}) Select(groups=[iziswh.wh_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.PatientID IN (SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=15000.0, EST_COL_STATS={gd.Address=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], gd.AdmissionWard=[-1.0, -1.0], gd.BedID=[-1.0, -1.0], ...}}) Access(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=45000.0, EST_COL_STATS={gd.Address=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], gd.AdmissionWard=[-1.0, -1.0], gd.BedID=[-1.0, -1.0], ...}}) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd.PatientID = dd.PatientID], OUTPUT_COLS=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, IS_COPIED=true, EST_CARDINALITY=45000.0, EST_COL_STATS={gd.Address=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], gd.AdmissionWard=[-1.0, -1.0], gd.BedID=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_GeneralData AS gd], props={OUTPUT_COLS=null, EST_COL_STATS={gd.Address=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], gd.AdmissionWard=[-1.0, -1.0], gd.BedID=[-1.0, -1.0], ...}, EST_CARDINALITY=45000.0}) Source(groups=[iziswh.wh_P_DischargeData AS dd], props={OUTPUT_COLS=null, EST_COL_STATS={dd.ActorID=[-1.0, -1.0], dd.DischargeTime=[-1.0, -1.0], dd.DischargedTo=[-1.0, -1.0], dd.ICUDiagnosis=[-1.0, -1.0], ...}, EST_CARDINALITY=45000.0}) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Select(groups=[izisprod.prod_P_GeneralData AS gd__1]) Access(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1]) Select(groups=[izisprod.prod_P_GeneralData AS gd__1]) Source(groups=[izisprod.prod_P_GeneralData AS gd__1]) Source(groups=[izisprod.prod_P_DischargeData AS dd__1]) Source(groups=[izisprod.prod_S_WardRef AS wr__1]) ============================================================================ EXECUTING PushSelectCriteria AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) SetOperation(groups=[]) Project(groups=[anon_grp0]) Group(groups=[iziswh.wh_P_DischargeData AS dd, iziswh.wh_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr, anon_grp0]) Join(groups=[izisprod.prod_S_WardRef AS wr, iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[wr.WardID = gd.WardID], LEFT_EXPRESSIONS=[wr.WardID], RIGHT_EXPRESSIONS=[gd.WardID], NON_EQUI_JOIN_CRITERIA=[], DEPENDENT_VALUE_SOURCE=$dsc/id743}) Access(groups=[izisprod.prod_S_WardRef AS wr]) Source(groups=[izisprod.prod_S_WardRef AS wr]) Select(groups=[iziswh.wh_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.PatientID IN (SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=15000.0, EST_COL_STATS={gd.Address=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], gd.AdmissionWard=[-1.0, -1.0], gd.BedID=[-1.0, -1.0], ...}}) Access(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=45000.0, EST_COL_STATS={gd.Address=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], gd.AdmissionWard=[-1.0, -1.0], gd.BedID=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Select(groups=[iziswh.wh_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.WardID IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true}) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd.PatientID = dd.PatientID], OUTPUT_COLS=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, IS_COPIED=true, EST_CARDINALITY=45000.0, EST_COL_STATS={gd.Address=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], gd.AdmissionWard=[-1.0, -1.0], gd.BedID=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_GeneralData AS gd]) Source(groups=[iziswh.wh_P_DischargeData AS dd]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.PatientID IN (SELECT pr.PatientID FROM izisprod.prod_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID), OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1]) Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=(gd__1.Status >= 4) AND (gd__1.Status <> 5), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[izisprod.prod_P_GeneralData AS gd__1]) Source(groups=[izisprod.prod_P_DischargeData AS dd__1]) Source(groups=[izisprod.prod_S_WardRef AS wr__1]) ============================================================================ EXECUTING CleanCriteria AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=null}) Sort(groups=[anon_grp0], props={SORT_ORDER=ORDER BY admtime, OUTPUT_COLS=null, UNRELATED_SORT=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=null}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin], OUTPUT_COLS=null}) Group(groups=[iziswh.wh_P_DischargeData AS dd, iziswh.wh_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr, anon_grp0], props={GROUP_COLS=[gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime], SYMBOL_MAP={anon_grp0.gcol0=gd.PatientID, anon_grp0.gcol1=gd.PatGroup, anon_grp0.gcol2=wr.Abbreviation, anon_grp0.gcol3=gd.AdmissionTime, anon_grp0.gcol4=dd.DischargeTime}, OUTPUT_COLS=null}) Join(groups=[izisprod.prod_S_WardRef AS wr, iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[wr.WardID = gd.WardID], LEFT_EXPRESSIONS=[wr.WardID], RIGHT_EXPRESSIONS=[gd.WardID], NON_EQUI_JOIN_CRITERIA=[], DEPENDENT_VALUE_SOURCE=$dsc/id743, OUTPUT_COLS=null}) Access(groups=[izisprod.prod_S_WardRef AS wr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null, EST_CARDINALITY=70.0, EST_COL_STATS={wr.Abbreviation=[-1.0, -1.0], wr.Address=[-1.0, -1.0], wr.ArchStatus=[-1.0, -1.0], wr.ArchTime=[-1.0, -1.0], ...}}) Source(groups=[izisprod.prod_S_WardRef AS wr], props={OUTPUT_COLS=null, EST_COL_STATS={wr.Abbreviation=[-1.0, -1.0], wr.Address=[-1.0, -1.0], wr.ArchStatus=[-1.0, -1.0], wr.ArchTime=[-1.0, -1.0], ...}, EST_CARDINALITY=70.0}) Select(groups=[iziswh.wh_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.PatientID IN (SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=15000.0, EST_COL_STATS={gd.Address=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], gd.AdmissionWard=[-1.0, -1.0], gd.BedID=[-1.0, -1.0], ...}}) Access(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=45000.0, EST_COL_STATS={gd.Address=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], gd.AdmissionWard=[-1.0, -1.0], gd.BedID=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Select(groups=[iziswh.wh_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.WardID IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=null}) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd.PatientID = dd.PatientID], OUTPUT_COLS=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, IS_COPIED=true, EST_CARDINALITY=45000.0, EST_COL_STATS={gd.Address=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], gd.AdmissionWard=[-1.0, -1.0], gd.BedID=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_GeneralData AS gd], props={OUTPUT_COLS=null, EST_COL_STATS={gd.Address=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], gd.AdmissionWard=[-1.0, -1.0], gd.BedID=[-1.0, -1.0], ...}, EST_CARDINALITY=45000.0}) Source(groups=[iziswh.wh_P_DischargeData AS dd], props={OUTPUT_COLS=null, EST_COL_STATS={dd.ActorID=[-1.0, -1.0], dd.DischargeTime=[-1.0, -1.0], dd.DischargedTo=[-1.0, -1.0], dd.ICUDiagnosis=[-1.0, -1.0], ...}, EST_CARDINALITY=45000.0}) Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS PatGroup, anon_grp1.gcol2 AS Abbreviation, anon_grp1.gcol3 AS AdmissionTime, anon_grp1.gcol4 AS DischargeTime, 'prod'], OUTPUT_COLS=null}) Group(groups=[anon_grp1, izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1], props={GROUP_COLS=[gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime], SYMBOL_MAP={anon_grp1.gcol0=gd__1.PatientID, anon_grp1.gcol1=gd__1.PatGroup, anon_grp1.gcol2=wr__1.Abbreviation, anon_grp1.gcol3=gd__1.AdmissionTime, anon_grp1.gcol4=dd__1.DischargeTime}, OUTPUT_COLS=null}) Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.PatientID IN (SELECT pr.PatientID FROM izisprod.prod_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID), OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null, CONFORMED_SOURCES=null}) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[wr__1.WardID = gd__1.WardID], OUTPUT_COLS=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, IS_COPIED=true}) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd__1.PatientID = dd__1.PatientID], OUTPUT_COLS=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, IS_COPIED=true}) Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=(gd__1.Status >= 4) AND (gd__1.Status <> 5), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[izisprod.prod_P_GeneralData AS gd__1], props={OUTPUT_COLS=null}) Source(groups=[izisprod.prod_P_DischargeData AS dd__1], props={OUTPUT_COLS=null}) Source(groups=[izisprod.prod_S_WardRef AS wr__1], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING PushLimit AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=null}) Sort(groups=[anon_grp0], props={SORT_ORDER=ORDER BY admtime, OUTPUT_COLS=null, UNRELATED_SORT=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=null}) TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100}) Sort(groups=[], props={SORT_ORDER=ORDER BY admtime}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin], OUTPUT_COLS=null}) Group(groups=[iziswh.wh_P_DischargeData AS dd, iziswh.wh_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr, anon_grp0]) Join(groups=[izisprod.prod_S_WardRef AS wr, iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd]) Access(groups=[izisprod.prod_S_WardRef AS wr]) Source(groups=[izisprod.prod_S_WardRef AS wr]) Select(groups=[iziswh.wh_P_GeneralData AS gd]) Access(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd]) Select(groups=[iziswh.wh_P_GeneralData AS gd]) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd]) Source(groups=[iziswh.wh_P_GeneralData AS gd]) Source(groups=[iziswh.wh_P_DischargeData AS dd]) TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100}) Sort(groups=[], props={SORT_ORDER=ORDER BY AdmissionTime}) Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS PatGroup, anon_grp1.gcol2 AS Abbreviation, anon_grp1.gcol3 AS AdmissionTime, anon_grp1.gcol4 AS DischargeTime, 'prod'], OUTPUT_COLS=null}) Group(groups=[anon_grp1, izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Select(groups=[izisprod.prod_P_GeneralData AS gd__1]) Access(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1]) Select(groups=[izisprod.prod_P_GeneralData AS gd__1]) Source(groups=[izisprod.prod_P_GeneralData AS gd__1]) Source(groups=[izisprod.prod_P_DischargeData AS dd__1]) Source(groups=[izisprod.prod_S_WardRef AS wr__1]) ============================================================================ EXECUTING AssignOutputElements AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin]}) Sort(groups=[anon_grp0], props={SORT_ORDER=ORDER BY admtime, OUTPUT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin], UNRELATED_SORT=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin]}) TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin]}) Sort(groups=[], props={SORT_ORDER=ORDER BY admtime, OUTPUT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin], UNRELATED_SORT=false}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin], OUTPUT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin]}) Group(groups=[iziswh.wh_P_DischargeData AS dd, iziswh.wh_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr, anon_grp0], props={GROUP_COLS=[gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime], SYMBOL_MAP={anon_grp0.gcol0=gd.PatientID, anon_grp0.gcol1=gd.PatGroup, anon_grp0.gcol2=wr.Abbreviation, anon_grp0.gcol3=gd.AdmissionTime, anon_grp0.gcol4=dd.DischargeTime}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.gcol2, anon_grp0.gcol3, anon_grp0.gcol4]}) Join(groups=[izisprod.prod_S_WardRef AS wr, iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[wr.WardID = gd.WardID], LEFT_EXPRESSIONS=[wr.WardID], RIGHT_EXPRESSIONS=[gd.WardID], NON_EQUI_JOIN_CRITERIA=[], DEPENDENT_VALUE_SOURCE=$dsc/id743, OUTPUT_COLS=[gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime]}) Access(groups=[izisprod.prod_S_WardRef AS wr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[wr.WardID, wr.Abbreviation], EST_CARDINALITY=70.0, EST_COL_STATS={wr.Abbreviation=[-1.0, -1.0], wr.Address=[-1.0, -1.0], wr.ArchStatus=[-1.0, -1.0], wr.ArchTime=[-1.0, -1.0], ...}}) Source(groups=[izisprod.prod_S_WardRef AS wr], props={OUTPUT_COLS=[wr.WardID, wr.Abbreviation], EST_COL_STATS={wr.Abbreviation=[-1.0, -1.0], wr.Address=[-1.0, -1.0], wr.ArchStatus=[-1.0, -1.0], wr.ArchTime=[-1.0, -1.0], ...}, EST_CARDINALITY=70.0}) Select(groups=[iziswh.wh_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.PatientID IN (SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID), OUTPUT_COLS=[gd.WardID, gd.PatientID, gd.PatGroup, gd.AdmissionTime, dd.DischargeTime], IS_COPIED=true, EST_CARDINALITY=15000.0, EST_COL_STATS={gd.Address=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], gd.AdmissionWard=[-1.0, -1.0], gd.BedID=[-1.0, -1.0], ...}}) Access(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[gd.PatientID, gd.WardID, gd.PatGroup, gd.AdmissionTime, dd.DischargeTime], CONFORMED_SOURCES=null, EST_CARDINALITY=45000.0, EST_COL_STATS={gd.Address=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], gd.AdmissionWard=[-1.0, -1.0], gd.BedID=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Select(groups=[iziswh.wh_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.WardID IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[gd.PatientID, gd.WardID, gd.PatGroup, gd.AdmissionTime, dd.DischargeTime]}) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd.PatientID = dd.PatientID], OUTPUT_COLS=[gd.WardID, gd.PatientID, gd.PatGroup, gd.AdmissionTime, dd.DischargeTime], MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, IS_COPIED=true, EST_CARDINALITY=45000.0, EST_COL_STATS={gd.Address=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], gd.AdmissionWard=[-1.0, -1.0], gd.BedID=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_GeneralData AS gd], props={OUTPUT_COLS=[gd.PatientID, gd.WardID, gd.PatGroup, gd.AdmissionTime], EST_COL_STATS={gd.Address=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], gd.AdmissionWard=[-1.0, -1.0], gd.BedID=[-1.0, -1.0], ...}, EST_CARDINALITY=45000.0}) Source(groups=[iziswh.wh_P_DischargeData AS dd], props={OUTPUT_COLS=[dd.PatientID, dd.DischargeTime], EST_COL_STATS={dd.ActorID=[-1.0, -1.0], dd.DischargeTime=[-1.0, -1.0], dd.DischargedTo=[-1.0, -1.0], dd.ICUDiagnosis=[-1.0, -1.0], ...}, EST_CARDINALITY=45000.0}) TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS PatGroup, anon_grp1.gcol2 AS Abbreviation, anon_grp1.gcol3 AS AdmissionTime, anon_grp1.gcol4 AS DischargeTime, 'prod']}) Sort(groups=[], props={SORT_ORDER=ORDER BY AdmissionTime, OUTPUT_COLS=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS PatGroup, anon_grp1.gcol2 AS Abbreviation, anon_grp1.gcol3 AS AdmissionTime, anon_grp1.gcol4 AS DischargeTime, 'prod'], UNRELATED_SORT=false}) Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS PatGroup, anon_grp1.gcol2 AS Abbreviation, anon_grp1.gcol3 AS AdmissionTime, anon_grp1.gcol4 AS DischargeTime, 'prod'], OUTPUT_COLS=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS PatGroup, anon_grp1.gcol2 AS Abbreviation, anon_grp1.gcol3 AS AdmissionTime, anon_grp1.gcol4 AS DischargeTime, 'prod']}) Group(groups=[anon_grp1, izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1], props={GROUP_COLS=[gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime], SYMBOL_MAP={anon_grp1.gcol0=gd__1.PatientID, anon_grp1.gcol1=gd__1.PatGroup, anon_grp1.gcol2=wr__1.Abbreviation, anon_grp1.gcol3=gd__1.AdmissionTime, anon_grp1.gcol4=dd__1.DischargeTime}, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3, anon_grp1.gcol4]}) Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.PatientID IN (SELECT pr.PatientID FROM izisprod.prod_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID), OUTPUT_COLS=[gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime], IS_COPIED=true}) Access(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__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.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime], CONFORMED_SOURCES=null}) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[wr__1.WardID = gd__1.WardID], OUTPUT_COLS=[gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime], MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, IS_COPIED=true}) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd__1.PatientID = dd__1.PatientID], OUTPUT_COLS=[gd__1.WardID, gd__1.PatientID, gd__1.PatGroup, gd__1.AdmissionTime, dd__1.DischargeTime], MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, IS_COPIED=true}) Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=(gd__1.Status >= 4) AND (gd__1.Status <> 5), OUTPUT_COLS=[gd__1.PatientID, gd__1.WardID, gd__1.PatGroup, gd__1.AdmissionTime], IS_COPIED=true}) Source(groups=[izisprod.prod_P_GeneralData AS gd__1], props={OUTPUT_COLS=[gd__1.Status, gd__1.PatientID, gd__1.WardID, gd__1.PatGroup, gd__1.AdmissionTime]}) Source(groups=[izisprod.prod_P_DischargeData AS dd__1], props={OUTPUT_COLS=[dd__1.PatientID, dd__1.DischargeTime]}) Source(groups=[izisprod.prod_S_WardRef AS wr__1], props={OUTPUT_COLS=[wr__1.WardID, wr__1.Abbreviation]}) ============================================================================ EXECUTING CalculateCost AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin], EST_CARDINALITY=100.0, EST_COL_STATS={anon_grp0.gcol0 AS admissionid=[28.74016, -1.0], anon_grp0.gcol1 AS patgroup=[28.74016, -1.0], anon_grp0.gcol2 AS ward=[28.74016, -1.0], anon_grp0.gcol3 AS admtime=[28.74016, -1.0], ...}}) Sort(groups=[anon_grp0], props={SORT_ORDER=ORDER BY admtime, OUTPUT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin], UNRELATED_SORT=false, EST_CARDINALITY=138.04347, EST_COL_STATS={anon_grp0.gcol0 AS admissionid=[39.673916, -1.0], anon_grp0.gcol1 AS patgroup=[39.673916, -1.0], anon_grp0.gcol2 AS ward=[39.673916, -1.0], anon_grp0.gcol3 AS admtime=[39.673916, -1.0], ...}}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin], EST_CARDINALITY=138.04347, EST_COL_STATS={anon_grp0.gcol0 AS admissionid=[39.673916, -1.0], anon_grp0.gcol1 AS patgroup=[39.673916, -1.0], anon_grp0.gcol2 AS ward=[39.673916, -1.0], anon_grp0.gcol3 AS admtime=[39.673916, -1.0], ...}}) TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin], EST_CARDINALITY=100.0, EST_COL_STATS={anon_grp0.gcol0 AS admissionid=[33.333336, -1.0], anon_grp0.gcol1 AS patgroup=[33.333336, -1.0], anon_grp0.gcol2 AS ward=[33.333336, -1.0], anon_grp0.gcol3 AS admtime=[33.333336, -1.0], ...}}) Sort(groups=[], props={SORT_ORDER=ORDER BY admtime, OUTPUT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin], UNRELATED_SORT=false, EST_CARDINALITY=414.3039, EST_COL_STATS={anon_grp0.gcol0 AS admissionid=[138.1013, -1.0], anon_grp0.gcol1 AS patgroup=[138.1013, -1.0], anon_grp0.gcol2 AS ward=[138.1013, -1.0], anon_grp0.gcol3 AS admtime=[138.1013, -1.0], ...}}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin], OUTPUT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin], EST_CARDINALITY=414.3039, EST_COL_STATS={anon_grp0.gcol0 AS admissionid=[138.1013, -1.0], anon_grp0.gcol1 AS patgroup=[138.1013, -1.0], anon_grp0.gcol2 AS ward=[138.1013, -1.0], anon_grp0.gcol3 AS admtime=[138.1013, -1.0], ...}}) Group(groups=[iziswh.wh_P_DischargeData AS dd, iziswh.wh_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr, anon_grp0], props={GROUP_COLS=[gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime], SYMBOL_MAP={anon_grp0.gcol0=gd.PatientID, anon_grp0.gcol1=gd.PatGroup, anon_grp0.gcol2=wr.Abbreviation, anon_grp0.gcol3=gd.AdmissionTime, anon_grp0.gcol4=dd.DischargeTime}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.gcol2, anon_grp0.gcol3, anon_grp0.gcol4], EST_CARDINALITY=414.3039, EST_COL_STATS={anon_grp0.gcol0=[138.1013, -1.0], anon_grp0.gcol1=[138.1013, -1.0], anon_grp0.gcol2=[138.1013, -1.0], anon_grp0.gcol3=[138.1013, -1.0], ...}}) Join(groups=[izisprod.prod_S_WardRef AS wr, iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[wr.WardID = gd.WardID], LEFT_EXPRESSIONS=[wr.WardID], RIGHT_EXPRESSIONS=[gd.WardID], NON_EQUI_JOIN_CRITERIA=[], DEPENDENT_VALUE_SOURCE=$dsc/id743, OUTPUT_COLS=[gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime], EST_CARDINALITY=828.6078, EST_COL_STATS={gd.PatientID=[-1.0, -1.0], gd.PatGroup=[-1.0, -1.0], wr.Abbreviation=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], ...}}) Access(groups=[izisprod.prod_S_WardRef AS wr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[wr.WardID, wr.Abbreviation], EST_CARDINALITY=70.0, EST_COL_STATS={wr.Abbreviation=[-1.0, -1.0], wr.Address=[-1.0, -1.0], wr.ArchStatus=[-1.0, -1.0], wr.ArchTime=[-1.0, -1.0], ...}}) Source(groups=[izisprod.prod_S_WardRef AS wr], props={OUTPUT_COLS=[wr.WardID, wr.Abbreviation], EST_COL_STATS={wr.Abbreviation=[-1.0, -1.0], wr.Address=[-1.0, -1.0], wr.ArchStatus=[-1.0, -1.0], wr.ArchTime=[-1.0, -1.0], ...}, EST_CARDINALITY=70.0}) Select(groups=[iziswh.wh_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.PatientID IN (SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID), OUTPUT_COLS=[gd.WardID, gd.PatientID, gd.PatGroup, gd.AdmissionTime, dd.DischargeTime], IS_COPIED=true, EST_CARDINALITY=9813.084, EST_COL_STATS={gd.WardID=[-1.0, -1.0], gd.PatientID=[-1.0, -1.0], gd.PatGroup=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], ...}}) Access(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[gd.PatientID, gd.WardID, gd.PatGroup, gd.AdmissionTime, dd.DischargeTime], CONFORMED_SOURCES=null, EST_CARDINALITY=29439.252, EST_COL_STATS={gd.PatientID=[-1.0, -1.0], gd.WardID=[-1.0, -1.0], gd.PatGroup=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Select(groups=[iziswh.wh_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.WardID IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[gd.PatientID, gd.WardID, gd.PatGroup, gd.AdmissionTime, dd.DischargeTime], EST_CARDINALITY=29439.252, EST_COL_STATS={gd.PatientID=[-1.0, -1.0], gd.WardID=[-1.0, -1.0], gd.PatGroup=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], ...}}) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd.PatientID = dd.PatientID], OUTPUT_COLS=[gd.WardID, gd.PatientID, gd.PatGroup, gd.AdmissionTime, dd.DischargeTime], MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, IS_COPIED=true, EST_CARDINALITY=45000.0, EST_COL_STATS={gd.Address=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], gd.AdmissionWard=[-1.0, -1.0], gd.BedID=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_GeneralData AS gd], props={OUTPUT_COLS=[gd.PatientID, gd.WardID, gd.PatGroup, gd.AdmissionTime], EST_COL_STATS={gd.Address=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], gd.AdmissionWard=[-1.0, -1.0], gd.BedID=[-1.0, -1.0], ...}, EST_CARDINALITY=45000.0}) Source(groups=[iziswh.wh_P_DischargeData AS dd], props={OUTPUT_COLS=[dd.PatientID, dd.DischargeTime], EST_COL_STATS={dd.ActorID=[-1.0, -1.0], dd.DischargeTime=[-1.0, -1.0], dd.DischargedTo=[-1.0, -1.0], dd.ICUDiagnosis=[-1.0, -1.0], ...}, EST_CARDINALITY=45000.0}) TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS PatGroup, anon_grp1.gcol2 AS Abbreviation, anon_grp1.gcol3 AS AdmissionTime, anon_grp1.gcol4 AS DischargeTime, 'prod'], EST_CARDINALITY=38.043476, EST_COL_STATS={anon_grp1.gcol0 AS PatientID=[12.681159, -1.0], anon_grp1.gcol1 AS PatGroup=[12.681159, -1.0], anon_grp1.gcol2 AS Abbreviation=[12.681159, -1.0], anon_grp1.gcol3 AS AdmissionTime=[12.681159, -1.0], ...}}) Sort(groups=[], props={SORT_ORDER=ORDER BY AdmissionTime, OUTPUT_COLS=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS PatGroup, anon_grp1.gcol2 AS Abbreviation, anon_grp1.gcol3 AS AdmissionTime, anon_grp1.gcol4 AS DischargeTime, 'prod'], UNRELATED_SORT=false, EST_CARDINALITY=38.043476, EST_COL_STATS={anon_grp1.gcol0 AS PatientID=[12.681159, -1.0], anon_grp1.gcol1 AS PatGroup=[12.681159, -1.0], anon_grp1.gcol2 AS Abbreviation=[12.681159, -1.0], anon_grp1.gcol3 AS AdmissionTime=[12.681159, -1.0], ...}}) Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS PatGroup, anon_grp1.gcol2 AS Abbreviation, anon_grp1.gcol3 AS AdmissionTime, anon_grp1.gcol4 AS DischargeTime, 'prod'], OUTPUT_COLS=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS PatGroup, anon_grp1.gcol2 AS Abbreviation, anon_grp1.gcol3 AS AdmissionTime, anon_grp1.gcol4 AS DischargeTime, 'prod'], EST_CARDINALITY=38.043476, EST_COL_STATS={anon_grp1.gcol0 AS PatientID=[12.681159, -1.0], anon_grp1.gcol1 AS PatGroup=[12.681159, -1.0], anon_grp1.gcol2 AS Abbreviation=[12.681159, -1.0], anon_grp1.gcol3 AS AdmissionTime=[12.681159, -1.0], ...}}) Group(groups=[anon_grp1, izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1], props={GROUP_COLS=[gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime], SYMBOL_MAP={anon_grp1.gcol0=gd__1.PatientID, anon_grp1.gcol1=gd__1.PatGroup, anon_grp1.gcol2=wr__1.Abbreviation, anon_grp1.gcol3=gd__1.AdmissionTime, anon_grp1.gcol4=dd__1.DischargeTime}, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3, anon_grp1.gcol4], EST_CARDINALITY=38.043476, EST_COL_STATS={anon_grp1.gcol0=[12.681159, -1.0], anon_grp1.gcol1=[12.681159, -1.0], anon_grp1.gcol2=[12.681159, -1.0], anon_grp1.gcol3=[12.681159, -1.0], ...}}) Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.PatientID IN (SELECT pr.PatientID FROM izisprod.prod_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID), OUTPUT_COLS=[gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime], IS_COPIED=true, EST_CARDINALITY=76.08695, EST_COL_STATS={gd__1.PatientID=[-1.0, -1.0], gd__1.PatGroup=[-1.0, -1.0], wr__1.Abbreviation=[-1.0, -1.0], gd__1.AdmissionTime=[-1.0, -1.0], ...}}) Access(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__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.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime], CONFORMED_SOURCES=null, EST_CARDINALITY=228.26085, EST_COL_STATS={gd__1.PatientID=[-1.0, -1.0], gd__1.PatGroup=[-1.0, -1.0], wr__1.Abbreviation=[-1.0, -1.0], gd__1.AdmissionTime=[-1.0, -1.0], ...}}) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[wr__1.WardID = gd__1.WardID], OUTPUT_COLS=[gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime], MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, IS_COPIED=true, EST_CARDINALITY=228.26085, EST_COL_STATS={gd__1.PatientID=[-1.0, -1.0], gd__1.PatGroup=[-1.0, -1.0], wr__1.Abbreviation=[-1.0, -1.0], gd__1.AdmissionTime=[-1.0, -1.0], ...}}) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd__1.PatientID = dd__1.PatientID], OUTPUT_COLS=[gd__1.WardID, gd__1.PatientID, gd__1.PatGroup, gd__1.AdmissionTime, dd__1.DischargeTime], MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, IS_COPIED=true, EST_CARDINALITY=749.99994, EST_COL_STATS={gd__1.WardID=[-1.0, -1.0], gd__1.PatientID=[-1.0, -1.0], gd__1.PatGroup=[-1.0, -1.0], gd__1.AdmissionTime=[-1.0, -1.0], ...}}) Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=(gd__1.Status >= 4) AND (gd__1.Status <> 5), OUTPUT_COLS=[gd__1.PatientID, gd__1.WardID, gd__1.PatGroup, gd__1.AdmissionTime], IS_COPIED=true, EST_CARDINALITY=119.99999, EST_COL_STATS={gd__1.PatientID=[-1.0, -1.0], gd__1.WardID=[-1.0, -1.0], gd__1.PatGroup=[-1.0, -1.0], gd__1.AdmissionTime=[-1.0, -1.0]}}) Source(groups=[izisprod.prod_P_GeneralData AS gd__1], props={OUTPUT_COLS=[gd__1.Status, gd__1.PatientID, gd__1.WardID, gd__1.PatGroup, gd__1.AdmissionTime], EST_COL_STATS={gd__1.Status=[-1.0, -1.0], gd__1.PatientID=[-1.0, -1.0], gd__1.WardID=[-1.0, -1.0], gd__1.PatGroup=[-1.0, -1.0], ...}, EST_CARDINALITY=400.0}) Source(groups=[izisprod.prod_P_DischargeData AS dd__1], props={OUTPUT_COLS=[dd__1.PatientID, dd__1.DischargeTime], EST_COL_STATS={dd__1.PatientID=[-1.0, -1.0], dd__1.DischargeTime=[-1.0, -1.0]}, EST_CARDINALITY=300.0}) Source(groups=[izisprod.prod_S_WardRef AS wr__1], props={OUTPUT_COLS=[wr__1.WardID, wr__1.Abbreviation], EST_COL_STATS={wr__1.WardID=[-1.0, -1.0], wr__1.Abbreviation=[-1.0, -1.0]}, EST_CARDINALITY=70.0}) ============================================================================ EXECUTING ImplementJoinStrategy AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) SetOperation(groups=[]) TupleLimit(groups=[]) Sort(groups=[]) Project(groups=[anon_grp0]) Group(groups=[iziswh.wh_P_DischargeData AS dd, iziswh.wh_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr, anon_grp0]) Join(groups=[izisprod.prod_S_WardRef AS wr, iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[wr.WardID = gd.WardID], LEFT_EXPRESSIONS=[wr.WardID], RIGHT_EXPRESSIONS=[gd.WardID], NON_EQUI_JOIN_CRITERIA=[], DEPENDENT_VALUE_SOURCE=$dsc/id743, OUTPUT_COLS=[gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime], EST_CARDINALITY=828.6078, EST_COL_STATS={gd.PatientID=[-1.0, -1.0], gd.PatGroup=[-1.0, -1.0], wr.Abbreviation=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], ...}, IS_LEFT_DISTINCT=true, SORT_RIGHT=SORT}) Access(groups=[izisprod.prod_S_WardRef AS wr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[wr.WardID, wr.Abbreviation], EST_CARDINALITY=70.0, EST_COL_STATS={wr.Abbreviation=[-1.0, -1.0], wr.Address=[-1.0, -1.0], wr.ArchStatus=[-1.0, -1.0], wr.ArchTime=[-1.0, -1.0], ...}}) Sort(groups=[], props={SORT_ORDER=ORDER BY wr.WardID, OUTPUT_COLS=[wr.WardID, wr.Abbreviation]}) Source(groups=[izisprod.prod_S_WardRef AS wr], props={OUTPUT_COLS=[wr.WardID, wr.Abbreviation], EST_COL_STATS={wr.Abbreviation=[-1.0, -1.0], wr.Address=[-1.0, -1.0], wr.ArchStatus=[-1.0, -1.0], wr.ArchTime=[-1.0, -1.0], ...}, EST_CARDINALITY=70.0}) Select(groups=[iziswh.wh_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.PatientID IN (SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID), OUTPUT_COLS=[gd.WardID, gd.PatientID, gd.PatGroup, gd.AdmissionTime, dd.DischargeTime], IS_COPIED=true, EST_CARDINALITY=9813.084, EST_COL_STATS={gd.WardID=[-1.0, -1.0], gd.PatientID=[-1.0, -1.0], gd.PatGroup=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], ...}}) Access(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[gd.PatientID, gd.WardID, gd.PatGroup, gd.AdmissionTime, dd.DischargeTime], CONFORMED_SOURCES=null, EST_CARDINALITY=29439.252, EST_COL_STATS={gd.PatientID=[-1.0, -1.0], gd.WardID=[-1.0, -1.0], gd.PatGroup=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Select(groups=[iziswh.wh_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.WardID IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[gd.PatientID, gd.WardID, gd.PatGroup, gd.AdmissionTime, dd.DischargeTime], EST_CARDINALITY=29439.252, EST_COL_STATS={gd.PatientID=[-1.0, -1.0], gd.WardID=[-1.0, -1.0], gd.PatGroup=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], ...}}) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd.PatientID = dd.PatientID], OUTPUT_COLS=[gd.WardID, gd.PatientID, gd.PatGroup, gd.AdmissionTime, dd.DischargeTime], MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, IS_COPIED=true, EST_CARDINALITY=45000.0, EST_COL_STATS={gd.Address=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], gd.AdmissionWard=[-1.0, -1.0], gd.BedID=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_GeneralData AS gd], props={OUTPUT_COLS=[gd.PatientID, gd.WardID, gd.PatGroup, gd.AdmissionTime], EST_COL_STATS={gd.Address=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], gd.AdmissionWard=[-1.0, -1.0], gd.BedID=[-1.0, -1.0], ...}, EST_CARDINALITY=45000.0}) Source(groups=[iziswh.wh_P_DischargeData AS dd], props={OUTPUT_COLS=[dd.PatientID, dd.DischargeTime], EST_COL_STATS={dd.ActorID=[-1.0, -1.0], dd.DischargeTime=[-1.0, -1.0], dd.DischargedTo=[-1.0, -1.0], dd.ICUDiagnosis=[-1.0, -1.0], ...}, EST_CARDINALITY=45000.0}) TupleLimit(groups=[]) Sort(groups=[]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Select(groups=[izisprod.prod_P_GeneralData AS gd__1]) Access(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1]) Select(groups=[izisprod.prod_P_GeneralData AS gd__1]) Source(groups=[izisprod.prod_P_GeneralData AS gd__1]) Source(groups=[izisprod.prod_P_DischargeData AS dd__1]) Source(groups=[izisprod.prod_S_WardRef AS wr__1]) ============================================================================ EXECUTING MergeCriteria ---------------------------------------------------------------------------- OPTIMIZE: SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID ORDER BY pr.PatientID ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID ORDER BY pr.PatientID CANONICAL PLAN: Sort(groups=[anon_grp12], props={SORT_ORDER=ORDER BY PatientID}) Project(groups=[anon_grp12], props={PROJECT_COLS=[anon_grp12.gcol0 AS PatientID]}) Group(groups=[iziswh.wh_P_PharmaRec AS pr, anon_grp12], props={GROUP_COLS=[pr.PatientID], SYMBOL_MAP={anon_grp12.gcol0=pr.PatientID}}) Select(groups=[iziswh.wh_P_PharmaRec AS pr], props={SELECT_CRITERIA=bitand(convert(pr.Status, integer), 2) <> 2}) Select(groups=[iziswh.wh_P_PharmaRec AS pr], props={SELECT_CRITERIA=pr.PharmaID = 1002463}) Source(groups=[iziswh.wh_P_PharmaRec AS pr]) ============================================================================ EXECUTING PlaceAccess AFTER: Sort(groups=[anon_grp12], props={SORT_ORDER=ORDER BY PatientID}) Project(groups=[anon_grp12], props={PROJECT_COLS=[anon_grp12.gcol0 AS PatientID]}) Group(groups=[anon_grp12, iziswh.wh_P_PharmaRec AS pr__2], props={GROUP_COLS=[pr__2.PatientID], SYMBOL_MAP={anon_grp12.gcol0=pr__2.PatientID}}) Select(groups=[iziswh.wh_P_PharmaRec AS pr__2], props={SELECT_CRITERIA=bitand(convert(pr__2.Status, integer), 2) <> 2}) Select(groups=[iziswh.wh_P_PharmaRec AS pr__2], props={SELECT_CRITERIA=pr__2.PharmaID = 1002463}) Access(groups=[iziswh.wh_P_PharmaRec AS pr__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac}) Source(groups=[iziswh.wh_P_PharmaRec AS pr__2]) ============================================================================ EXECUTING PushSelectCriteria AFTER: Sort(groups=[anon_grp12]) Project(groups=[anon_grp12]) Group(groups=[anon_grp12, iziswh.wh_P_PharmaRec AS pr__2], props={GROUP_COLS=[pr__2.PatientID], SYMBOL_MAP={anon_grp12.gcol0=pr__2.PatientID}}) Select(groups=[iziswh.wh_P_PharmaRec AS pr__2], props={SELECT_CRITERIA=bitand(convert(pr__2.Status, integer), 2) <> 2}) Access(groups=[iziswh.wh_P_PharmaRec AS pr__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac}) Select(groups=[iziswh.wh_P_PharmaRec AS pr__2], props={SELECT_CRITERIA=pr__2.PharmaID = 1002463}) Source(groups=[iziswh.wh_P_PharmaRec AS pr__2]) ============================================================================ EXECUTING CleanCriteria AFTER: Sort(groups=[anon_grp12], props={SORT_ORDER=ORDER BY PatientID, OUTPUT_COLS=null}) Project(groups=[anon_grp12], props={PROJECT_COLS=[anon_grp12.gcol0 AS PatientID], OUTPUT_COLS=null}) Group(groups=[anon_grp12, iziswh.wh_P_PharmaRec AS pr__2], props={GROUP_COLS=[pr__2.PatientID], SYMBOL_MAP={anon_grp12.gcol0=pr__2.PatientID}, OUTPUT_COLS=null}) Select(groups=[iziswh.wh_P_PharmaRec AS pr__2], props={SELECT_CRITERIA=bitand(convert(pr__2.Status, integer), 2) <> 2, OUTPUT_COLS=null}) Access(groups=[iziswh.wh_P_PharmaRec AS pr__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null}) Select(groups=[iziswh.wh_P_PharmaRec AS pr__2], props={SELECT_CRITERIA=pr__2.PharmaID = 1002463, OUTPUT_COLS=null}) Source(groups=[iziswh.wh_P_PharmaRec AS pr__2], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING RaiseAccess LOW Relational Planner bitand function not supported by source iziswh - bitand(convert(pr__2.Status, integer), 2) was not pushed AFTER: Sort(groups=[anon_grp12]) Project(groups=[anon_grp12]) Group(groups=[anon_grp12, iziswh.wh_P_PharmaRec AS pr__2]) Select(groups=[iziswh.wh_P_PharmaRec AS pr__2], props={SELECT_CRITERIA=bitand(convert(pr__2.Status, integer), 2) <> 2, OUTPUT_COLS=null}) Access(groups=[iziswh.wh_P_PharmaRec AS pr__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null}) Select(groups=[iziswh.wh_P_PharmaRec AS pr__2]) Source(groups=[iziswh.wh_P_PharmaRec AS pr__2]) ============================================================================ EXECUTING PushAggregates AFTER: Sort(groups=[anon_grp12]) Project(groups=[anon_grp12], props={PROJECT_COLS=[anon_grp12.gcol0 AS PatientID], OUTPUT_COLS=null}) Group(groups=[anon_grp12, iziswh.wh_P_PharmaRec AS pr__2], props={GROUP_COLS=[pr__2.PatientID], SYMBOL_MAP={anon_grp12.gcol0=pr__2.PatientID}, OUTPUT_COLS=null}) Select(groups=[iziswh.wh_P_PharmaRec AS pr__2]) Access(groups=[iziswh.wh_P_PharmaRec AS pr__2]) Select(groups=[iziswh.wh_P_PharmaRec AS pr__2]) Source(groups=[iziswh.wh_P_PharmaRec AS pr__2]) ============================================================================ EXECUTING AssignOutputElements AFTER: Sort(groups=[anon_grp12], props={SORT_ORDER=ORDER BY PatientID, OUTPUT_COLS=[anon_grp12.gcol0 AS PatientID], UNRELATED_SORT=false}) Project(groups=[anon_grp12], props={PROJECT_COLS=[anon_grp12.gcol0 AS PatientID], OUTPUT_COLS=[anon_grp12.gcol0 AS PatientID]}) Group(groups=[anon_grp12, iziswh.wh_P_PharmaRec AS pr__2], props={GROUP_COLS=[pr__2.PatientID], SYMBOL_MAP={anon_grp12.gcol0=pr__2.PatientID}, OUTPUT_COLS=[anon_grp12.gcol0]}) Select(groups=[iziswh.wh_P_PharmaRec AS pr__2], props={SELECT_CRITERIA=bitand(convert(pr__2.Status, integer), 2) <> 2, OUTPUT_COLS=[pr__2.PatientID]}) Access(groups=[iziswh.wh_P_PharmaRec AS pr__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[pr__2.Status, pr__2.PatientID]}) Select(groups=[iziswh.wh_P_PharmaRec AS pr__2], props={SELECT_CRITERIA=pr__2.PharmaID = 1002463, OUTPUT_COLS=[pr__2.Status, pr__2.PatientID]}) Source(groups=[iziswh.wh_P_PharmaRec AS pr__2], props={OUTPUT_COLS=[pr__2.PharmaID, pr__2.Status, pr__2.PatientID]}) ============================================================================ EXECUTING CalculateCost AFTER: Sort(groups=[anon_grp12], props={SORT_ORDER=ORDER BY PatientID, OUTPUT_COLS=[anon_grp12.gcol0 AS PatientID], UNRELATED_SORT=false, EST_CARDINALITY=7292.85, EST_COL_STATS={anon_grp12.gcol0 AS PatientID=[2430.95, -1.0]}}) Project(groups=[anon_grp12], props={PROJECT_COLS=[anon_grp12.gcol0 AS PatientID], OUTPUT_COLS=[anon_grp12.gcol0 AS PatientID], EST_CARDINALITY=7292.85, EST_COL_STATS={anon_grp12.gcol0 AS PatientID=[2430.95, -1.0]}}) Group(groups=[anon_grp12, iziswh.wh_P_PharmaRec AS pr__2], props={GROUP_COLS=[pr__2.PatientID], SYMBOL_MAP={anon_grp12.gcol0=pr__2.PatientID}, OUTPUT_COLS=[anon_grp12.gcol0], EST_CARDINALITY=7292.85, EST_COL_STATS={anon_grp12.gcol0=[2430.95, -1.0]}}) Select(groups=[iziswh.wh_P_PharmaRec AS pr__2], props={SELECT_CRITERIA=bitand(convert(pr__2.Status, integer), 2) <> 2, OUTPUT_COLS=[pr__2.PatientID], EST_CARDINALITY=14585.7, EST_COL_STATS={pr__2.PatientID=[-1.0, -1.0]}}) Access(groups=[iziswh.wh_P_PharmaRec AS pr__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[pr__2.Status, pr__2.PatientID], EST_CARDINALITY=14828.795, EST_COL_STATS={pr__2.Status=[-1.0, -1.0], pr__2.PatientID=[-1.0, -1.0]}}) Select(groups=[iziswh.wh_P_PharmaRec AS pr__2], props={SELECT_CRITERIA=pr__2.PharmaID = 1002463, OUTPUT_COLS=[pr__2.Status, pr__2.PatientID], EST_CARDINALITY=14828.795, EST_COL_STATS={pr__2.Status=[-1.0, -1.0], pr__2.PatientID=[-1.0, -1.0]}}) Source(groups=[iziswh.wh_P_PharmaRec AS pr__2], props={OUTPUT_COLS=[pr__2.PharmaID, pr__2.Status, pr__2.PatientID], EST_COL_STATS={pr__2.PharmaID=[-1.0, -1.0], pr__2.Status=[-1.0, -1.0], pr__2.PatientID=[-1.0, -1.0]}, EST_CARDINALITY=5.5E7}) ============================================================================ EXECUTING MergeCriteria AFTER: Sort(groups=[anon_grp12]) Project(groups=[anon_grp12]) Group(groups=[anon_grp12, iziswh.wh_P_PharmaRec AS pr__2]) Select(groups=[iziswh.wh_P_PharmaRec AS pr__2], props={SELECT_CRITERIA=bitand(convert(pr__2.Status, integer), 2) <> 2, OUTPUT_COLS=[pr__2.PatientID], EST_CARDINALITY=14585.7, EST_COL_STATS={pr__2.PatientID=[-1.0, -1.0]}}) Access(groups=[iziswh.wh_P_PharmaRec AS pr__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[pr__2.Status, pr__2.PatientID], EST_CARDINALITY=14828.795, EST_COL_STATS={pr__2.Status=[-1.0, -1.0], pr__2.PatientID=[-1.0, -1.0]}}) Select(groups=[iziswh.wh_P_PharmaRec AS pr__2], props={SELECT_CRITERIA=pr__2.PharmaID = 1002463, OUTPUT_COLS=[pr__2.Status, pr__2.PatientID], EST_CARDINALITY=14828.795, EST_COL_STATS={pr__2.Status=[-1.0, -1.0], pr__2.PatientID=[-1.0, -1.0]}}) Source(groups=[iziswh.wh_P_PharmaRec AS pr__2], props={OUTPUT_COLS=[pr__2.PharmaID, pr__2.Status, pr__2.PatientID], EST_COL_STATS={pr__2.PharmaID=[-1.0, -1.0], pr__2.Status=[-1.0, -1.0], pr__2.PatientID=[-1.0, -1.0]}, EST_CARDINALITY=5.5E7}) ============================================================================ EXECUTING PlanSorts AFTER: Project(groups=[anon_grp12], props={PROJECT_COLS=[anon_grp12.gcol0 AS PatientID], OUTPUT_COLS=[anon_grp12.gcol0 AS PatientID], EST_CARDINALITY=7292.85, EST_COL_STATS={anon_grp12.gcol0 AS PatientID=[2430.95, -1.0]}}) Group(groups=[anon_grp12, iziswh.wh_P_PharmaRec AS pr__2], props={GROUP_COLS=[pr__2.PatientID], SYMBOL_MAP={anon_grp12.gcol0=pr__2.PatientID}, OUTPUT_COLS=[anon_grp12.gcol0], EST_CARDINALITY=7292.85, EST_COL_STATS={anon_grp12.gcol0=[2430.95, -1.0]}, SORT_ORDER=ORDER BY PatientID}) Select(groups=[iziswh.wh_P_PharmaRec AS pr__2]) Access(groups=[iziswh.wh_P_PharmaRec AS pr__2]) Select(groups=[iziswh.wh_P_PharmaRec AS pr__2]) Source(groups=[iziswh.wh_P_PharmaRec AS pr__2]) ============================================================================ EXECUTING CollapseSource AFTER: Project(groups=[anon_grp12], props={PROJECT_COLS=[anon_grp12.gcol0 AS PatientID], OUTPUT_COLS=[anon_grp12.gcol0 AS PatientID], EST_CARDINALITY=7292.85, EST_COL_STATS={anon_grp12.gcol0 AS PatientID=[2430.95, -1.0]}}) Group(groups=[anon_grp12, iziswh.wh_P_PharmaRec AS pr__2], props={GROUP_COLS=[pr__2.PatientID], SYMBOL_MAP={anon_grp12.gcol0=pr__2.PatientID}, OUTPUT_COLS=[anon_grp12.gcol0], EST_CARDINALITY=7292.85, EST_COL_STATS={anon_grp12.gcol0=[2430.95, -1.0]}, SORT_ORDER=ORDER BY PatientID}) Select(groups=[iziswh.wh_P_PharmaRec AS pr__2]) Access(groups=[iziswh.wh_P_PharmaRec AS pr__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[pr__2.Status, pr__2.PatientID], EST_CARDINALITY=14828.795, EST_COL_STATS={pr__2.Status=[-1.0, -1.0], pr__2.PatientID=[-1.0, -1.0]}, ATOMIC_REQUEST=SELECT pr__2.Status, pr__2.PatientID FROM iziswh.wh_P_PharmaRec AS pr__2 WHERE pr__2.PharmaID = 1002463}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = ProjectNode(13) output=[anon_grp12.gcol0 AS PatientID] [anon_grp12.gcol0 AS PatientID] GroupingNode(14) output=[anon_grp12.gcol0] [pr__2.PatientID]{anon_grp12.gcol0=pr__2.PatientID} SelectNode(15) output=[pr__2.PatientID] bitand(convert(pr__2.Status, integer), 2) <> 2 AccessNode(16) output=[pr__2.Status, pr__2.PatientID] SELECT g_0.Status, g_0.PatientID FROM iziswh.wh_P_PharmaRec AS g_0 WHERE g_0.PharmaID = 1002463 ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: ProjectNode(13) output=[anon_grp12.gcol0 AS PatientID] [anon_grp12.gcol0 AS PatientID] GroupingNode(14) output=[anon_grp12.gcol0] [pr__2.PatientID]{anon_grp12.gcol0=pr__2.PatientID} SelectNode(15) output=[pr__2.PatientID] bitand(convert(pr__2.Status, integer), 2) <> 2 AccessNode(16) output=[pr__2.Status, pr__2.PatientID] SELECT g_0.Status, g_0.PatientID FROM iziswh.wh_P_PharmaRec AS g_0 WHERE g_0.PharmaID = 1002463 ============================================================================ LOW Relational Planner Conditions met (hint or cost) - Converting to a semi merge join Select(groups=[iziswh.wh_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.PatientID IN (SELECT pr.PatientID FROM iziswh.wh_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID), OUTPUT_COLS=[gd.WardID, gd.PatientID, gd.PatGroup, gd.AdmissionTime, dd.DischargeTime], IS_COPIED=true, EST_CARDINALITY=9813.084, EST_COL_STATS={gd.WardID=[-1.0, -1.0], gd.PatientID=[-1.0, -1.0], gd.PatGroup=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], ...}} ---------------------------------------------------------------------------- OPTIMIZE: SELECT pr.PatientID FROM izisprod.prod_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID ORDER BY pr.PatientID ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT pr.PatientID FROM izisprod.prod_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID ORDER BY pr.PatientID CANONICAL PLAN: Sort(groups=[anon_grp17], props={SORT_ORDER=ORDER BY PatientID}) Project(groups=[anon_grp17], props={PROJECT_COLS=[anon_grp17.gcol0 AS PatientID]}) Group(groups=[izisprod.prod_P_PharmaRec AS pr, anon_grp17], props={GROUP_COLS=[pr.PatientID], SYMBOL_MAP={anon_grp17.gcol0=pr.PatientID}}) Select(groups=[izisprod.prod_P_PharmaRec AS pr], props={SELECT_CRITERIA=bitand(convert(pr.Status, integer), 2) <> 2}) Select(groups=[izisprod.prod_P_PharmaRec AS pr], props={SELECT_CRITERIA=pr.PharmaID = 1002463}) Source(groups=[izisprod.prod_P_PharmaRec AS pr]) ============================================================================ EXECUTING PlaceAccess AFTER: Sort(groups=[anon_grp17], props={SORT_ORDER=ORDER BY PatientID}) Project(groups=[anon_grp17], props={PROJECT_COLS=[anon_grp17.gcol0 AS PatientID]}) Group(groups=[anon_grp17, izisprod.prod_P_PharmaRec AS pr__3], props={GROUP_COLS=[pr__3.PatientID], SYMBOL_MAP={anon_grp17.gcol0=pr__3.PatientID}}) Select(groups=[izisprod.prod_P_PharmaRec AS pr__3], props={SELECT_CRITERIA=bitand(convert(pr__3.Status, integer), 2) <> 2}) Select(groups=[izisprod.prod_P_PharmaRec AS pr__3], props={SELECT_CRITERIA=pr__3.PharmaID = 1002463}) Access(groups=[izisprod.prod_P_PharmaRec AS pr__3], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04}) Source(groups=[izisprod.prod_P_PharmaRec AS pr__3]) ============================================================================ EXECUTING PushSelectCriteria AFTER: Sort(groups=[anon_grp17]) Project(groups=[anon_grp17]) Group(groups=[anon_grp17, izisprod.prod_P_PharmaRec AS pr__3], props={GROUP_COLS=[pr__3.PatientID], SYMBOL_MAP={anon_grp17.gcol0=pr__3.PatientID}}) Select(groups=[izisprod.prod_P_PharmaRec AS pr__3], props={SELECT_CRITERIA=bitand(convert(pr__3.Status, integer), 2) <> 2}) Access(groups=[izisprod.prod_P_PharmaRec AS pr__3], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04}) Select(groups=[izisprod.prod_P_PharmaRec AS pr__3], props={SELECT_CRITERIA=pr__3.PharmaID = 1002463}) Source(groups=[izisprod.prod_P_PharmaRec AS pr__3]) ============================================================================ EXECUTING CleanCriteria AFTER: Sort(groups=[anon_grp17], props={SORT_ORDER=ORDER BY PatientID, OUTPUT_COLS=null}) Project(groups=[anon_grp17], props={PROJECT_COLS=[anon_grp17.gcol0 AS PatientID], OUTPUT_COLS=null}) Group(groups=[anon_grp17, izisprod.prod_P_PharmaRec AS pr__3], props={GROUP_COLS=[pr__3.PatientID], SYMBOL_MAP={anon_grp17.gcol0=pr__3.PatientID}, OUTPUT_COLS=null}) Select(groups=[izisprod.prod_P_PharmaRec AS pr__3], props={SELECT_CRITERIA=bitand(convert(pr__3.Status, integer), 2) <> 2, OUTPUT_COLS=null}) Access(groups=[izisprod.prod_P_PharmaRec AS pr__3], 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_PharmaRec AS pr__3], props={SELECT_CRITERIA=pr__3.PharmaID = 1002463, OUTPUT_COLS=null}) Source(groups=[izisprod.prod_P_PharmaRec AS pr__3], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING RaiseAccess LOW Relational Planner bitand function not supported by source izisprod - bitand(convert(pr__3.Status, integer), 2) was not pushed AFTER: Sort(groups=[anon_grp17]) Project(groups=[anon_grp17]) Group(groups=[anon_grp17, izisprod.prod_P_PharmaRec AS pr__3]) Select(groups=[izisprod.prod_P_PharmaRec AS pr__3], props={SELECT_CRITERIA=bitand(convert(pr__3.Status, integer), 2) <> 2, OUTPUT_COLS=null}) Access(groups=[izisprod.prod_P_PharmaRec AS pr__3], 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_PharmaRec AS pr__3]) Source(groups=[izisprod.prod_P_PharmaRec AS pr__3]) ============================================================================ EXECUTING PushAggregates AFTER: Sort(groups=[anon_grp17]) Project(groups=[anon_grp17], props={PROJECT_COLS=[anon_grp17.gcol0 AS PatientID], OUTPUT_COLS=null}) Group(groups=[anon_grp17, izisprod.prod_P_PharmaRec AS pr__3], props={GROUP_COLS=[pr__3.PatientID], SYMBOL_MAP={anon_grp17.gcol0=pr__3.PatientID}, OUTPUT_COLS=null}) Select(groups=[izisprod.prod_P_PharmaRec AS pr__3]) Access(groups=[izisprod.prod_P_PharmaRec AS pr__3]) Select(groups=[izisprod.prod_P_PharmaRec AS pr__3]) Source(groups=[izisprod.prod_P_PharmaRec AS pr__3]) ============================================================================ EXECUTING AssignOutputElements AFTER: Sort(groups=[anon_grp17], props={SORT_ORDER=ORDER BY PatientID, OUTPUT_COLS=[anon_grp17.gcol0 AS PatientID], UNRELATED_SORT=false}) Project(groups=[anon_grp17], props={PROJECT_COLS=[anon_grp17.gcol0 AS PatientID], OUTPUT_COLS=[anon_grp17.gcol0 AS PatientID]}) Group(groups=[anon_grp17, izisprod.prod_P_PharmaRec AS pr__3], props={GROUP_COLS=[pr__3.PatientID], SYMBOL_MAP={anon_grp17.gcol0=pr__3.PatientID}, OUTPUT_COLS=[anon_grp17.gcol0]}) Select(groups=[izisprod.prod_P_PharmaRec AS pr__3], props={SELECT_CRITERIA=bitand(convert(pr__3.Status, integer), 2) <> 2, OUTPUT_COLS=[pr__3.PatientID]}) Access(groups=[izisprod.prod_P_PharmaRec AS pr__3], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[pr__3.Status, pr__3.PatientID]}) Select(groups=[izisprod.prod_P_PharmaRec AS pr__3], props={SELECT_CRITERIA=pr__3.PharmaID = 1002463, OUTPUT_COLS=[pr__3.Status, pr__3.PatientID]}) Source(groups=[izisprod.prod_P_PharmaRec AS pr__3], props={OUTPUT_COLS=[pr__3.PharmaID, pr__3.Status, pr__3.PatientID]}) ============================================================================ EXECUTING CalculateCost AFTER: Sort(groups=[anon_grp17], props={SORT_ORDER=ORDER BY PatientID, OUTPUT_COLS=[anon_grp17.gcol0 AS PatientID], UNRELATED_SORT=false, EST_CARDINALITY=734.5361, EST_COL_STATS={anon_grp17.gcol0 AS PatientID=[244.84535, -1.0]}}) Project(groups=[anon_grp17], props={PROJECT_COLS=[anon_grp17.gcol0 AS PatientID], OUTPUT_COLS=[anon_grp17.gcol0 AS PatientID], EST_CARDINALITY=734.5361, EST_COL_STATS={anon_grp17.gcol0 AS PatientID=[244.84535, -1.0]}}) Group(groups=[anon_grp17, izisprod.prod_P_PharmaRec AS pr__3], props={GROUP_COLS=[pr__3.PatientID], SYMBOL_MAP={anon_grp17.gcol0=pr__3.PatientID}, OUTPUT_COLS=[anon_grp17.gcol0], EST_CARDINALITY=734.5361, EST_COL_STATS={anon_grp17.gcol0=[244.84535, -1.0]}}) Select(groups=[izisprod.prod_P_PharmaRec AS pr__3], props={SELECT_CRITERIA=bitand(convert(pr__3.Status, integer), 2) <> 2, OUTPUT_COLS=[pr__3.PatientID], EST_CARDINALITY=1469.0721, EST_COL_STATS={pr__3.PatientID=[-1.0, -1.0]}}) Access(groups=[izisprod.prod_P_PharmaRec AS pr__3], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[pr__3.Status, pr__3.PatientID], EST_CARDINALITY=1546.3917, EST_COL_STATS={pr__3.Status=[-1.0, -1.0], pr__3.PatientID=[-1.0, -1.0]}}) Select(groups=[izisprod.prod_P_PharmaRec AS pr__3], props={SELECT_CRITERIA=pr__3.PharmaID = 1002463, OUTPUT_COLS=[pr__3.Status, pr__3.PatientID], EST_CARDINALITY=1546.3917, EST_COL_STATS={pr__3.Status=[-1.0, -1.0], pr__3.PatientID=[-1.0, -1.0]}}) Source(groups=[izisprod.prod_P_PharmaRec AS pr__3], props={OUTPUT_COLS=[pr__3.PharmaID, pr__3.Status, pr__3.PatientID], EST_COL_STATS={pr__3.PharmaID=[-1.0, -1.0], pr__3.Status=[-1.0, -1.0], pr__3.PatientID=[-1.0, -1.0]}, EST_CARDINALITY=600000.0}) ============================================================================ EXECUTING MergeCriteria AFTER: Sort(groups=[anon_grp17]) Project(groups=[anon_grp17]) Group(groups=[anon_grp17, izisprod.prod_P_PharmaRec AS pr__3]) Select(groups=[izisprod.prod_P_PharmaRec AS pr__3], props={SELECT_CRITERIA=bitand(convert(pr__3.Status, integer), 2) <> 2, OUTPUT_COLS=[pr__3.PatientID], EST_CARDINALITY=1469.0721, EST_COL_STATS={pr__3.PatientID=[-1.0, -1.0]}}) Access(groups=[izisprod.prod_P_PharmaRec AS pr__3], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[pr__3.Status, pr__3.PatientID], EST_CARDINALITY=1546.3917, EST_COL_STATS={pr__3.Status=[-1.0, -1.0], pr__3.PatientID=[-1.0, -1.0]}}) Select(groups=[izisprod.prod_P_PharmaRec AS pr__3], props={SELECT_CRITERIA=pr__3.PharmaID = 1002463, OUTPUT_COLS=[pr__3.Status, pr__3.PatientID], EST_CARDINALITY=1546.3917, EST_COL_STATS={pr__3.Status=[-1.0, -1.0], pr__3.PatientID=[-1.0, -1.0]}}) Source(groups=[izisprod.prod_P_PharmaRec AS pr__3], props={OUTPUT_COLS=[pr__3.PharmaID, pr__3.Status, pr__3.PatientID], EST_COL_STATS={pr__3.PharmaID=[-1.0, -1.0], pr__3.Status=[-1.0, -1.0], pr__3.PatientID=[-1.0, -1.0]}, EST_CARDINALITY=600000.0}) ============================================================================ EXECUTING PlanSorts AFTER: Project(groups=[anon_grp17], props={PROJECT_COLS=[anon_grp17.gcol0 AS PatientID], OUTPUT_COLS=[anon_grp17.gcol0 AS PatientID], EST_CARDINALITY=734.5361, EST_COL_STATS={anon_grp17.gcol0 AS PatientID=[244.84535, -1.0]}}) Group(groups=[anon_grp17, izisprod.prod_P_PharmaRec AS pr__3], props={GROUP_COLS=[pr__3.PatientID], SYMBOL_MAP={anon_grp17.gcol0=pr__3.PatientID}, OUTPUT_COLS=[anon_grp17.gcol0], EST_CARDINALITY=734.5361, EST_COL_STATS={anon_grp17.gcol0=[244.84535, -1.0]}, SORT_ORDER=ORDER BY PatientID}) Select(groups=[izisprod.prod_P_PharmaRec AS pr__3]) Access(groups=[izisprod.prod_P_PharmaRec AS pr__3]) Select(groups=[izisprod.prod_P_PharmaRec AS pr__3]) Source(groups=[izisprod.prod_P_PharmaRec AS pr__3]) ============================================================================ EXECUTING CollapseSource AFTER: Project(groups=[anon_grp17], props={PROJECT_COLS=[anon_grp17.gcol0 AS PatientID], OUTPUT_COLS=[anon_grp17.gcol0 AS PatientID], EST_CARDINALITY=734.5361, EST_COL_STATS={anon_grp17.gcol0 AS PatientID=[244.84535, -1.0]}}) Group(groups=[anon_grp17, izisprod.prod_P_PharmaRec AS pr__3], props={GROUP_COLS=[pr__3.PatientID], SYMBOL_MAP={anon_grp17.gcol0=pr__3.PatientID}, OUTPUT_COLS=[anon_grp17.gcol0], EST_CARDINALITY=734.5361, EST_COL_STATS={anon_grp17.gcol0=[244.84535, -1.0]}, SORT_ORDER=ORDER BY PatientID}) Select(groups=[izisprod.prod_P_PharmaRec AS pr__3]) Access(groups=[izisprod.prod_P_PharmaRec AS pr__3], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[pr__3.Status, pr__3.PatientID], EST_CARDINALITY=1546.3917, EST_COL_STATS={pr__3.Status=[-1.0, -1.0], pr__3.PatientID=[-1.0, -1.0]}, ATOMIC_REQUEST=SELECT pr__3.Status, pr__3.PatientID FROM izisprod.prod_P_PharmaRec AS pr__3 WHERE pr__3.PharmaID = 1002463}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = ProjectNode(18) output=[anon_grp17.gcol0 AS PatientID] [anon_grp17.gcol0 AS PatientID] GroupingNode(19) output=[anon_grp17.gcol0] [pr__3.PatientID]{anon_grp17.gcol0=pr__3.PatientID} SelectNode(20) output=[pr__3.PatientID] bitand(convert(pr__3.Status, integer), 2) <> 2 AccessNode(21) output=[pr__3.Status, pr__3.PatientID] SELECT g_0.Status, g_0.PatientID FROM izisprod.prod_P_PharmaRec AS g_0 WHERE g_0.PharmaID = 1002463 ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: ProjectNode(18) output=[anon_grp17.gcol0 AS PatientID] [anon_grp17.gcol0 AS PatientID] GroupingNode(19) output=[anon_grp17.gcol0] [pr__3.PatientID]{anon_grp17.gcol0=pr__3.PatientID} SelectNode(20) output=[pr__3.PatientID] bitand(convert(pr__3.Status, integer), 2) <> 2 AccessNode(21) output=[pr__3.Status, pr__3.PatientID] SELECT g_0.Status, g_0.PatientID FROM izisprod.prod_P_PharmaRec AS g_0 WHERE g_0.PharmaID = 1002463 ============================================================================ LOW Relational Planner Conditions met (hint or cost) - Converting to a semi merge join Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=gd__1.PatientID IN (SELECT pr.PatientID FROM izisprod.prod_P_PharmaRec AS pr WHERE (pr.PharmaID = 1002463) AND (bitand(convert(pr.Status, integer), 2) <> 2) GROUP BY pr.PatientID), OUTPUT_COLS=[gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime], IS_COPIED=true, EST_CARDINALITY=76.08695, EST_COL_STATS={gd__1.PatientID=[-1.0, -1.0], gd__1.PatGroup=[-1.0, -1.0], wr__1.Abbreviation=[-1.0, -1.0], gd__1.AdmissionTime=[-1.0, -1.0], ...}} AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) SetOperation(groups=[]) TupleLimit(groups=[]) Sort(groups=[]) Project(groups=[anon_grp0]) Group(groups=[iziswh.wh_P_DischargeData AS dd, iziswh.wh_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr, anon_grp0]) Join(groups=[izisprod.prod_S_WardRef AS wr, iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[wr.WardID = gd.WardID], LEFT_EXPRESSIONS=[wr.WardID], RIGHT_EXPRESSIONS=[gd.WardID], NON_EQUI_JOIN_CRITERIA=[], DEPENDENT_VALUE_SOURCE=$dsc/id743, OUTPUT_COLS=[gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime], EST_CARDINALITY=828.6078, EST_COL_STATS={gd.PatientID=[-1.0, -1.0], gd.PatGroup=[-1.0, -1.0], wr.Abbreviation=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], ...}, IS_LEFT_DISTINCT=true, SORT_RIGHT=SORT}) Access(groups=[izisprod.prod_S_WardRef AS wr]) Sort(groups=[]) Source(groups=[izisprod.prod_S_WardRef AS wr]) Join(groups=[iziswh.wh_P_GeneralData AS gd], props={JOIN_STRATEGY=MERGE, JOIN_TYPE=SEMI JOIN, NON_EQUI_JOIN_CRITERIA=[], LEFT_EXPRESSIONS=[gd.PatientID], RIGHT_EXPRESSIONS=[pr.PatientID], SORT_RIGHT=ALREADY_SORTED, OUTPUT_COLS=[gd.WardID, gd.PatientID, gd.PatGroup, gd.AdmissionTime, dd.DischargeTime]}) Access(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[gd.PatientID, gd.WardID, gd.PatGroup, gd.AdmissionTime, dd.DischargeTime], CONFORMED_SOURCES=null, EST_CARDINALITY=29439.252, EST_COL_STATS={gd.PatientID=[-1.0, -1.0], gd.WardID=[-1.0, -1.0], gd.PatGroup=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Sort(groups=[], props={SORT_ORDER=ORDER BY gd.PatientID, OUTPUT_COLS=[gd.PatientID, gd.WardID, gd.PatGroup, gd.AdmissionTime, dd.DischargeTime]}) Select(groups=[iziswh.wh_P_GeneralData AS gd], props={SELECT_CRITERIA=gd.WardID IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[gd.PatientID, gd.WardID, gd.PatGroup, gd.AdmissionTime, dd.DischargeTime], EST_CARDINALITY=29439.252, EST_COL_STATS={gd.PatientID=[-1.0, -1.0], gd.WardID=[-1.0, -1.0], gd.PatGroup=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], ...}}) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd.PatientID = dd.PatientID], OUTPUT_COLS=[gd.WardID, gd.PatientID, gd.PatGroup, gd.AdmissionTime, dd.DischargeTime], MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, IS_COPIED=true, EST_CARDINALITY=45000.0, EST_COL_STATS={gd.Address=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], gd.AdmissionWard=[-1.0, -1.0], gd.BedID=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_GeneralData AS gd], props={OUTPUT_COLS=[gd.PatientID, gd.WardID, gd.PatGroup, gd.AdmissionTime], EST_COL_STATS={gd.Address=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], gd.AdmissionWard=[-1.0, -1.0], gd.BedID=[-1.0, -1.0], ...}, EST_CARDINALITY=45000.0}) Source(groups=[iziswh.wh_P_DischargeData AS dd], props={OUTPUT_COLS=[dd.PatientID, dd.DischargeTime], EST_COL_STATS={dd.ActorID=[-1.0, -1.0], dd.DischargeTime=[-1.0, -1.0], dd.DischargedTo=[-1.0, -1.0], dd.ICUDiagnosis=[-1.0, -1.0], ...}, EST_CARDINALITY=45000.0}) Access(groups=[], props={PROCESSOR_PLAN=ProjectNode(13) output=[anon_grp12.gcol0 AS PatientID] [anon_grp12.gcol0 AS PatientID] GroupingNode(14) output=[anon_grp12.gcol0] [pr__2.PatientID]{anon_grp12.gcol0=pr__2.PatientID} SelectNode(15) output=[pr__2.PatientID] bitand(convert(pr__2.Status, integer), 2) <> 2 AccessNode(16) output=[pr__2.Status, pr__2.PatientID] SELECT g_0.Status, g_0.PatientID FROM iziswh.wh_P_PharmaRec AS g_0 WHERE g_0.PharmaID = 1002463 , OUTPUT_COLS=[pr.PatientID], EST_CARDINALITY=7292.85}) TupleLimit(groups=[]) Sort(groups=[]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1], props={GROUP_COLS=[gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime], SYMBOL_MAP={anon_grp1.gcol0=gd__1.PatientID, anon_grp1.gcol1=gd__1.PatGroup, anon_grp1.gcol2=wr__1.Abbreviation, anon_grp1.gcol3=gd__1.AdmissionTime, anon_grp1.gcol4=dd__1.DischargeTime}, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3, anon_grp1.gcol4], EST_CARDINALITY=38.043476, EST_COL_STATS={anon_grp1.gcol0=[12.681159, -1.0], anon_grp1.gcol1=[12.681159, -1.0], anon_grp1.gcol2=[12.681159, -1.0], anon_grp1.gcol3=[12.681159, -1.0], ...}}) Join(groups=[izisprod.prod_P_GeneralData AS gd__1], props={JOIN_STRATEGY=MERGE, JOIN_TYPE=SEMI JOIN, NON_EQUI_JOIN_CRITERIA=[], LEFT_EXPRESSIONS=[gd__1.PatientID], RIGHT_EXPRESSIONS=[pr.PatientID], SORT_RIGHT=ALREADY_SORTED, OUTPUT_COLS=[gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime]}) Access(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__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.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime], CONFORMED_SOURCES=null, EST_CARDINALITY=228.26085, EST_COL_STATS={gd__1.PatientID=[-1.0, -1.0], gd__1.PatGroup=[-1.0, -1.0], wr__1.Abbreviation=[-1.0, -1.0], gd__1.AdmissionTime=[-1.0, -1.0], ...}}) Sort(groups=[], props={SORT_ORDER=ORDER BY gd__1.PatientID, OUTPUT_COLS=[gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime]}) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[wr__1.WardID = gd__1.WardID], OUTPUT_COLS=[gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime], MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, IS_COPIED=true, EST_CARDINALITY=228.26085, EST_COL_STATS={gd__1.PatientID=[-1.0, -1.0], gd__1.PatGroup=[-1.0, -1.0], wr__1.Abbreviation=[-1.0, -1.0], gd__1.AdmissionTime=[-1.0, -1.0], ...}}) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[gd__1.PatientID = dd__1.PatientID], OUTPUT_COLS=[gd__1.WardID, gd__1.PatientID, gd__1.PatGroup, gd__1.AdmissionTime, dd__1.DischargeTime], MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, IS_COPIED=true, EST_CARDINALITY=749.99994, EST_COL_STATS={gd__1.WardID=[-1.0, -1.0], gd__1.PatientID=[-1.0, -1.0], gd__1.PatGroup=[-1.0, -1.0], gd__1.AdmissionTime=[-1.0, -1.0], ...}}) Select(groups=[izisprod.prod_P_GeneralData AS gd__1], props={SELECT_CRITERIA=(gd__1.Status >= 4) AND (gd__1.Status <> 5), OUTPUT_COLS=[gd__1.PatientID, gd__1.WardID, gd__1.PatGroup, gd__1.AdmissionTime], IS_COPIED=true, EST_CARDINALITY=119.99999, EST_COL_STATS={gd__1.PatientID=[-1.0, -1.0], gd__1.WardID=[-1.0, -1.0], gd__1.PatGroup=[-1.0, -1.0], gd__1.AdmissionTime=[-1.0, -1.0]}}) Source(groups=[izisprod.prod_P_GeneralData AS gd__1], props={OUTPUT_COLS=[gd__1.Status, gd__1.PatientID, gd__1.WardID, gd__1.PatGroup, gd__1.AdmissionTime], EST_COL_STATS={gd__1.Status=[-1.0, -1.0], gd__1.PatientID=[-1.0, -1.0], gd__1.WardID=[-1.0, -1.0], gd__1.PatGroup=[-1.0, -1.0], ...}, EST_CARDINALITY=400.0}) Source(groups=[izisprod.prod_P_DischargeData AS dd__1], props={OUTPUT_COLS=[dd__1.PatientID, dd__1.DischargeTime], EST_COL_STATS={dd__1.PatientID=[-1.0, -1.0], dd__1.DischargeTime=[-1.0, -1.0]}, EST_CARDINALITY=300.0}) Source(groups=[izisprod.prod_S_WardRef AS wr__1], props={OUTPUT_COLS=[wr__1.WardID, wr__1.Abbreviation], EST_COL_STATS={wr__1.WardID=[-1.0, -1.0], wr__1.Abbreviation=[-1.0, -1.0]}, EST_CARDINALITY=70.0}) Access(groups=[], props={PROCESSOR_PLAN=ProjectNode(18) output=[anon_grp17.gcol0 AS PatientID] [anon_grp17.gcol0 AS PatientID] GroupingNode(19) output=[anon_grp17.gcol0] [pr__3.PatientID]{anon_grp17.gcol0=pr__3.PatientID} SelectNode(20) output=[pr__3.PatientID] bitand(convert(pr__3.Status, integer), 2) <> 2 AccessNode(21) output=[pr__3.Status, pr__3.PatientID] SELECT g_0.Status, g_0.PatientID FROM izisprod.prod_P_PharmaRec AS g_0 WHERE g_0.PharmaID = 1002463 , OUTPUT_COLS=[pr.PatientID], EST_CARDINALITY=734.5361}) ============================================================================ EXECUTING PlanSorts AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin], EST_CARDINALITY=100.0, EST_COL_STATS={anon_grp0.gcol0 AS admissionid=[28.74016, -1.0], anon_grp0.gcol1 AS patgroup=[28.74016, -1.0], anon_grp0.gcol2 AS ward=[28.74016, -1.0], anon_grp0.gcol3 AS admtime=[28.74016, -1.0], ...}}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin], EST_CARDINALITY=138.04347, EST_COL_STATS={anon_grp0.gcol0 AS admissionid=[39.673916, -1.0], anon_grp0.gcol1 AS patgroup=[39.673916, -1.0], anon_grp0.gcol2 AS ward=[39.673916, -1.0], anon_grp0.gcol3 AS admtime=[39.673916, -1.0], ...}}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin], OUTPUT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin], EST_CARDINALITY=414.3039, EST_COL_STATS={anon_grp0.gcol0 AS admissionid=[138.1013, -1.0], anon_grp0.gcol1 AS patgroup=[138.1013, -1.0], anon_grp0.gcol2 AS ward=[138.1013, -1.0], anon_grp0.gcol3 AS admtime=[138.1013, -1.0], ...}}) TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.gcol2, anon_grp0.gcol3, anon_grp0.gcol4], EST_CARDINALITY=100.0, EST_COL_STATS={anon_grp0.gcol0 AS admissionid=[33.333336, -1.0], anon_grp0.gcol1 AS patgroup=[33.333336, -1.0], anon_grp0.gcol2 AS ward=[33.333336, -1.0], anon_grp0.gcol3 AS admtime=[33.333336, -1.0], ...}}) Group(groups=[iziswh.wh_P_DischargeData AS dd, iziswh.wh_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr, anon_grp0], props={GROUP_COLS=[gd.AdmissionTime, gd.PatientID, gd.PatGroup, wr.Abbreviation, dd.DischargeTime], SYMBOL_MAP={anon_grp0.gcol0=gd.PatientID, anon_grp0.gcol1=gd.PatGroup, anon_grp0.gcol2=wr.Abbreviation, anon_grp0.gcol3=gd.AdmissionTime, anon_grp0.gcol4=dd.DischargeTime}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.gcol2, anon_grp0.gcol3, anon_grp0.gcol4], EST_CARDINALITY=414.3039, EST_COL_STATS={anon_grp0.gcol0=[138.1013, -1.0], anon_grp0.gcol1=[138.1013, -1.0], anon_grp0.gcol2=[138.1013, -1.0], anon_grp0.gcol3=[138.1013, -1.0], ...}, SORT_ORDER=ORDER BY anon_grp0.gcol3}) Join(groups=[izisprod.prod_S_WardRef AS wr, iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[wr.WardID = gd.WardID], LEFT_EXPRESSIONS=[wr.WardID], RIGHT_EXPRESSIONS=[gd.WardID], NON_EQUI_JOIN_CRITERIA=[], DEPENDENT_VALUE_SOURCE=$dsc/id743, OUTPUT_COLS=[gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime], EST_CARDINALITY=828.6078, EST_COL_STATS={gd.PatientID=[-1.0, -1.0], gd.PatGroup=[-1.0, -1.0], wr.Abbreviation=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], ...}, IS_LEFT_DISTINCT=true, SORT_RIGHT=SORT}) Access(groups=[izisprod.prod_S_WardRef AS wr]) Sort(groups=[]) Source(groups=[izisprod.prod_S_WardRef AS wr]) Join(groups=[iziswh.wh_P_GeneralData AS gd], props={JOIN_STRATEGY=MERGE, JOIN_TYPE=SEMI JOIN, NON_EQUI_JOIN_CRITERIA=[], LEFT_EXPRESSIONS=[gd.PatientID], RIGHT_EXPRESSIONS=[pr.PatientID], SORT_RIGHT=ALREADY_SORTED, OUTPUT_COLS=[gd.WardID, gd.PatientID, gd.PatGroup, gd.AdmissionTime, dd.DischargeTime]}) Access(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd]) Sort(groups=[]) Select(groups=[iziswh.wh_P_GeneralData AS gd]) Join(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd]) Source(groups=[iziswh.wh_P_GeneralData AS gd]) Source(groups=[iziswh.wh_P_DischargeData AS dd]) Access(groups=[]) Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS PatGroup, anon_grp1.gcol2 AS Abbreviation, anon_grp1.gcol3 AS AdmissionTime, anon_grp1.gcol4 AS DischargeTime, 'prod'], OUTPUT_COLS=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS PatGroup, anon_grp1.gcol2 AS Abbreviation, anon_grp1.gcol3 AS AdmissionTime, anon_grp1.gcol4 AS DischargeTime, 'prod'], EST_CARDINALITY=38.043476, EST_COL_STATS={anon_grp1.gcol0 AS PatientID=[12.681159, -1.0], anon_grp1.gcol1 AS PatGroup=[12.681159, -1.0], anon_grp1.gcol2 AS Abbreviation=[12.681159, -1.0], anon_grp1.gcol3 AS AdmissionTime=[12.681159, -1.0], ...}}) TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3, anon_grp1.gcol4], EST_CARDINALITY=38.043476, EST_COL_STATS={anon_grp1.gcol0 AS PatientID=[12.681159, -1.0], anon_grp1.gcol1 AS PatGroup=[12.681159, -1.0], anon_grp1.gcol2 AS Abbreviation=[12.681159, -1.0], anon_grp1.gcol3 AS AdmissionTime=[12.681159, -1.0], ...}}) Group(groups=[anon_grp1, izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1], props={GROUP_COLS=[gd__1.AdmissionTime, gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, dd__1.DischargeTime], SYMBOL_MAP={anon_grp1.gcol0=gd__1.PatientID, anon_grp1.gcol1=gd__1.PatGroup, anon_grp1.gcol2=wr__1.Abbreviation, anon_grp1.gcol3=gd__1.AdmissionTime, anon_grp1.gcol4=dd__1.DischargeTime}, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3, anon_grp1.gcol4], EST_CARDINALITY=38.043476, EST_COL_STATS={anon_grp1.gcol0=[12.681159, -1.0], anon_grp1.gcol1=[12.681159, -1.0], anon_grp1.gcol2=[12.681159, -1.0], anon_grp1.gcol3=[12.681159, -1.0], ...}, SORT_ORDER=ORDER BY anon_grp1.gcol3}) Join(groups=[izisprod.prod_P_GeneralData AS gd__1], props={JOIN_STRATEGY=MERGE, JOIN_TYPE=SEMI JOIN, NON_EQUI_JOIN_CRITERIA=[], LEFT_EXPRESSIONS=[gd__1.PatientID], RIGHT_EXPRESSIONS=[pr.PatientID], SORT_RIGHT=ALREADY_SORTED, OUTPUT_COLS=[gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime]}) Access(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Sort(groups=[]) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1]) Join(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1]) Select(groups=[izisprod.prod_P_GeneralData AS gd__1]) Source(groups=[izisprod.prod_P_GeneralData AS gd__1]) Source(groups=[izisprod.prod_P_DischargeData AS dd__1]) Source(groups=[izisprod.prod_S_WardRef AS wr__1]) Access(groups=[]) ============================================================================ EXECUTING CollapseSource AFTER: TupleLimit(groups=[]) SetOperation(groups=[]) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin], OUTPUT_COLS=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin], EST_CARDINALITY=414.3039, EST_COL_STATS={anon_grp0.gcol0 AS admissionid=[138.1013, -1.0], anon_grp0.gcol1 AS patgroup=[138.1013, -1.0], anon_grp0.gcol2 AS ward=[138.1013, -1.0], anon_grp0.gcol3 AS admtime=[138.1013, -1.0], ...}}) TupleLimit(groups=[]) Group(groups=[iziswh.wh_P_DischargeData AS dd, iziswh.wh_P_GeneralData AS gd, izisprod.prod_S_WardRef AS wr, anon_grp0], props={GROUP_COLS=[gd.AdmissionTime, gd.PatientID, gd.PatGroup, wr.Abbreviation, dd.DischargeTime], SYMBOL_MAP={anon_grp0.gcol0=gd.PatientID, anon_grp0.gcol1=gd.PatGroup, anon_grp0.gcol2=wr.Abbreviation, anon_grp0.gcol3=gd.AdmissionTime, anon_grp0.gcol4=dd.DischargeTime}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.gcol2, anon_grp0.gcol3, anon_grp0.gcol4], EST_CARDINALITY=414.3039, EST_COL_STATS={anon_grp0.gcol0=[138.1013, -1.0], anon_grp0.gcol1=[138.1013, -1.0], anon_grp0.gcol2=[138.1013, -1.0], anon_grp0.gcol3=[138.1013, -1.0], ...}, SORT_ORDER=ORDER BY anon_grp0.gcol3}) Join(groups=[izisprod.prod_S_WardRef AS wr, iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd]) Access(groups=[izisprod.prod_S_WardRef AS wr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[wr.WardID, wr.Abbreviation], EST_CARDINALITY=70.0, EST_COL_STATS={wr.Abbreviation=[-1.0, -1.0], wr.Address=[-1.0, -1.0], wr.ArchStatus=[-1.0, -1.0], wr.ArchTime=[-1.0, -1.0], ...}, ATOMIC_REQUEST=SELECT wr.WardID, wr.Abbreviation FROM izisprod.prod_S_WardRef AS wr ORDER BY wr.WardID}) Join(groups=[iziswh.wh_P_GeneralData AS gd]) Access(groups=[iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[gd.PatientID, gd.WardID, gd.PatGroup, gd.AdmissionTime, dd.DischargeTime], CONFORMED_SOURCES=null, EST_CARDINALITY=29439.252, EST_COL_STATS={gd.PatientID=[-1.0, -1.0], gd.WardID=[-1.0, -1.0], gd.PatGroup=[-1.0, -1.0], gd.AdmissionTime=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true, ATOMIC_REQUEST=SELECT DISTINCT gd.PatientID, gd.WardID, gd.PatGroup, gd.AdmissionTime, dd.DischargeTime FROM iziswh.wh_P_GeneralData AS gd, iziswh.wh_P_DischargeData AS dd WHERE (gd.PatientID = dd.PatientID) AND (gd.WardID IN ()) ORDER BY gd.PatientID}) Access(groups=[], props={PROCESSOR_PLAN=ProjectNode(13) output=[anon_grp12.gcol0 AS PatientID] [anon_grp12.gcol0 AS PatientID] GroupingNode(14) output=[anon_grp12.gcol0] [pr__2.PatientID]{anon_grp12.gcol0=pr__2.PatientID} SelectNode(15) output=[pr__2.PatientID] bitand(convert(pr__2.Status, integer), 2) <> 2 AccessNode(16) output=[pr__2.Status, pr__2.PatientID] SELECT g_0.Status, g_0.PatientID FROM iziswh.wh_P_PharmaRec AS g_0 WHERE g_0.PharmaID = 1002463 , OUTPUT_COLS=[pr.PatientID], EST_CARDINALITY=7292.85}) Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS PatGroup, anon_grp1.gcol2 AS Abbreviation, anon_grp1.gcol3 AS AdmissionTime, anon_grp1.gcol4 AS DischargeTime, 'prod'], OUTPUT_COLS=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS PatGroup, anon_grp1.gcol2 AS Abbreviation, anon_grp1.gcol3 AS AdmissionTime, anon_grp1.gcol4 AS DischargeTime, 'prod'], EST_CARDINALITY=38.043476, EST_COL_STATS={anon_grp1.gcol0 AS PatientID=[12.681159, -1.0], anon_grp1.gcol1 AS PatGroup=[12.681159, -1.0], anon_grp1.gcol2 AS Abbreviation=[12.681159, -1.0], anon_grp1.gcol3 AS AdmissionTime=[12.681159, -1.0], ...}}) TupleLimit(groups=[]) Group(groups=[anon_grp1, izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1], props={GROUP_COLS=[gd__1.AdmissionTime, gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, dd__1.DischargeTime], SYMBOL_MAP={anon_grp1.gcol0=gd__1.PatientID, anon_grp1.gcol1=gd__1.PatGroup, anon_grp1.gcol2=wr__1.Abbreviation, anon_grp1.gcol3=gd__1.AdmissionTime, anon_grp1.gcol4=dd__1.DischargeTime}, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3, anon_grp1.gcol4], EST_CARDINALITY=38.043476, EST_COL_STATS={anon_grp1.gcol0=[12.681159, -1.0], anon_grp1.gcol1=[12.681159, -1.0], anon_grp1.gcol2=[12.681159, -1.0], anon_grp1.gcol3=[12.681159, -1.0], ...}, SORT_ORDER=ORDER BY anon_grp1.gcol3}) Join(groups=[izisprod.prod_P_GeneralData AS gd__1]) Access(groups=[izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__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.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime], CONFORMED_SOURCES=null, EST_CARDINALITY=228.26085, EST_COL_STATS={gd__1.PatientID=[-1.0, -1.0], gd__1.PatGroup=[-1.0, -1.0], wr__1.Abbreviation=[-1.0, -1.0], gd__1.AdmissionTime=[-1.0, -1.0], ...}, ATOMIC_REQUEST=SELECT DISTINCT gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime FROM izisprod.prod_P_GeneralData AS gd__1, izisprod.prod_P_DischargeData AS dd__1, izisprod.prod_S_WardRef AS wr__1 WHERE (gd__1.PatientID = dd__1.PatientID) AND (wr__1.WardID = gd__1.WardID) AND (gd__1.Status >= 4) AND (gd__1.Status <> 5) ORDER BY gd__1.PatientID}) Access(groups=[], props={PROCESSOR_PLAN=ProjectNode(18) output=[anon_grp17.gcol0 AS PatientID] [anon_grp17.gcol0 AS PatientID] GroupingNode(19) output=[anon_grp17.gcol0] [pr__3.PatientID]{anon_grp17.gcol0=pr__3.PatientID} SelectNode(20) output=[pr__3.PatientID] bitand(convert(pr__3.Status, integer), 2) <> 2 AccessNode(21) output=[pr__3.Status, pr__3.PatientID] SELECT g_0.Status, g_0.PatientID FROM izisprod.prod_P_PharmaRec AS g_0 WHERE g_0.PharmaID = 1002463 , OUTPUT_COLS=[pr.PatientID], EST_CARDINALITY=734.5361}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = LimitNode(22) output=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin] limit 100 UnionAllNode(23) output=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin] ProjectNode(24) output=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin] [anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin] LimitNode(25) output=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.gcol2, anon_grp0.gcol3, anon_grp0.gcol4] limit 100 GroupingNode(26) output=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.gcol2, anon_grp0.gcol3, anon_grp0.gcol4] [gd.AdmissionTime, gd.PatientID, gd.PatGroup, wr.Abbreviation, dd.DischargeTime]{anon_grp0.gcol0=gd.PatientID, anon_grp0.gcol1=gd.PatGroup, anon_grp0.gcol2=wr.Abbreviation, anon_grp0.gcol3=gd.AdmissionTime, anon_grp0.gcol4=dd.DischargeTime} JoinNode(27) [Dependent] [ENHANCED SORT JOIN (ALREADY_SORTED/SORT)] [INNER JOIN] criteria=[wr.WardID=gd.WardID] output=[gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime] AccessNode(28) output=[wr.WardID, wr.Abbreviation] SELECT g_0.WardID AS c_0, g_0.Abbreviation AS c_1 FROM izisprod.prod_S_WardRef AS g_0 ORDER BY c_0 JoinNode(29) [MERGE JOIN (ALREADY_SORTED/ALREADY_SORTED)] [SEMI JOIN] criteria=[gd.PatientID=pr.PatientID] output=[gd.WardID, gd.PatientID, gd.PatGroup, gd.AdmissionTime, dd.DischargeTime] DependentAccessNode(30) output=[gd.PatientID, gd.WardID, gd.PatGroup, gd.AdmissionTime, dd.DischargeTime] SELECT DISTINCT g_0.PatientID AS c_0, g_0.WardID AS c_1, g_0.PatGroup AS c_2, g_0.AdmissionTime AS c_3, g_1.DischargeTime AS c_4 FROM iziswh.wh_P_GeneralData AS g_0, iziswh.wh_P_DischargeData AS g_1 WHERE (g_0.PatientID = g_1.PatientID) AND (g_0.WardID IN ()) ORDER BY c_0 PlanExecutionNode(31) output=[pr.PatientID] ProjectNode(32) output=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS PatGroup, anon_grp1.gcol2 AS Abbreviation, anon_grp1.gcol3 AS AdmissionTime, anon_grp1.gcol4 AS DischargeTime, 'prod'] [anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS PatGroup, anon_grp1.gcol2 AS Abbreviation, anon_grp1.gcol3 AS AdmissionTime, anon_grp1.gcol4 AS DischargeTime, 'prod'] LimitNode(33) output=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3, anon_grp1.gcol4] limit 100 GroupingNode(34) output=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3, anon_grp1.gcol4] [gd__1.AdmissionTime, gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, dd__1.DischargeTime]{anon_grp1.gcol0=gd__1.PatientID, anon_grp1.gcol1=gd__1.PatGroup, anon_grp1.gcol2=wr__1.Abbreviation, anon_grp1.gcol3=gd__1.AdmissionTime, anon_grp1.gcol4=dd__1.DischargeTime} JoinNode(35) [MERGE JOIN (ALREADY_SORTED/ALREADY_SORTED)] [SEMI JOIN] criteria=[gd__1.PatientID=pr.PatientID] output=[gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime] AccessNode(36) output=[gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime] SELECT DISTINCT g_0.PatientID AS c_0, g_0.PatGroup AS c_1, g_2.Abbreviation AS c_2, g_0.AdmissionTime AS c_3, g_1.DischargeTime AS c_4 FROM izisprod.prod_P_GeneralData AS g_0, izisprod.prod_P_DischargeData AS g_1, izisprod.prod_S_WardRef AS g_2 WHERE (g_0.PatientID = g_1.PatientID) AND (g_2.WardID = g_0.WardID) AND (g_0.Status >= 4) AND (g_0.Status <> 5) ORDER BY c_0 PlanExecutionNode(37) output=[pr.PatientID] ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: LimitNode(22) output=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin] limit 100 UnionAllNode(23) output=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin] ProjectNode(24) output=[anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin] [anon_grp0.gcol0 AS admissionid, anon_grp0.gcol1 AS patgroup, anon_grp0.gcol2 AS ward, anon_grp0.gcol3 AS admtime, anon_grp0.gcol4 AS distime, 'wh' AS origin] LimitNode(25) output=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.gcol2, anon_grp0.gcol3, anon_grp0.gcol4] limit 100 GroupingNode(26) output=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.gcol2, anon_grp0.gcol3, anon_grp0.gcol4] [gd.AdmissionTime, gd.PatientID, gd.PatGroup, wr.Abbreviation, dd.DischargeTime]{anon_grp0.gcol0=gd.PatientID, anon_grp0.gcol1=gd.PatGroup, anon_grp0.gcol2=wr.Abbreviation, anon_grp0.gcol3=gd.AdmissionTime, anon_grp0.gcol4=dd.DischargeTime} JoinNode(27) [Dependent] [ENHANCED SORT JOIN (ALREADY_SORTED/SORT)] [INNER JOIN] criteria=[wr.WardID=gd.WardID] output=[gd.PatientID, gd.PatGroup, wr.Abbreviation, gd.AdmissionTime, dd.DischargeTime] AccessNode(28) output=[wr.WardID, wr.Abbreviation] SELECT g_0.WardID AS c_0, g_0.Abbreviation AS c_1 FROM izisprod.prod_S_WardRef AS g_0 ORDER BY c_0 JoinNode(29) [MERGE JOIN (ALREADY_SORTED/ALREADY_SORTED)] [SEMI JOIN] criteria=[gd.PatientID=pr.PatientID] output=[gd.WardID, gd.PatientID, gd.PatGroup, gd.AdmissionTime, dd.DischargeTime] DependentAccessNode(30) output=[gd.PatientID, gd.WardID, gd.PatGroup, gd.AdmissionTime, dd.DischargeTime] SELECT DISTINCT g_0.PatientID AS c_0, g_0.WardID AS c_1, g_0.PatGroup AS c_2, g_0.AdmissionTime AS c_3, g_1.DischargeTime AS c_4 FROM iziswh.wh_P_GeneralData AS g_0, iziswh.wh_P_DischargeData AS g_1 WHERE (g_0.PatientID = g_1.PatientID) AND (g_0.WardID IN ()) ORDER BY c_0 PlanExecutionNode(31) output=[pr.PatientID] ProjectNode(32) output=[anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS PatGroup, anon_grp1.gcol2 AS Abbreviation, anon_grp1.gcol3 AS AdmissionTime, anon_grp1.gcol4 AS DischargeTime, 'prod'] [anon_grp1.gcol0 AS PatientID, anon_grp1.gcol1 AS PatGroup, anon_grp1.gcol2 AS Abbreviation, anon_grp1.gcol3 AS AdmissionTime, anon_grp1.gcol4 AS DischargeTime, 'prod'] LimitNode(33) output=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3, anon_grp1.gcol4] limit 100 GroupingNode(34) output=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3, anon_grp1.gcol4] [gd__1.AdmissionTime, gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, dd__1.DischargeTime]{anon_grp1.gcol0=gd__1.PatientID, anon_grp1.gcol1=gd__1.PatGroup, anon_grp1.gcol2=wr__1.Abbreviation, anon_grp1.gcol3=gd__1.AdmissionTime, anon_grp1.gcol4=dd__1.DischargeTime} JoinNode(35) [MERGE JOIN (ALREADY_SORTED/ALREADY_SORTED)] [SEMI JOIN] criteria=[gd__1.PatientID=pr.PatientID] output=[gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime] AccessNode(36) output=[gd__1.PatientID, gd__1.PatGroup, wr__1.Abbreviation, gd__1.AdmissionTime, dd__1.DischargeTime] SELECT DISTINCT g_0.PatientID AS c_0, g_0.PatGroup AS c_1, g_2.Abbreviation AS c_2, g_0.AdmissionTime AS c_3, g_1.DischargeTime AS c_4 FROM izisprod.prod_P_GeneralData AS g_0, izisprod.prod_P_DischargeData AS g_1, izisprod.prod_S_WardRef AS g_2 WHERE (g_0.PatientID = g_1.PatientID) AND (g_2.WardID = g_0.WardID) AND (g_0.Status >= 4) AND (g_0.Status <> 5) ORDER BY c_0 PlanExecutionNode(37) output=[pr.PatientID] ============================================================================/n