============================================================================ USER COMMAND: SELECT res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime FROM (((#tmp_results AS res INNER JOIN iziswh.wh_P_PharmaOrder AS po ON po.PatientID = res.admissionid AND po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart) AND po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart) AND po.Status <> 2) INNER JOIN iziswh.wh_P_Pharmas AS ph ON ph.OrderNumber = po.OrderNumber) INNER JOIN iziswh.wh_P_DailyOrderSchedule AS dos ON dos.OrderNumber = po.OrderNumber AND dos.PharmaID = ph.PharmaID) INNER JOIN izisprod.prod_S_PharmaRef AS pr ON pr.PharmaID = ph.PharmaID AND pr.GenericName = 'vancomycine hydrochloride' WHERE EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1) ORDER BY res.admissionid, res.periodgroup, po.OrderTime ---------------------------------------------------------------------------- OPTIMIZE: SELECT res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime FROM (((#tmp_results AS res INNER JOIN iziswh.wh_P_PharmaOrder AS po ON po.PatientID = res.admissionid AND po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart) AND po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart) AND po.Status <> 2) INNER JOIN iziswh.wh_P_Pharmas AS ph ON ph.OrderNumber = po.OrderNumber) INNER JOIN iziswh.wh_P_DailyOrderSchedule AS dos ON dos.OrderNumber = po.OrderNumber AND dos.PharmaID = ph.PharmaID) INNER JOIN izisprod.prod_S_PharmaRef AS pr ON pr.PharmaID = ph.PharmaID AND pr.GenericName = 'vancomycine hydrochloride' WHERE EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1) ORDER BY res.admissionid, res.periodgroup, po.OrderTime ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime FROM (((#tmp_results AS res INNER JOIN iziswh.wh_P_PharmaOrder AS po ON po.PatientID = res.admissionid AND po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart) AND po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart) AND po.Status <> 2) INNER JOIN iziswh.wh_P_Pharmas AS ph ON ph.OrderNumber = po.OrderNumber) INNER JOIN iziswh.wh_P_DailyOrderSchedule AS dos ON dos.OrderNumber = po.OrderNumber AND dos.PharmaID = ph.PharmaID) INNER JOIN izisprod.prod_S_PharmaRef AS pr ON pr.PharmaID = ph.PharmaID AND pr.GenericName = 'vancomycine hydrochloride' WHERE EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1) ORDER BY res.admissionid, res.periodgroup, po.OrderTime CANONICAL PLAN: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={SORT_ORDER=ORDER BY res.admissionid, res.periodgroup, po.OrderTime}) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos], props={PROJECT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime]}) Select(groups=[], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1)}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID, pr.GenericName = 'vancomycine hydrochloride']}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber, dos.PharmaID = ph.PharmaID]}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ph.OrderNumber = po.OrderNumber]}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart), po.Status <> 2]}) Source(groups=[#tmp_results AS res]) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Source(groups=[iziswh.wh_P_Pharmas AS ph]) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) ---------------------------------------------------------------------------- OPTIMIZE: SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1 ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1 CANONICAL PLAN: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1, IS_IMPLICIT_LIMIT=true}) Project(groups=[], props={PROJECT_COLS=[1]}) Select(groups=[iziswh.wh_P_PharmaRec AS phr], props={SELECT_CRITERIA=BITAND(convert(phr.Status, integer), 2) <> 2}) Select(groups=[iziswh.wh_P_PharmaRec AS phr], props={SELECT_CRITERIA=phr.PharmaID = ph.PharmaID}) Select(groups=[iziswh.wh_P_PharmaRec AS phr], props={SELECT_CRITERIA=phr.OrderNumber = ph.OrderNumber}) Source(groups=[iziswh.wh_P_PharmaRec AS phr]) ============================================================================ EXECUTING PlaceAccess AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1, IS_IMPLICIT_LIMIT=true}) Project(groups=[], props={PROJECT_COLS=[1]}) Select(groups=[iziswh.wh_P_PharmaRec AS phr], props={SELECT_CRITERIA=BITAND(convert(phr.Status, integer), 2) <> 2}) Select(groups=[iziswh.wh_P_PharmaRec AS phr], props={SELECT_CRITERIA=phr.PharmaID = ph.PharmaID}) Select(groups=[iziswh.wh_P_PharmaRec AS phr], props={SELECT_CRITERIA=phr.OrderNumber = ph.OrderNumber}) Access(groups=[iziswh.wh_P_PharmaRec AS phr], 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 phr]) ============================================================================ EXECUTING PushSelectCriteria AFTER: TupleLimit(groups=[]) Project(groups=[], props={PROJECT_COLS=[1]}) Select(groups=[iziswh.wh_P_PharmaRec AS phr], props={SELECT_CRITERIA=BITAND(convert(phr.Status, integer), 2) <> 2}) Access(groups=[iziswh.wh_P_PharmaRec AS phr], 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 phr], props={SELECT_CRITERIA=(phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID)}) Source(groups=[iziswh.wh_P_PharmaRec AS phr]) ============================================================================ EXECUTING CleanCriteria AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=null}) Project(groups=[], props={PROJECT_COLS=[1], OUTPUT_COLS=null}) Select(groups=[iziswh.wh_P_PharmaRec AS phr], props={SELECT_CRITERIA=BITAND(convert(phr.Status, integer), 2) <> 2, OUTPUT_COLS=null}) Access(groups=[iziswh.wh_P_PharmaRec AS phr], 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 phr], props={SELECT_CRITERIA=(phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID), OUTPUT_COLS=null}) Source(groups=[iziswh.wh_P_PharmaRec AS phr], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING RaiseAccess LOW Relational Planner BITAND function not supported by source iziswh - BITAND(convert(phr.Status, integer), 2) was not pushed AFTER: TupleLimit(groups=[]) Project(groups=[]) Select(groups=[iziswh.wh_P_PharmaRec AS phr], props={SELECT_CRITERIA=BITAND(convert(phr.Status, integer), 2) <> 2, OUTPUT_COLS=null}) Access(groups=[iziswh.wh_P_PharmaRec AS phr], 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 phr]) Source(groups=[iziswh.wh_P_PharmaRec AS phr]) ============================================================================ EXECUTING PushLimit AFTER: Project(groups=[], props={PROJECT_COLS=[1], OUTPUT_COLS=null, SOURCE_HINT=null}) TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=null}) Select(groups=[iziswh.wh_P_PharmaRec AS phr], props={SELECT_CRITERIA=BITAND(convert(phr.Status, integer), 2) <> 2, OUTPUT_COLS=null}) Access(groups=[iziswh.wh_P_PharmaRec AS phr]) Select(groups=[iziswh.wh_P_PharmaRec AS phr]) Source(groups=[iziswh.wh_P_PharmaRec AS phr]) ============================================================================ EXECUTING AssignOutputElements AFTER: Project(groups=[], props={PROJECT_COLS=[1], OUTPUT_COLS=[1], SOURCE_HINT=null}) TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[]}) Select(groups=[iziswh.wh_P_PharmaRec AS phr], props={SELECT_CRITERIA=BITAND(convert(phr.Status, integer), 2) <> 2, OUTPUT_COLS=[]}) Access(groups=[iziswh.wh_P_PharmaRec AS phr], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[phr.Status]}) Select(groups=[iziswh.wh_P_PharmaRec AS phr], props={SELECT_CRITERIA=(phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID), OUTPUT_COLS=[phr.Status]}) Source(groups=[iziswh.wh_P_PharmaRec AS phr], props={OUTPUT_COLS=[phr.OrderNumber, phr.PharmaID, phr.Status]}) ============================================================================ EXECUTING CalculateCost AFTER: Project(groups=[], props={PROJECT_COLS=[1], OUTPUT_COLS=[1], SOURCE_HINT=null, EST_CARDINALITY=1.0, EST_COL_STATS={1=[1.0, 1.0]}}) TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[], EST_CARDINALITY=1.0, EST_COL_STATS={}}) Select(groups=[iziswh.wh_P_PharmaRec AS phr], props={SELECT_CRITERIA=BITAND(convert(phr.Status, integer), 2) <> 2, OUTPUT_COLS=[], EST_CARDINALITY=1.0, EST_COL_STATS={}}) Access(groups=[iziswh.wh_P_PharmaRec AS phr], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[phr.Status], EST_CARDINALITY=3.9980574, EST_COL_STATS={phr.Status=[-1.0, -1.0]}}) Select(groups=[iziswh.wh_P_PharmaRec AS phr], props={SELECT_CRITERIA=(phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID), OUTPUT_COLS=[phr.Status], EST_CARDINALITY=3.9980574, EST_COL_STATS={phr.Status=[-1.0, -1.0]}}) Source(groups=[iziswh.wh_P_PharmaRec AS phr], props={OUTPUT_COLS=[phr.OrderNumber, phr.PharmaID, phr.Status], EST_COL_STATS={phr.OrderNumber=[-1.0, -1.0], phr.PharmaID=[-1.0, -1.0], phr.Status=[-1.0, -1.0]}, EST_CARDINALITY=5.5E7}) ============================================================================ EXECUTING MergeCriteria AFTER: Project(groups=[]) TupleLimit(groups=[]) Select(groups=[iziswh.wh_P_PharmaRec AS phr], props={SELECT_CRITERIA=BITAND(convert(phr.Status, integer), 2) <> 2, OUTPUT_COLS=[], EST_CARDINALITY=1.0, EST_COL_STATS={}}) Access(groups=[iziswh.wh_P_PharmaRec AS phr], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[phr.Status], EST_CARDINALITY=3.9980574, EST_COL_STATS={phr.Status=[-1.0, -1.0]}}) Select(groups=[iziswh.wh_P_PharmaRec AS phr], props={SELECT_CRITERIA=(phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID), OUTPUT_COLS=[phr.Status], EST_CARDINALITY=3.9980574, EST_COL_STATS={phr.Status=[-1.0, -1.0]}}) Source(groups=[iziswh.wh_P_PharmaRec AS phr], props={OUTPUT_COLS=[phr.OrderNumber, phr.PharmaID, phr.Status], EST_COL_STATS={phr.OrderNumber=[-1.0, -1.0], phr.PharmaID=[-1.0, -1.0], phr.Status=[-1.0, -1.0]}, EST_CARDINALITY=5.5E7}) ============================================================================ EXECUTING PlanSorts AFTER: Project(groups=[]) TupleLimit(groups=[]) Select(groups=[iziswh.wh_P_PharmaRec AS phr]) Access(groups=[iziswh.wh_P_PharmaRec AS phr]) Select(groups=[iziswh.wh_P_PharmaRec AS phr]) Source(groups=[iziswh.wh_P_PharmaRec AS phr]) ============================================================================ EXECUTING CollapseSource AFTER: Project(groups=[]) TupleLimit(groups=[]) Select(groups=[iziswh.wh_P_PharmaRec AS phr]) Access(groups=[iziswh.wh_P_PharmaRec AS phr], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[phr.Status], EST_CARDINALITY=3.9980574, EST_COL_STATS={phr.Status=[-1.0, -1.0]}, ATOMIC_REQUEST=SELECT phr.Status FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID)}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = ProjectNode(0) output=[1] [1] LimitNode(1) output=[] limit 1 SelectNode(2) output=[] BITAND(convert(phr.Status, integer), 2) <> 2 AccessNode(3) output=[phr.Status] SELECT g_0.Status FROM iziswh.wh_P_PharmaRec AS g_0 WHERE (g_0.OrderNumber = ph.OrderNumber) AND (g_0.PharmaID = ph.PharmaID) ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: ProjectNode(0) output=[1] [1] LimitNode(1) output=[] limit 1 SelectNode(2) output=[] BITAND(convert(phr.Status, integer), 2) <> 2 AccessNode(3) output=[phr.Status] SELECT g_0.Status FROM iziswh.wh_P_PharmaRec AS g_0 WHERE (g_0.OrderNumber = ph.OrderNumber) AND (g_0.PharmaID = ph.PharmaID) ============================================================================ ============================================================================ EXECUTING PlaceAccess AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={SORT_ORDER=ORDER BY res.admissionid, res.periodgroup, po.OrderTime}) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos], props={PROJECT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime]}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1)}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID, pr.GenericName = 'vancomycine hydrochloride']}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber, dos.PharmaID = ph.PharmaID]}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ph.OrderNumber = po.OrderNumber]}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart), po.Status <> 2]}) Access(groups=[#tmp_results AS res], props={SOURCE_HINT=null, MODEL_ID=__TEMP__}) Source(groups=[#tmp_results AS res]) Access(groups=[iziswh.wh_P_PharmaOrder AS po], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac}) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Access(groups=[iziswh.wh_P_Pharmas AS ph], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac}) Source(groups=[iziswh.wh_P_Pharmas AS ph]) Access(groups=[iziswh.wh_P_DailyOrderSchedule AS dos], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac}) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Access(groups=[izisprod.prod_S_PharmaRef AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04}) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) ============================================================================ EXECUTING PushSelectCriteria AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos], props={PROJECT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime]}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID, pr.GenericName = 'vancomycine hydrochloride']}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber, dos.PharmaID = ph.PharmaID]}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ph.OrderNumber = po.OrderNumber]}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Access(groups=[#tmp_results AS res]) Source(groups=[#tmp_results AS res]) Access(groups=[iziswh.wh_P_PharmaOrder AS po]) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1)}) Access(groups=[iziswh.wh_P_Pharmas AS ph], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac}) Source(groups=[iziswh.wh_P_Pharmas AS ph]) Access(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Access(groups=[izisprod.prod_S_PharmaRef AS pr]) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) ============================================================================ EXECUTING PushNonJoinCriteria AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID]}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber, dos.PharmaID = ph.PharmaID]}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ph.OrderNumber = po.OrderNumber]}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)]}) Access(groups=[#tmp_results AS res]) Source(groups=[#tmp_results AS res]) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.Status <> 2}) Access(groups=[iziswh.wh_P_PharmaOrder AS po], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac}) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Select(groups=[iziswh.wh_P_Pharmas AS ph]) Access(groups=[iziswh.wh_P_Pharmas AS ph]) Source(groups=[iziswh.wh_P_Pharmas AS ph]) Access(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Select(groups=[izisprod.prod_S_PharmaRef AS pr], props={SELECT_CRITERIA=pr.GenericName = 'vancomycine hydrochloride'}) Access(groups=[izisprod.prod_S_PharmaRef AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04}) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) ============================================================================ EXECUTING PushSelectCriteria AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID]}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ph.OrderNumber = po.OrderNumber]}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)]}) Access(groups=[#tmp_results AS res]) Source(groups=[#tmp_results AS res]) Access(groups=[iziswh.wh_P_PharmaOrder AS po], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac}) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.Status <> 2}) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1)}) Access(groups=[iziswh.wh_P_Pharmas AS ph], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac}) Source(groups=[iziswh.wh_P_Pharmas AS ph]) Access(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Access(groups=[izisprod.prod_S_PharmaRef AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04}) Select(groups=[izisprod.prod_S_PharmaRef AS pr], props={SELECT_CRITERIA=pr.GenericName = 'vancomycine hydrochloride'}) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) ============================================================================ EXECUTING CleanCriteria AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={SORT_ORDER=ORDER BY res.admissionid, res.periodgroup, po.OrderTime, OUTPUT_COLS=null}) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos], props={PROJECT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], OUTPUT_COLS=null}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID], OUTPUT_COLS=null}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber, dos.PharmaID = ph.PharmaID], OUTPUT_COLS=null}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ph.OrderNumber = po.OrderNumber], OUTPUT_COLS=null}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], OUTPUT_COLS=null}) Access(groups=[#tmp_results AS res], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null}) Source(groups=[#tmp_results AS res], props={OUTPUT_COLS=null}) Access(groups=[iziswh.wh_P_PharmaOrder AS po], 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_PharmaOrder AS po], props={SELECT_CRITERIA=po.Status <> 2, OUTPUT_COLS=null}) Source(groups=[iziswh.wh_P_PharmaOrder AS po], props={OUTPUT_COLS=null}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1), OUTPUT_COLS=null}) Access(groups=[iziswh.wh_P_Pharmas AS ph], 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_Pharmas AS ph], props={OUTPUT_COLS=null}) Access(groups=[iziswh.wh_P_DailyOrderSchedule AS dos], 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_DailyOrderSchedule AS dos], props={OUTPUT_COLS=null}) Access(groups=[izisprod.prod_S_PharmaRef AS pr], 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_S_PharmaRef AS pr], props={SELECT_CRITERIA=pr.GenericName = 'vancomycine hydrochloride', OUTPUT_COLS=null}) Source(groups=[izisprod.prod_S_PharmaRef AS pr], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING RaiseAccess LOW Relational Planner Subquery cannot be pushed down iziswh - SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1 was not pushed AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID], OUTPUT_COLS=null}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber, dos.PharmaID = ph.PharmaID], OUTPUT_COLS=null}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ph.OrderNumber = po.OrderNumber], OUTPUT_COLS=null}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], OUTPUT_COLS=null}) Access(groups=[#tmp_results AS res], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null}) Source(groups=[#tmp_results AS res]) Access(groups=[iziswh.wh_P_PharmaOrder AS po], 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_PharmaOrder AS po]) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1), OUTPUT_COLS=null}) Access(groups=[iziswh.wh_P_Pharmas AS ph], 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_Pharmas AS ph]) Access(groups=[iziswh.wh_P_DailyOrderSchedule AS dos], 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_DailyOrderSchedule AS dos]) Access(groups=[izisprod.prod_S_PharmaRef AS pr], 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_S_PharmaRef AS pr]) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) ============================================================================ EXECUTING CopyCriteria AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID, dos.PharmaID = pr.PharmaID], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber, dos.PharmaID = ph.PharmaID, ph.OrderNumber = dos.OrderNumber], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ph.OrderNumber = po.OrderNumber], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[#tmp_results AS res]) Source(groups=[#tmp_results AS res]) Access(groups=[iziswh.wh_P_PharmaOrder AS po]) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.Status <> 2, OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1), OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[iziswh.wh_P_Pharmas AS ph]) Source(groups=[iziswh.wh_P_Pharmas AS ph]) Access(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Access(groups=[izisprod.prod_S_PharmaRef AS pr]) Select(groups=[izisprod.prod_S_PharmaRef AS pr], props={SELECT_CRITERIA=pr.GenericName = 'vancomycine hydrochloride', OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) ============================================================================ EXECUTING PushNonJoinCriteria AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID, dos.PharmaID = pr.PharmaID], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber, dos.PharmaID = ph.PharmaID, ph.OrderNumber = dos.OrderNumber], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ph.OrderNumber = po.OrderNumber], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[#tmp_results AS res]) Source(groups=[#tmp_results AS res]) Access(groups=[iziswh.wh_P_PharmaOrder AS po]) Select(groups=[iziswh.wh_P_PharmaOrder AS po]) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Select(groups=[iziswh.wh_P_Pharmas AS ph]) Access(groups=[iziswh.wh_P_Pharmas AS ph]) Source(groups=[iziswh.wh_P_Pharmas AS ph]) Access(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Access(groups=[izisprod.prod_S_PharmaRef AS pr]) Select(groups=[izisprod.prod_S_PharmaRef AS pr]) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) ============================================================================ EXECUTING RaiseAccess LOW Relational Planner Subquery cannot be pushed down iziswh - SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1 was not pushed AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID, dos.PharmaID = pr.PharmaID], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber, dos.PharmaID = ph.PharmaID, ph.OrderNumber = dos.OrderNumber], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ph.OrderNumber = po.OrderNumber], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[#tmp_results AS res], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null}) Source(groups=[#tmp_results AS res]) Access(groups=[iziswh.wh_P_PharmaOrder AS po], 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_PharmaOrder AS po]) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1), OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[iziswh.wh_P_Pharmas AS ph], 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_Pharmas AS ph]) Access(groups=[iziswh.wh_P_DailyOrderSchedule AS dos], 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_DailyOrderSchedule AS dos]) Access(groups=[izisprod.prod_S_PharmaRef AS pr], 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_S_PharmaRef AS pr]) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) ============================================================================ EXECUTING CopyCriteria AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID, dos.PharmaID = pr.PharmaID], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber, dos.PharmaID = ph.PharmaID, ph.OrderNumber = dos.OrderNumber], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ph.OrderNumber = po.OrderNumber], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[#tmp_results AS res]) Source(groups=[#tmp_results AS res]) Access(groups=[iziswh.wh_P_PharmaOrder AS po]) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.Status <> 2, OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1), OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[iziswh.wh_P_Pharmas AS ph]) Source(groups=[iziswh.wh_P_Pharmas AS ph]) Access(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Access(groups=[izisprod.prod_S_PharmaRef AS pr]) Select(groups=[izisprod.prod_S_PharmaRef AS pr], props={SELECT_CRITERIA=pr.GenericName = 'vancomycine hydrochloride', OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) ============================================================================ EXECUTING CleanCriteria AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={SORT_ORDER=ORDER BY res.admissionid, res.periodgroup, po.OrderTime, OUTPUT_COLS=null}) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos], props={PROJECT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], OUTPUT_COLS=null}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos, izisprod.prod_S_PharmaRef AS pr], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID, dos.PharmaID = pr.PharmaID], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber, dos.PharmaID = ph.PharmaID, ph.OrderNumber = dos.OrderNumber], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ph.OrderNumber = po.OrderNumber], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[#tmp_results AS res], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null}) Source(groups=[#tmp_results AS res], props={OUTPUT_COLS=null}) Access(groups=[iziswh.wh_P_PharmaOrder AS po], 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_PharmaOrder AS po], props={SELECT_CRITERIA=po.Status <> 2, OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[iziswh.wh_P_PharmaOrder AS po], props={OUTPUT_COLS=null}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1), OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[iziswh.wh_P_Pharmas AS ph], 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_Pharmas AS ph], props={OUTPUT_COLS=null}) Access(groups=[iziswh.wh_P_DailyOrderSchedule AS dos], 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_DailyOrderSchedule AS dos], props={OUTPUT_COLS=null}) Access(groups=[izisprod.prod_S_PharmaRef AS pr], 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_S_PharmaRef AS pr], props={SELECT_CRITERIA=pr.GenericName = 'vancomycine hydrochloride', OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[izisprod.prod_S_PharmaRef AS pr], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING PlanJoins AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos], props={PROJECT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], OUTPUT_COLS=null}) Select(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart), EST_SELECTIVITY=0.33333334}) Select(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), EST_SELECTIVITY=0.33333334}) Select(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.PatientID = res.admissionid, EST_SELECTIVITY=0.12577777}) Select(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=ph.OrderNumber = po.OrderNumber, EST_SELECTIVITY=0.037}) Select(groups=[iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={SELECT_CRITERIA=ph.OrderNumber = dos.OrderNumber, EST_SELECTIVITY=0.12577777}) Select(groups=[iziswh.wh_P_Pharmas AS ph, iziswh.wh_P_DailyOrderSchedule AS dos], props={SELECT_CRITERIA=dos.PharmaID = ph.PharmaID, EST_SELECTIVITY=0.12577777}) Select(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos], props={SELECT_CRITERIA=dos.PharmaID = pr.PharmaID, EST_SELECTIVITY=0.12577777}) Select(groups=[iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr], props={SELECT_CRITERIA=pr.PharmaID = ph.PharmaID, EST_SELECTIVITY=0.12577777}) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos, #tmp_results AS res, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP}) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos, #tmp_results AS res], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP}) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP}) Access(groups=[izisprod.prod_S_PharmaRef AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null, EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Select(groups=[izisprod.prod_S_PharmaRef AS pr], props={SELECT_CRITERIA=pr.GenericName = 'vancomycine hydrochloride', OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Source(groups=[izisprod.prod_S_PharmaRef AS pr], props={OUTPUT_COLS=null, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}, EST_CARDINALITY=1900.0}) Access(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos], 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=2447758.5, EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}}) Join(groups=[iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber], MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, EST_CARDINALITY=2447758.5, EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}}) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.Status <> 2, OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=1997175.1, EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_PharmaOrder AS po], props={OUTPUT_COLS=null, EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}, EST_CARDINALITY=2000000.0}) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos], props={OUTPUT_COLS=null, EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}, EST_CARDINALITY=3000000.0}) Access(groups=[#tmp_results AS res], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null, EST_CARDINALITY=419.0, EST_COL_STATS={res.adrema=[-1.0, -1.0], res.episode=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}}) Source(groups=[#tmp_results AS res], props={OUTPUT_COLS=null, EST_COL_STATS={res.adrema=[-1.0, -1.0], res.episode=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}, EST_CARDINALITY=419.0}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}}) Access(groups=[iziswh.wh_P_Pharmas AS ph], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null, EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_Pharmas AS ph], props={OUTPUT_COLS=null, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}, EST_CARDINALITY=3000000.0}) ============================================================================ EXECUTING PushSelectCriteria AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos], props={PROJECT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], OUTPUT_COLS=null}) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos, #tmp_results AS res, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID, dos.PharmaID = ph.PharmaID, ph.OrderNumber = dos.OrderNumber, ph.OrderNumber = po.OrderNumber]}) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos, #tmp_results AS res], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)]}) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.PharmaID = pr.PharmaID]}) Access(groups=[izisprod.prod_S_PharmaRef AS pr]) Select(groups=[izisprod.prod_S_PharmaRef AS pr], props={SELECT_CRITERIA=pr.GenericName = 'vancomycine hydrochloride', OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) Access(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_PharmaOrder AS po]) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.Status <> 2, OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=1997175.1, EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Access(groups=[#tmp_results AS res]) Source(groups=[#tmp_results AS res]) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}}) Access(groups=[iziswh.wh_P_Pharmas AS ph]) Source(groups=[iziswh.wh_P_Pharmas AS ph]) ============================================================================ EXECUTING RaiseAccess LOW Relational Planner Subquery cannot be pushed down iziswh - SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1 was not pushed AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos, #tmp_results AS res, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID, dos.PharmaID = ph.PharmaID, ph.OrderNumber = dos.OrderNumber, ph.OrderNumber = po.OrderNumber]}) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos, #tmp_results AS res], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)]}) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.PharmaID = pr.PharmaID]}) Access(groups=[izisprod.prod_S_PharmaRef AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null, EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Select(groups=[izisprod.prod_S_PharmaRef AS pr]) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) Access(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos], 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=2447758.5, EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}}) Join(groups=[iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_PharmaOrder AS po]) Select(groups=[iziswh.wh_P_PharmaOrder AS po]) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Access(groups=[#tmp_results AS res], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null, EST_CARDINALITY=419.0, EST_COL_STATS={res.adrema=[-1.0, -1.0], res.episode=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}}) Source(groups=[#tmp_results AS res]) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}}) Access(groups=[iziswh.wh_P_Pharmas AS ph], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null, EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_Pharmas AS ph]) ============================================================================ EXECUTING ChooseJoinStrategy AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos, #tmp_results AS res, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID, dos.PharmaID = ph.PharmaID, ph.OrderNumber = po.OrderNumber], LEFT_EXPRESSIONS=[pr.PharmaID, dos.PharmaID, po.OrderNumber], RIGHT_EXPRESSIONS=[ph.PharmaID, ph.PharmaID, ph.OrderNumber], NON_EQUI_JOIN_CRITERIA=[]}) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos, #tmp_results AS res], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], LEFT_EXPRESSIONS=[po.PatientID], RIGHT_EXPRESSIONS=[res.admissionid], NON_EQUI_JOIN_CRITERIA=[po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)]}) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[]}) Access(groups=[izisprod.prod_S_PharmaRef AS pr]) Select(groups=[izisprod.prod_S_PharmaRef AS pr]) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) Access(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_PharmaOrder AS po]) Select(groups=[iziswh.wh_P_PharmaOrder AS po]) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Access(groups=[#tmp_results AS res]) Source(groups=[#tmp_results AS res]) Select(groups=[iziswh.wh_P_Pharmas AS ph]) Access(groups=[iziswh.wh_P_Pharmas AS ph]) Source(groups=[iziswh.wh_P_Pharmas AS ph]) ============================================================================ EXECUTING ChooseDependent LOW Relational Planner parent join is CROSS - Rejecting dependent join Access(groups=[izisprod.prod_S_PharmaRef AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null, EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}} LOW Relational Planner parent join is CROSS - Rejecting dependent join Access(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos], 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=2447758.5, EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}} AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos, #tmp_results AS res, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID, dos.PharmaID = ph.PharmaID, ph.OrderNumber = po.OrderNumber], LEFT_EXPRESSIONS=[pr.PharmaID, dos.PharmaID, po.OrderNumber], RIGHT_EXPRESSIONS=[ph.PharmaID, ph.PharmaID, ph.OrderNumber], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null, DEPENDENT_VALUE_SOURCE=$dsc/id8389}) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos, #tmp_results AS res], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], LEFT_EXPRESSIONS=[res.admissionid], RIGHT_EXPRESSIONS=[po.PatientID], NON_EQUI_JOIN_CRITERIA=[po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], EST_CARDINALITY=132272.31, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}, DEPENDENT_VALUE_SOURCE=$dsc/id8390}) Access(groups=[#tmp_results AS res], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null, EST_CARDINALITY=419.0, EST_COL_STATS={res.adrema=[-1.0, -1.0], res.episode=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}}) Source(groups=[#tmp_results AS res], props={OUTPUT_COLS=null, EST_COL_STATS={res.adrema=[-1.0, -1.0], res.episode=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}, EST_CARDINALITY=419.0}) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.PatientID IN (), IS_DEPENDENT_SET=true}) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], EST_CARDINALITY=2.11397328E8, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Access(groups=[izisprod.prod_S_PharmaRef AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null, EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Select(groups=[izisprod.prod_S_PharmaRef AS pr], props={SELECT_CRITERIA=pr.GenericName = 'vancomycine hydrochloride', OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Source(groups=[izisprod.prod_S_PharmaRef AS pr], props={OUTPUT_COLS=null, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}, EST_CARDINALITY=1900.0}) Access(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos], 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=2447758.5, EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}}) Join(groups=[iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber], MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, EST_CARDINALITY=2447758.5, EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}}) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.Status <> 2, OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=1997175.1, EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_PharmaOrder AS po], props={OUTPUT_COLS=null, EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}, EST_CARDINALITY=2000000.0}) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos], props={OUTPUT_COLS=null, EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}, EST_CARDINALITY=3000000.0}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=(ph.PharmaID, ph.PharmaID, ph.OrderNumber) IN (), IS_DEPENDENT_SET=true}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}}) Access(groups=[iziswh.wh_P_Pharmas AS ph], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null, EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_Pharmas AS ph], props={OUTPUT_COLS=null, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}, EST_CARDINALITY=3000000.0}) ============================================================================ EXECUTING PushSelectCriteria AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos, #tmp_results AS res, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID, dos.PharmaID = ph.PharmaID, ph.OrderNumber = po.OrderNumber], LEFT_EXPRESSIONS=[pr.PharmaID, dos.PharmaID, po.OrderNumber], RIGHT_EXPRESSIONS=[ph.PharmaID, ph.PharmaID, ph.OrderNumber], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null, DEPENDENT_VALUE_SOURCE=$dsc/id8389}) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos, #tmp_results AS res], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], LEFT_EXPRESSIONS=[res.admissionid], RIGHT_EXPRESSIONS=[po.PatientID], NON_EQUI_JOIN_CRITERIA=[po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], EST_CARDINALITY=132272.31, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}, DEPENDENT_VALUE_SOURCE=$dsc/id8390}) Access(groups=[#tmp_results AS res]) Source(groups=[#tmp_results AS res]) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], EST_CARDINALITY=2.11397328E8, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Access(groups=[izisprod.prod_S_PharmaRef AS pr]) Select(groups=[izisprod.prod_S_PharmaRef AS pr], props={SELECT_CRITERIA=pr.GenericName = 'vancomycine hydrochloride', OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) Access(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos], 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=2447758.5, EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.PatientID IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true}) Join(groups=[iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber], MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, EST_CARDINALITY=2447758.5, EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}}) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.Status <> 2, OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=1997175.1, EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}}) Access(groups=[iziswh.wh_P_Pharmas AS ph], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null, EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=(ph.PharmaID IN ()) AND (ph.PharmaID IN ()) AND (ph.OrderNumber IN ()), IS_DEPENDENT_SET=true, IS_PUSHED=true}) Source(groups=[iziswh.wh_P_Pharmas AS ph], props={OUTPUT_COLS=null, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}, EST_CARDINALITY=3000000.0}) ============================================================================ EXECUTING CleanCriteria AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={SORT_ORDER=ORDER BY res.admissionid, res.periodgroup, po.OrderTime, OUTPUT_COLS=null}) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos], props={PROJECT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], OUTPUT_COLS=null}) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos, #tmp_results AS res, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID, dos.PharmaID = ph.PharmaID, ph.OrderNumber = po.OrderNumber], LEFT_EXPRESSIONS=[pr.PharmaID, dos.PharmaID, po.OrderNumber], RIGHT_EXPRESSIONS=[ph.PharmaID, ph.PharmaID, ph.OrderNumber], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null, DEPENDENT_VALUE_SOURCE=$dsc/id8389, OUTPUT_COLS=null}) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos, #tmp_results AS res], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], LEFT_EXPRESSIONS=[res.admissionid], RIGHT_EXPRESSIONS=[po.PatientID], NON_EQUI_JOIN_CRITERIA=[po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], EST_CARDINALITY=132272.31, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}, DEPENDENT_VALUE_SOURCE=$dsc/id8390, OUTPUT_COLS=null}) Access(groups=[#tmp_results AS res], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null, EST_CARDINALITY=419.0, EST_COL_STATS={res.adrema=[-1.0, -1.0], res.episode=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}}) Source(groups=[#tmp_results AS res], props={OUTPUT_COLS=null, EST_COL_STATS={res.adrema=[-1.0, -1.0], res.episode=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}, EST_CARDINALITY=419.0}) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], EST_CARDINALITY=2.11397328E8, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}, OUTPUT_COLS=null}) Access(groups=[izisprod.prod_S_PharmaRef AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=null, EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Select(groups=[izisprod.prod_S_PharmaRef AS pr], props={SELECT_CRITERIA=pr.GenericName = 'vancomycine hydrochloride', OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Source(groups=[izisprod.prod_S_PharmaRef AS pr], props={OUTPUT_COLS=null, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}, EST_CARDINALITY=1900.0}) Access(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos], 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=2447758.5, EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.PatientID IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=null}) Join(groups=[iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber], MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, EST_CARDINALITY=2447758.5, EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}, OUTPUT_COLS=null}) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.Status <> 2, OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=1997175.1, EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_PharmaOrder AS po], props={OUTPUT_COLS=null, EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}, EST_CARDINALITY=2000000.0}) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos], props={OUTPUT_COLS=null, EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}, EST_CARDINALITY=3000000.0}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}}) Access(groups=[iziswh.wh_P_Pharmas AS ph], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=null, EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=(ph.PharmaID IN ()) AND (ph.PharmaID IN ()) AND (ph.OrderNumber IN ()), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=null}) Source(groups=[iziswh.wh_P_Pharmas AS ph], props={OUTPUT_COLS=null, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}, EST_CARDINALITY=3000000.0}) ============================================================================ EXECUTING AssignOutputElements AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={SORT_ORDER=ORDER BY res.admissionid, res.periodgroup, po.OrderTime, OUTPUT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], UNRELATED_SORT=false}) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos], props={PROJECT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], OUTPUT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime]}) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos, #tmp_results AS res, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID, dos.PharmaID = ph.PharmaID, ph.OrderNumber = po.OrderNumber], LEFT_EXPRESSIONS=[pr.PharmaID, dos.PharmaID, po.OrderNumber], RIGHT_EXPRESSIONS=[ph.PharmaID, ph.PharmaID, ph.OrderNumber], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null, DEPENDENT_VALUE_SOURCE=$dsc/id8389, OUTPUT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime]}) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos, #tmp_results AS res], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], LEFT_EXPRESSIONS=[res.admissionid], RIGHT_EXPRESSIONS=[po.PatientID], NON_EQUI_JOIN_CRITERIA=[po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], EST_CARDINALITY=132272.31, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}, DEPENDENT_VALUE_SOURCE=$dsc/id8390, OUTPUT_COLS=[pr.PharmaID, dos.PharmaID, po.OrderNumber, res.admissionid, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PlannedTime]}) Access(groups=[#tmp_results AS res], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[res.admissionid, res.periodstart, res.periodgroup, res.periodend], EST_CARDINALITY=419.0, EST_COL_STATS={res.adrema=[-1.0, -1.0], res.episode=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}}) Source(groups=[#tmp_results AS res], props={OUTPUT_COLS=[res.admissionid, res.periodstart, res.periodgroup, res.periodend], EST_COL_STATS={res.adrema=[-1.0, -1.0], res.episode=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}, EST_CARDINALITY=419.0}) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], EST_CARDINALITY=2.11397328E8, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}, OUTPUT_COLS=[po.PatientID, po.StartTime, pr.PharmaID, dos.PharmaID, po.OrderNumber, po.OrderTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PlannedTime]}) Access(groups=[izisprod.prod_S_PharmaRef AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[pr.PharmaID, pr.PharmaName], EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Select(groups=[izisprod.prod_S_PharmaRef AS pr], props={SELECT_CRITERIA=pr.GenericName = 'vancomycine hydrochloride', OUTPUT_COLS=[pr.PharmaID, pr.PharmaName], IS_COPIED=true, EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Source(groups=[izisprod.prod_S_PharmaRef AS pr], props={OUTPUT_COLS=[pr.GenericName, pr.PharmaID, pr.PharmaName], EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}, EST_CARDINALITY=1900.0}) Access(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[po.PatientID, po.StartTime, dos.PharmaID, po.OrderNumber, po.OrderTime, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PlannedTime], CONFORMED_SOURCES=null, EST_CARDINALITY=2447758.5, EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.PatientID IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[po.PatientID, po.StartTime, dos.PharmaID, po.OrderNumber, po.OrderTime, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PlannedTime]}) Join(groups=[iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber], MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, EST_CARDINALITY=2447758.5, EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}, OUTPUT_COLS=[po.PatientID, po.StartTime, dos.PharmaID, po.OrderNumber, po.OrderTime, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PlannedTime]}) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.Status <> 2, OUTPUT_COLS=[po.OrderNumber, po.PatientID, po.StartTime, po.OrderTime], IS_COPIED=true, EST_CARDINALITY=1997175.1, EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_PharmaOrder AS po], props={OUTPUT_COLS=[po.Status, po.OrderNumber, po.PatientID, po.StartTime, po.OrderTime], EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}, EST_CARDINALITY=2000000.0}) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos], props={OUTPUT_COLS=[dos.OrderNumber, dos.PharmaID, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.PatientID, dos.PlannedTime], EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}, EST_CARDINALITY=3000000.0}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1), OUTPUT_COLS=[ph.PharmaID, ph.OrderNumber], IS_COPIED=true, EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}}) Access(groups=[iziswh.wh_P_Pharmas AS ph], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[ph.OrderNumber, ph.PharmaID], EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=(ph.PharmaID IN ()) AND (ph.PharmaID IN ()) AND (ph.OrderNumber IN ()), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[ph.OrderNumber, ph.PharmaID]}) Source(groups=[iziswh.wh_P_Pharmas AS ph], props={OUTPUT_COLS=[ph.PharmaID, ph.OrderNumber], EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}, EST_CARDINALITY=3000000.0}) ============================================================================ EXECUTING CalculateCost AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={SORT_ORDER=ORDER BY res.admissionid, res.periodgroup, po.OrderTime, OUTPUT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], UNRELATED_SORT=false, EST_CARDINALITY=1.0, EST_COL_STATS={res.admissionid=[-1.0, -1.0], ph.PharmaID=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}}) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos], props={PROJECT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], OUTPUT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], EST_CARDINALITY=1.0, EST_COL_STATS={res.admissionid=[-1.0, -1.0], ph.PharmaID=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}}) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos, #tmp_results AS res, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID, dos.PharmaID = ph.PharmaID, ph.OrderNumber = po.OrderNumber], LEFT_EXPRESSIONS=[pr.PharmaID, dos.PharmaID, po.OrderNumber], RIGHT_EXPRESSIONS=[ph.PharmaID, ph.PharmaID, ph.OrderNumber], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=1.0, DEPENDENT_VALUE_SOURCE=$dsc/id8389, OUTPUT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], EST_COL_STATS={res.admissionid=[-1.0, -1.0], ph.PharmaID=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}}) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos, #tmp_results AS res], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], LEFT_EXPRESSIONS=[res.admissionid], RIGHT_EXPRESSIONS=[po.PatientID], NON_EQUI_JOIN_CRITERIA=[po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], EST_CARDINALITY=68419.38, EST_COL_STATS={pr.PharmaID=[-1.0, -1.0], dos.PharmaID=[-1.0, -1.0], po.OrderNumber=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], ...}, DEPENDENT_VALUE_SOURCE=$dsc/id8390, OUTPUT_COLS=[pr.PharmaID, dos.PharmaID, po.OrderNumber, res.admissionid, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PlannedTime]}) Access(groups=[#tmp_results AS res], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[res.admissionid, res.periodstart, res.periodgroup, res.periodend], EST_CARDINALITY=419.0, EST_COL_STATS={res.adrema=[-1.0, -1.0], res.episode=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}}) Source(groups=[#tmp_results AS res], props={OUTPUT_COLS=[res.admissionid, res.periodstart, res.periodgroup, res.periodend], EST_COL_STATS={res.adrema=[-1.0, -1.0], res.episode=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}, EST_CARDINALITY=419.0}) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], EST_CARDINALITY=5.6561608E7, EST_COL_STATS={po.PatientID=[-1.0, -1.0], po.StartTime=[-1.0, -1.0], pr.PharmaID=[-1.0, -1.0], dos.PharmaID=[-1.0, -1.0], ...}, OUTPUT_COLS=[po.PatientID, po.StartTime, pr.PharmaID, dos.PharmaID, po.OrderNumber, po.OrderTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PlannedTime]}) Access(groups=[izisprod.prod_S_PharmaRef AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[pr.PharmaID, pr.PharmaName], EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Select(groups=[izisprod.prod_S_PharmaRef AS pr], props={SELECT_CRITERIA=pr.GenericName = 'vancomycine hydrochloride', OUTPUT_COLS=[pr.PharmaID, pr.PharmaName], IS_COPIED=true, EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Source(groups=[izisprod.prod_S_PharmaRef AS pr], props={OUTPUT_COLS=[pr.GenericName, pr.PharmaID, pr.PharmaName], EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}, EST_CARDINALITY=1900.0}) Access(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[po.PatientID, po.StartTime, dos.PharmaID, po.OrderNumber, po.OrderTime, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PlannedTime], CONFORMED_SOURCES=null, EST_CARDINALITY=654923.9, EST_COL_STATS={po.PatientID=[-1.0, -1.0], po.StartTime=[-1.0, -1.0], dos.PharmaID=[-1.0, -1.0], po.OrderNumber=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.PatientID IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[po.PatientID, po.StartTime, dos.PharmaID, po.OrderNumber, po.OrderTime, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PlannedTime], EST_CARDINALITY=654923.9, EST_COL_STATS={po.PatientID=[-1.0, -1.0], po.StartTime=[-1.0, -1.0], dos.PharmaID=[-1.0, -1.0], po.OrderNumber=[-1.0, -1.0], ...}}) Join(groups=[iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber], MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, EST_CARDINALITY=2447758.5, EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}, OUTPUT_COLS=[po.PatientID, po.StartTime, dos.PharmaID, po.OrderNumber, po.OrderTime, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PlannedTime]}) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.Status <> 2, OUTPUT_COLS=[po.OrderNumber, po.PatientID, po.StartTime, po.OrderTime], IS_COPIED=true, EST_CARDINALITY=1997175.1, EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_PharmaOrder AS po], props={OUTPUT_COLS=[po.Status, po.OrderNumber, po.PatientID, po.StartTime, po.OrderTime], EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}, EST_CARDINALITY=2000000.0}) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos], props={OUTPUT_COLS=[dos.OrderNumber, dos.PharmaID, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.PatientID, dos.PlannedTime], EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}, EST_CARDINALITY=3000000.0}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1), OUTPUT_COLS=[ph.PharmaID, ph.OrderNumber], IS_COPIED=true, EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.PharmaID=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0]}}) Access(groups=[iziswh.wh_P_Pharmas AS ph], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[ph.OrderNumber, ph.PharmaID], EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.OrderNumber=[-1.0, -1.0], ph.PharmaID=[-1.0, -1.0]}, IS_DEPENDENT_SET=true}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=(ph.PharmaID IN ()) AND (ph.PharmaID IN ()) AND (ph.OrderNumber IN ()), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[ph.OrderNumber, ph.PharmaID], EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.OrderNumber=[-1.0, -1.0], ph.PharmaID=[-1.0, -1.0]}}) Source(groups=[iziswh.wh_P_Pharmas AS ph], props={OUTPUT_COLS=[ph.PharmaID, ph.OrderNumber], EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}, EST_CARDINALITY=3000000.0}) ============================================================================ EXECUTING ImplementJoinStrategy AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos, #tmp_results AS res, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID, dos.PharmaID = ph.PharmaID, ph.OrderNumber = po.OrderNumber], LEFT_EXPRESSIONS=[pr.PharmaID, dos.PharmaID, po.OrderNumber], RIGHT_EXPRESSIONS=[ph.PharmaID, ph.PharmaID, ph.OrderNumber], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=1.0, DEPENDENT_VALUE_SOURCE=$dsc/id8389, OUTPUT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], EST_COL_STATS={res.admissionid=[-1.0, -1.0], ph.PharmaID=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}, SORT_LEFT=SORT, SORT_RIGHT=SORT}) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos, #tmp_results AS res], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], LEFT_EXPRESSIONS=[res.admissionid], RIGHT_EXPRESSIONS=[po.PatientID], NON_EQUI_JOIN_CRITERIA=[po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], EST_CARDINALITY=68419.38, EST_COL_STATS={pr.PharmaID=[-1.0, -1.0], dos.PharmaID=[-1.0, -1.0], po.OrderNumber=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], ...}, DEPENDENT_VALUE_SOURCE=$dsc/id8390, OUTPUT_COLS=[pr.PharmaID, dos.PharmaID, po.OrderNumber, res.admissionid, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PlannedTime], SORT_RIGHT=SORT}) Access(groups=[#tmp_results AS res], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[res.admissionid, res.periodstart, res.periodgroup, res.periodend], EST_CARDINALITY=419.0, EST_COL_STATS={res.adrema=[-1.0, -1.0], res.episode=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}}) Sort(groups=[], props={SORT_ORDER=ORDER BY res.admissionid, OUTPUT_COLS=[res.admissionid, res.periodstart, res.periodgroup, res.periodend]}) Source(groups=[#tmp_results AS res], props={OUTPUT_COLS=[res.admissionid, res.periodstart, res.periodgroup, res.periodend], EST_COL_STATS={res.adrema=[-1.0, -1.0], res.episode=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}, EST_CARDINALITY=419.0}) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], EST_CARDINALITY=5.6561608E7, EST_COL_STATS={po.PatientID=[-1.0, -1.0], po.StartTime=[-1.0, -1.0], pr.PharmaID=[-1.0, -1.0], dos.PharmaID=[-1.0, -1.0], ...}, OUTPUT_COLS=[po.PatientID, po.StartTime, pr.PharmaID, dos.PharmaID, po.OrderNumber, po.OrderTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PlannedTime]}) Access(groups=[izisprod.prod_S_PharmaRef AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[pr.PharmaID, pr.PharmaName], EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Select(groups=[izisprod.prod_S_PharmaRef AS pr], props={SELECT_CRITERIA=pr.GenericName = 'vancomycine hydrochloride', OUTPUT_COLS=[pr.PharmaID, pr.PharmaName], IS_COPIED=true, EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}}) Source(groups=[izisprod.prod_S_PharmaRef AS pr], props={OUTPUT_COLS=[pr.GenericName, pr.PharmaID, pr.PharmaName], EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}, EST_CARDINALITY=1900.0}) Access(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[po.PatientID, po.StartTime, dos.PharmaID, po.OrderNumber, po.OrderTime, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PlannedTime], CONFORMED_SOURCES=null, EST_CARDINALITY=654923.9, EST_COL_STATS={po.PatientID=[-1.0, -1.0], po.StartTime=[-1.0, -1.0], dos.PharmaID=[-1.0, -1.0], po.OrderNumber=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.PatientID IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[po.PatientID, po.StartTime, dos.PharmaID, po.OrderNumber, po.OrderTime, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PlannedTime], EST_CARDINALITY=654923.9, EST_COL_STATS={po.PatientID=[-1.0, -1.0], po.StartTime=[-1.0, -1.0], dos.PharmaID=[-1.0, -1.0], po.OrderNumber=[-1.0, -1.0], ...}}) Join(groups=[iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_PharmaOrder AS po], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[dos.OrderNumber = po.OrderNumber], MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, EST_CARDINALITY=2447758.5, EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}, OUTPUT_COLS=[po.PatientID, po.StartTime, dos.PharmaID, po.OrderNumber, po.OrderTime, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PlannedTime]}) Select(groups=[iziswh.wh_P_PharmaOrder AS po], props={SELECT_CRITERIA=po.Status <> 2, OUTPUT_COLS=[po.OrderNumber, po.PatientID, po.StartTime, po.OrderTime], IS_COPIED=true, EST_CARDINALITY=1997175.1, EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}}) Source(groups=[iziswh.wh_P_PharmaOrder AS po], props={OUTPUT_COLS=[po.Status, po.OrderNumber, po.PatientID, po.StartTime, po.OrderTime], EST_COL_STATS={po.Actived=[-1.0, -1.0], po.AdjustHigh=[-1.0, -1.0], po.AdjustLow=[-1.0, -1.0], po.Advanced=[-1.0, -1.0], ...}, EST_CARDINALITY=2000000.0}) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos], props={OUTPUT_COLS=[dos.OrderNumber, dos.PharmaID, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.PatientID, dos.PlannedTime], EST_COL_STATS={dos.Concentration=[-1.0, -1.0], dos.ConcentrationUnit=[-1.0, -1.0], dos.Dose=[-1.0, -1.0], dos.OrderNumber=[-1.0, -1.0], ...}, EST_CARDINALITY=3000000.0}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1), OUTPUT_COLS=[ph.PharmaID, ph.OrderNumber], IS_COPIED=true, EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.PharmaID=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0]}}) Access(groups=[iziswh.wh_P_Pharmas AS ph], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[ph.OrderNumber, ph.PharmaID], EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.OrderNumber=[-1.0, -1.0], ph.PharmaID=[-1.0, -1.0]}, IS_DEPENDENT_SET=true}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=(ph.PharmaID IN ()) AND (ph.PharmaID IN ()) AND (ph.OrderNumber IN ()), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[ph.OrderNumber, ph.PharmaID], EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.OrderNumber=[-1.0, -1.0], ph.PharmaID=[-1.0, -1.0]}}) Source(groups=[iziswh.wh_P_Pharmas AS ph], props={OUTPUT_COLS=[ph.PharmaID, ph.OrderNumber], EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}, EST_CARDINALITY=3000000.0}) ============================================================================ EXECUTING MergeCriteria ---------------------------------------------------------------------------- OPTIMIZE: SELECT 1, phr.OrderNumber, phr.PharmaID FROM iziswh.wh_P_PharmaRec AS phr WHERE BITAND(convert(phr.Status, integer), 2) <> 2 ORDER BY phr.OrderNumber, phr.PharmaID ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT 1, phr.OrderNumber, phr.PharmaID FROM iziswh.wh_P_PharmaRec AS phr WHERE BITAND(convert(phr.Status, integer), 2) <> 2 ORDER BY phr.OrderNumber, phr.PharmaID CANONICAL PLAN: Sort(groups=[iziswh.wh_P_PharmaRec AS phr], props={SORT_ORDER=ORDER BY phr.OrderNumber, phr.PharmaID}) Project(groups=[iziswh.wh_P_PharmaRec AS phr], props={PROJECT_COLS=[1, phr.OrderNumber, phr.PharmaID]}) Select(groups=[iziswh.wh_P_PharmaRec AS phr], props={SELECT_CRITERIA=BITAND(convert(phr.Status, integer), 2) <> 2}) Source(groups=[iziswh.wh_P_PharmaRec AS phr]) ============================================================================ EXECUTING PlaceAccess AFTER: Sort(groups=[iziswh.wh_P_PharmaRec AS phr__1], props={SORT_ORDER=ORDER BY phr__1.OrderNumber, phr__1.PharmaID}) Project(groups=[iziswh.wh_P_PharmaRec AS phr__1], props={PROJECT_COLS=[1, phr__1.OrderNumber, phr__1.PharmaID]}) Select(groups=[iziswh.wh_P_PharmaRec AS phr__1], props={SELECT_CRITERIA=BITAND(convert(phr__1.Status, integer), 2) <> 2}) Access(groups=[iziswh.wh_P_PharmaRec AS phr__1], 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 phr__1]) ============================================================================ EXECUTING PushSelectCriteria AFTER: Sort(groups=[iziswh.wh_P_PharmaRec AS phr__1]) Project(groups=[iziswh.wh_P_PharmaRec AS phr__1], props={PROJECT_COLS=[1, phr__1.OrderNumber, phr__1.PharmaID]}) Select(groups=[iziswh.wh_P_PharmaRec AS phr__1], props={SELECT_CRITERIA=BITAND(convert(phr__1.Status, integer), 2) <> 2}) Access(groups=[iziswh.wh_P_PharmaRec AS phr__1], 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 phr__1]) ============================================================================ EXECUTING CleanCriteria AFTER: Sort(groups=[iziswh.wh_P_PharmaRec AS phr__1], props={SORT_ORDER=ORDER BY phr__1.OrderNumber, phr__1.PharmaID, OUTPUT_COLS=null}) Project(groups=[iziswh.wh_P_PharmaRec AS phr__1], props={PROJECT_COLS=[1, phr__1.OrderNumber, phr__1.PharmaID], OUTPUT_COLS=null}) Select(groups=[iziswh.wh_P_PharmaRec AS phr__1], props={SELECT_CRITERIA=BITAND(convert(phr__1.Status, integer), 2) <> 2, OUTPUT_COLS=null}) Access(groups=[iziswh.wh_P_PharmaRec AS phr__1], 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_PharmaRec AS phr__1], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING RaiseAccess LOW Relational Planner BITAND function not supported by source iziswh - BITAND(convert(phr__1.Status, integer), 2) was not pushed AFTER: Sort(groups=[iziswh.wh_P_PharmaRec AS phr__1]) Project(groups=[iziswh.wh_P_PharmaRec AS phr__1]) Select(groups=[iziswh.wh_P_PharmaRec AS phr__1], props={SELECT_CRITERIA=BITAND(convert(phr__1.Status, integer), 2) <> 2, OUTPUT_COLS=null}) Access(groups=[iziswh.wh_P_PharmaRec AS phr__1], 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_PharmaRec AS phr__1]) ============================================================================ EXECUTING AssignOutputElements AFTER: Sort(groups=[iziswh.wh_P_PharmaRec AS phr__1], props={SORT_ORDER=ORDER BY phr__1.OrderNumber, phr__1.PharmaID, OUTPUT_COLS=[1, phr__1.OrderNumber, phr__1.PharmaID], UNRELATED_SORT=false}) Project(groups=[iziswh.wh_P_PharmaRec AS phr__1], props={PROJECT_COLS=[1, phr__1.OrderNumber, phr__1.PharmaID], OUTPUT_COLS=[1, phr__1.OrderNumber, phr__1.PharmaID]}) Select(groups=[iziswh.wh_P_PharmaRec AS phr__1], props={SELECT_CRITERIA=BITAND(convert(phr__1.Status, integer), 2) <> 2, OUTPUT_COLS=[phr__1.OrderNumber, phr__1.PharmaID]}) Access(groups=[iziswh.wh_P_PharmaRec AS phr__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[phr__1.Status, phr__1.OrderNumber, phr__1.PharmaID]}) Source(groups=[iziswh.wh_P_PharmaRec AS phr__1], props={OUTPUT_COLS=[phr__1.Status, phr__1.OrderNumber, phr__1.PharmaID]}) ============================================================================ EXECUTING CalculateCost AFTER: Sort(groups=[iziswh.wh_P_PharmaRec AS phr__1], props={SORT_ORDER=ORDER BY phr__1.OrderNumber, phr__1.PharmaID, OUTPUT_COLS=[1, phr__1.OrderNumber, phr__1.PharmaID], UNRELATED_SORT=false, EST_CARDINALITY=5.4985172E7, EST_COL_STATS={1=[1.0, 1.0], phr__1.OrderNumber=[-1.0, -1.0], phr__1.PharmaID=[-1.0, -1.0]}}) Project(groups=[iziswh.wh_P_PharmaRec AS phr__1], props={PROJECT_COLS=[1, phr__1.OrderNumber, phr__1.PharmaID], OUTPUT_COLS=[1, phr__1.OrderNumber, phr__1.PharmaID], EST_CARDINALITY=5.4985172E7, EST_COL_STATS={1=[1.0, 1.0], phr__1.OrderNumber=[-1.0, -1.0], phr__1.PharmaID=[-1.0, -1.0]}}) Select(groups=[iziswh.wh_P_PharmaRec AS phr__1], props={SELECT_CRITERIA=BITAND(convert(phr__1.Status, integer), 2) <> 2, OUTPUT_COLS=[phr__1.OrderNumber, phr__1.PharmaID], EST_CARDINALITY=5.4985172E7, EST_COL_STATS={phr__1.OrderNumber=[-1.0, -1.0], phr__1.PharmaID=[-1.0, -1.0]}}) Access(groups=[iziswh.wh_P_PharmaRec AS phr__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[phr__1.Status, phr__1.OrderNumber, phr__1.PharmaID], EST_CARDINALITY=5.5E7, EST_COL_STATS={phr__1.Status=[-1.0, -1.0], phr__1.OrderNumber=[-1.0, -1.0], phr__1.PharmaID=[-1.0, -1.0]}}) Source(groups=[iziswh.wh_P_PharmaRec AS phr__1], props={OUTPUT_COLS=[phr__1.Status, phr__1.OrderNumber, phr__1.PharmaID], EST_COL_STATS={phr__1.Status=[-1.0, -1.0], phr__1.OrderNumber=[-1.0, -1.0], phr__1.PharmaID=[-1.0, -1.0]}, EST_CARDINALITY=5.5E7}) ============================================================================ EXECUTING MergeCriteria AFTER: Sort(groups=[iziswh.wh_P_PharmaRec AS phr__1]) Project(groups=[iziswh.wh_P_PharmaRec AS phr__1]) Select(groups=[iziswh.wh_P_PharmaRec AS phr__1], props={SELECT_CRITERIA=BITAND(convert(phr__1.Status, integer), 2) <> 2, OUTPUT_COLS=[phr__1.OrderNumber, phr__1.PharmaID], EST_CARDINALITY=5.4985172E7, EST_COL_STATS={phr__1.OrderNumber=[-1.0, -1.0], phr__1.PharmaID=[-1.0, -1.0]}}) Access(groups=[iziswh.wh_P_PharmaRec AS phr__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[phr__1.Status, phr__1.OrderNumber, phr__1.PharmaID], EST_CARDINALITY=5.5E7, EST_COL_STATS={phr__1.Status=[-1.0, -1.0], phr__1.OrderNumber=[-1.0, -1.0], phr__1.PharmaID=[-1.0, -1.0]}}) Source(groups=[iziswh.wh_P_PharmaRec AS phr__1], props={OUTPUT_COLS=[phr__1.Status, phr__1.OrderNumber, phr__1.PharmaID], EST_COL_STATS={phr__1.Status=[-1.0, -1.0], phr__1.OrderNumber=[-1.0, -1.0], phr__1.PharmaID=[-1.0, -1.0]}, EST_CARDINALITY=5.5E7}) ============================================================================ EXECUTING PlanSorts AFTER: Sort(groups=[iziswh.wh_P_PharmaRec AS phr__1], props={SORT_ORDER=ORDER BY phr__1.OrderNumber, phr__1.PharmaID, OUTPUT_COLS=[1, phr__1.OrderNumber, phr__1.PharmaID], UNRELATED_SORT=false, EST_CARDINALITY=5.4985172E7, EST_COL_STATS={1=[1.0, 1.0], phr__1.OrderNumber=[-1.0, -1.0], phr__1.PharmaID=[-1.0, -1.0]}}) Project(groups=[iziswh.wh_P_PharmaRec AS phr__1]) Select(groups=[iziswh.wh_P_PharmaRec AS phr__1]) Access(groups=[iziswh.wh_P_PharmaRec AS phr__1]) Source(groups=[iziswh.wh_P_PharmaRec AS phr__1]) ============================================================================ EXECUTING CollapseSource AFTER: Sort(groups=[iziswh.wh_P_PharmaRec AS phr__1]) Project(groups=[iziswh.wh_P_PharmaRec AS phr__1], props={PROJECT_COLS=[1, phr__1.OrderNumber, phr__1.PharmaID], OUTPUT_COLS=[1, phr__1.OrderNumber, phr__1.PharmaID], EST_CARDINALITY=5.4985172E7, EST_COL_STATS={1=[1.0, 1.0], phr__1.OrderNumber=[-1.0, -1.0], phr__1.PharmaID=[-1.0, -1.0]}}) Select(groups=[iziswh.wh_P_PharmaRec AS phr__1]) Access(groups=[iziswh.wh_P_PharmaRec AS phr__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[phr__1.Status, phr__1.OrderNumber, phr__1.PharmaID], EST_CARDINALITY=5.5E7, EST_COL_STATS={phr__1.Status=[-1.0, -1.0], phr__1.OrderNumber=[-1.0, -1.0], phr__1.PharmaID=[-1.0, -1.0]}, ATOMIC_REQUEST=SELECT phr__1.Status, phr__1.OrderNumber, phr__1.PharmaID FROM iziswh.wh_P_PharmaRec AS phr__1}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = SortNode(4) output=[1, phr__1.OrderNumber, phr__1.PharmaID] [SORT] [phr__1.OrderNumber, phr__1.PharmaID] ProjectNode(5) output=[1, phr__1.OrderNumber, phr__1.PharmaID] [1, phr__1.OrderNumber, phr__1.PharmaID] SelectNode(6) output=[phr__1.OrderNumber, phr__1.PharmaID] BITAND(convert(phr__1.Status, integer), 2) <> 2 AccessNode(7) output=[phr__1.Status, phr__1.OrderNumber, phr__1.PharmaID] SELECT g_0.Status, g_0.OrderNumber, g_0.PharmaID FROM iziswh.wh_P_PharmaRec AS g_0 ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: SortNode(4) output=[1, phr__1.OrderNumber, phr__1.PharmaID] [SORT] [phr__1.OrderNumber, phr__1.PharmaID] ProjectNode(5) output=[1, phr__1.OrderNumber, phr__1.PharmaID] [1, phr__1.OrderNumber, phr__1.PharmaID] SelectNode(6) output=[phr__1.OrderNumber, phr__1.PharmaID] BITAND(convert(phr__1.Status, integer), 2) <> 2 AccessNode(7) output=[phr__1.Status, phr__1.OrderNumber, phr__1.PharmaID] SELECT g_0.Status, g_0.OrderNumber, g_0.PharmaID FROM iziswh.wh_P_PharmaRec AS g_0 ============================================================================ LOW Relational Planner cost of merge join plan was not favorable - semi merge join will not be used Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1), OUTPUT_COLS=[ph.PharmaID, ph.OrderNumber], IS_COPIED=true, EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.PharmaID=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0]}} AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos, #tmp_results AS res, iziswh.wh_P_Pharmas AS ph]) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos, #tmp_results AS res]) Access(groups=[#tmp_results AS res]) Sort(groups=[]) Source(groups=[#tmp_results AS res]) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos]) Access(groups=[izisprod.prod_S_PharmaRef AS pr]) Select(groups=[izisprod.prod_S_PharmaRef AS pr]) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) Access(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos]) Select(groups=[iziswh.wh_P_PharmaOrder AS po]) Join(groups=[iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_PharmaOrder AS po]) Select(groups=[iziswh.wh_P_PharmaOrder AS po]) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1), OUTPUT_COLS=[ph.PharmaID, ph.OrderNumber], IS_COPIED=true, EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.PharmaID=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0]}}) Access(groups=[iziswh.wh_P_Pharmas AS ph], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[ph.OrderNumber, ph.PharmaID], EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.OrderNumber=[-1.0, -1.0], ph.PharmaID=[-1.0, -1.0]}, IS_DEPENDENT_SET=true}) Select(groups=[iziswh.wh_P_Pharmas AS ph], props={SELECT_CRITERIA=(ph.PharmaID IN ()) AND (ph.PharmaID IN ()) AND (ph.OrderNumber IN ()), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[ph.OrderNumber, ph.PharmaID], EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.OrderNumber=[-1.0, -1.0], ph.PharmaID=[-1.0, -1.0]}}) Source(groups=[iziswh.wh_P_Pharmas AS ph], props={OUTPUT_COLS=[ph.PharmaID, ph.OrderNumber], EST_COL_STATS={ph.IDDoctor=[-1.0, -1.0], ph.IDSavedBy=[-1.0, -1.0], ph.ListPosition=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], ...}, EST_CARDINALITY=3000000.0}) ============================================================================ EXECUTING PlanSorts AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po], props={SORT_ORDER=ORDER BY res.admissionid, res.periodgroup, po.OrderTime, OUTPUT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], UNRELATED_SORT=false, EST_CARDINALITY=1.0, EST_COL_STATS={res.admissionid=[-1.0, -1.0], ph.PharmaID=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}}) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos]) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos, #tmp_results AS res, iziswh.wh_P_Pharmas AS ph], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[pr.PharmaID = ph.PharmaID, dos.PharmaID = ph.PharmaID, ph.OrderNumber = po.OrderNumber], LEFT_EXPRESSIONS=[pr.PharmaID, dos.PharmaID, po.OrderNumber], RIGHT_EXPRESSIONS=[ph.PharmaID, ph.PharmaID, ph.OrderNumber], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=1.0, DEPENDENT_VALUE_SOURCE=$dsc/id8389, OUTPUT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], EST_COL_STATS={res.admissionid=[-1.0, -1.0], ph.PharmaID=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}, SORT_LEFT=SORT, SORT_RIGHT=SORT}) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos, #tmp_results AS res], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[po.PatientID = res.admissionid, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], LEFT_EXPRESSIONS=[res.admissionid], RIGHT_EXPRESSIONS=[po.PatientID], NON_EQUI_JOIN_CRITERIA=[po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)], EST_CARDINALITY=68419.38, EST_COL_STATS={pr.PharmaID=[-1.0, -1.0], dos.PharmaID=[-1.0, -1.0], po.OrderNumber=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], ...}, DEPENDENT_VALUE_SOURCE=$dsc/id8390, OUTPUT_COLS=[pr.PharmaID, dos.PharmaID, po.OrderNumber, res.admissionid, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PlannedTime], SORT_RIGHT=SORT}) Access(groups=[#tmp_results AS res]) Sort(groups=[]) Source(groups=[#tmp_results AS res]) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], EST_CARDINALITY=5.6561608E7, EST_COL_STATS={po.PatientID=[-1.0, -1.0], po.StartTime=[-1.0, -1.0], pr.PharmaID=[-1.0, -1.0], dos.PharmaID=[-1.0, -1.0], ...}, OUTPUT_COLS=[po.PatientID, po.StartTime, pr.PharmaID, dos.PharmaID, po.OrderNumber, po.OrderTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PlannedTime]}) Access(groups=[izisprod.prod_S_PharmaRef AS pr]) Select(groups=[izisprod.prod_S_PharmaRef AS pr]) Source(groups=[izisprod.prod_S_PharmaRef AS pr]) Access(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos]) Select(groups=[iziswh.wh_P_PharmaOrder AS po]) Join(groups=[iziswh.wh_P_DailyOrderSchedule AS dos, iziswh.wh_P_PharmaOrder AS po]) Select(groups=[iziswh.wh_P_PharmaOrder AS po]) Source(groups=[iziswh.wh_P_PharmaOrder AS po]) Source(groups=[iziswh.wh_P_DailyOrderSchedule AS dos]) Select(groups=[iziswh.wh_P_Pharmas AS ph]) Access(groups=[iziswh.wh_P_Pharmas AS ph]) Select(groups=[iziswh.wh_P_Pharmas AS ph]) Source(groups=[iziswh.wh_P_Pharmas AS ph]) ============================================================================ EXECUTING CollapseSource AFTER: Sort(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po]) Project(groups=[#tmp_results AS res, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_Pharmas AS ph, izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_DailyOrderSchedule AS dos], props={PROJECT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], OUTPUT_COLS=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime], EST_CARDINALITY=1.0, EST_COL_STATS={res.admissionid=[-1.0, -1.0], ph.PharmaID=[-1.0, -1.0], ph.OrderNumber=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}}) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos, #tmp_results AS res, iziswh.wh_P_Pharmas AS ph]) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos, #tmp_results AS res]) Access(groups=[#tmp_results AS res], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[res.admissionid, res.periodstart, res.periodgroup, res.periodend], EST_CARDINALITY=419.0, EST_COL_STATS={res.adrema=[-1.0, -1.0], res.episode=[-1.0, -1.0], res.admissionid=[-1.0, -1.0], res.periodgroup=[-1.0, -1.0], ...}, ATOMIC_REQUEST=SELECT res.admissionid, res.periodstart, res.periodgroup, res.periodend FROM #tmp_results AS res ORDER BY res.admissionid}) Join(groups=[izisprod.prod_S_PharmaRef AS pr, iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos]) Access(groups=[izisprod.prod_S_PharmaRef AS pr], props={SOURCE_HINT=null, MODEL_ID=Schema name=izisprod, nameInSource=null, uuid=mmuuid:095c2821-e16b-4f9d-9c78-0d2d20018d04, OUTPUT_COLS=[pr.PharmaID, pr.PharmaName], EST_CARDINALITY=86.36364, EST_COL_STATS={pr.ArchStatus=[-1.0, -1.0], pr.ArchTime=[-1.0, -1.0], pr.Availability=[-1.0, -1.0], pr.BgColorRGB=[-1.0, -1.0], ...}, ATOMIC_REQUEST=SELECT pr.PharmaID, pr.PharmaName FROM izisprod.prod_S_PharmaRef AS pr WHERE pr.GenericName = 'vancomycine hydrochloride'}) Access(groups=[iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[po.PatientID, po.StartTime, dos.PharmaID, po.OrderNumber, po.OrderTime, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PlannedTime], CONFORMED_SOURCES=null, EST_CARDINALITY=654923.9, EST_COL_STATS={po.PatientID=[-1.0, -1.0], po.StartTime=[-1.0, -1.0], dos.PharmaID=[-1.0, -1.0], po.OrderNumber=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true, ATOMIC_REQUEST=SELECT po.PatientID, po.StartTime, dos.PharmaID, po.OrderNumber, po.OrderTime, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PlannedTime FROM iziswh.wh_P_PharmaOrder AS po, iziswh.wh_P_DailyOrderSchedule AS dos WHERE (dos.OrderNumber = po.OrderNumber) AND (po.Status <> 2) AND (po.PatientID IN ())}) Select(groups=[iziswh.wh_P_Pharmas AS ph]) Access(groups=[iziswh.wh_P_Pharmas AS ph], props={SOURCE_HINT=null, MODEL_ID=Schema name=iziswh, nameInSource=null, uuid=mmuuid:43611995-84e0-4550-be48-cdeb054d06ac, OUTPUT_COLS=[ph.OrderNumber, ph.PharmaID], EST_CARDINALITY=3000000.0, EST_COL_STATS={ph.OrderNumber=[-1.0, -1.0], ph.PharmaID=[-1.0, -1.0]}, IS_DEPENDENT_SET=true, ATOMIC_REQUEST=SELECT ph.OrderNumber, ph.PharmaID FROM iziswh.wh_P_Pharmas AS ph WHERE (ph.PharmaID IN ()) AND (ph.PharmaID IN ()) AND (ph.OrderNumber IN ())}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = SortNode(8) output=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime] [SORT] [res.admissionid, res.periodgroup, po.OrderTime] ProjectNode(9) output=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime] [res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime] JoinNode(10) [Dependent] [ENHANCED SORT JOIN (SORT/SORT)] [INNER JOIN] criteria=[pr.PharmaID=ph.PharmaID, dos.PharmaID=ph.PharmaID, po.OrderNumber=ph.OrderNumber] output=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime] JoinNode(11) [Dependent] [ENHANCED SORT JOIN (ALREADY_SORTED/SORT)] [INNER JOIN] criteria=[res.admissionid=po.PatientID, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)] output=[pr.PharmaID, dos.PharmaID, po.OrderNumber, res.admissionid, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PlannedTime] AccessNode(12) output=[res.admissionid, res.periodstart, res.periodgroup, res.periodend] SELECT #tmp_results.admissionid, #tmp_results.periodstart, #tmp_results.periodgroup, #tmp_results.periodend FROM #tmp_results ORDER BY #tmp_results.admissionid JoinNode(13) [NESTED LOOP JOIN] [CROSS JOIN] output=[po.PatientID, po.StartTime, pr.PharmaID, dos.PharmaID, po.OrderNumber, po.OrderTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PlannedTime] AccessNode(14) output=[pr.PharmaID, pr.PharmaName] SELECT g_0.PharmaID, g_0.PharmaName FROM izisprod.prod_S_PharmaRef AS g_0 WHERE g_0.GenericName = 'vancomycine hydrochloride' DependentAccessNode(15) output=[po.PatientID, po.StartTime, dos.PharmaID, po.OrderNumber, po.OrderTime, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PlannedTime] SELECT g_0.PatientID, g_0.StartTime, g_1.PharmaID, g_0.OrderNumber, g_0.OrderTime, g_1.Concentration, g_1.ConcentrationUnit, g_1.Dose, g_1.OrderNumber, g_1.PatientID, g_1.PlannedTime FROM iziswh.wh_P_PharmaOrder AS g_0, iziswh.wh_P_DailyOrderSchedule AS g_1 WHERE (g_1.OrderNumber = g_0.OrderNumber) AND (g_0.Status <> 2) AND (g_0.PatientID IN ()) SelectNode(16) output=[ph.PharmaID, ph.OrderNumber] EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1) DependentAccessNode(17) output=[ph.OrderNumber, ph.PharmaID] SELECT g_0.OrderNumber, g_0.PharmaID FROM iziswh.wh_P_Pharmas AS g_0 WHERE (g_0.PharmaID IN ()) AND (g_0.PharmaID IN ()) AND (g_0.OrderNumber IN ()) ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: SortNode(8) output=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime] [SORT] [res.admissionid, res.periodgroup, po.OrderTime] ProjectNode(9) output=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime] [res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime] JoinNode(10) [Dependent] [ENHANCED SORT JOIN (SORT/SORT)] [INNER JOIN] criteria=[pr.PharmaID=ph.PharmaID, dos.PharmaID=ph.PharmaID, po.OrderNumber=ph.OrderNumber] output=[res.admissionid, ph.PharmaID, ph.OrderNumber, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PharmaID, dos.PlannedTime] JoinNode(11) [Dependent] [ENHANCED SORT JOIN (ALREADY_SORTED/SORT)] [INNER JOIN] criteria=[res.admissionid=po.PatientID, po.StartTime >= timestampadd(SQL_TSI_HOUR, -24, res.periodstart), po.StartTime <= timestampadd(SQL_TSI_HOUR, 2, res.periodstart)] output=[pr.PharmaID, dos.PharmaID, po.OrderNumber, res.admissionid, res.periodgroup, res.periodstart, res.periodend, po.OrderTime, po.StartTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PlannedTime] AccessNode(12) output=[res.admissionid, res.periodstart, res.periodgroup, res.periodend] SELECT #tmp_results.admissionid, #tmp_results.periodstart, #tmp_results.periodgroup, #tmp_results.periodend FROM #tmp_results ORDER BY #tmp_results.admissionid JoinNode(13) [NESTED LOOP JOIN] [CROSS JOIN] output=[po.PatientID, po.StartTime, pr.PharmaID, dos.PharmaID, po.OrderNumber, po.OrderTime, pr.PharmaName, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PlannedTime] AccessNode(14) output=[pr.PharmaID, pr.PharmaName] SELECT g_0.PharmaID, g_0.PharmaName FROM izisprod.prod_S_PharmaRef AS g_0 WHERE g_0.GenericName = 'vancomycine hydrochloride' DependentAccessNode(15) output=[po.PatientID, po.StartTime, dos.PharmaID, po.OrderNumber, po.OrderTime, dos.Concentration, dos.ConcentrationUnit, dos.Dose, dos.OrderNumber, dos.PatientID, dos.PlannedTime] SELECT g_0.PatientID, g_0.StartTime, g_1.PharmaID, g_0.OrderNumber, g_0.OrderTime, g_1.Concentration, g_1.ConcentrationUnit, g_1.Dose, g_1.OrderNumber, g_1.PatientID, g_1.PlannedTime FROM iziswh.wh_P_PharmaOrder AS g_0, iziswh.wh_P_DailyOrderSchedule AS g_1 WHERE (g_1.OrderNumber = g_0.OrderNumber) AND (g_0.Status <> 2) AND (g_0.PatientID IN ()) SelectNode(16) output=[ph.PharmaID, ph.OrderNumber] EXISTS (SELECT 1 FROM iziswh.wh_P_PharmaRec AS phr WHERE (phr.OrderNumber = ph.OrderNumber) AND (phr.PharmaID = ph.PharmaID) AND (BITAND(convert(phr.Status, integer), 2) <> 2) LIMIT 1) DependentAccessNode(17) output=[ph.OrderNumber, ph.PharmaID] SELECT g_0.OrderNumber, g_0.PharmaID FROM iziswh.wh_P_Pharmas AS g_0 WHERE (g_0.PharmaID IN ()) AND (g_0.PharmaID IN ()) AND (g_0.OrderNumber IN ()) ============================================================================