ProjectNode + Relational Node ID:0 + Output Columns: 0: ICUSessionID (long) 1: expr2 (integer) 2: DateTime (timestamp) 3: varvalue (double) 4: expr5 (boolean) 5: expr6 (integer) + Statistics: 0: Node Output Rows: 162175 1: Node Next Batch Process Time: 34 2: Node Cumulative Next Batch Process Time: 9006 3: Node Cumulative Process Time: 27104 4: Node Next Batch Calls: 474 5: Node Blocks: 394 + Cost Estimates:Estimated Node Cardinality: 23.470352 + Child 0: JoinNode + Relational Node ID:1 + Output Columns: 0: ICUSessionID (long) 1: DateTime (timestamp) 2: Value (double) + Statistics: 0: Node Output Rows: 162175 1: Node Next Batch Process Time: 2034 2: Node Cumulative Next Batch Process Time: 8972 3: Node Cumulative Process Time: 27103 4: Node Next Batch Calls: 474 5: Node Blocks: 394 + Cost Estimates:Estimated Node Cardinality: 23.470352 + Child 0: SelectNode + Relational Node ID:2 + Output Columns: 0: PatientID (integer) 1: DateTime (timestamp) 2: Value (double) 3: expr (long) + Statistics: 0: Node Output Rows: 796805 1: Node Next Batch Process Time: 106 2: Node Cumulative Next Batch Process Time: 6930 3: Node Cumulative Process Time: 24096 4: Node Next Batch Calls: 1950 5: Node Blocks: 391 + Child 0: ProjectNode + Relational Node ID:3 + Output Columns: 0: PatientID (integer) 1: VariableID (integer) 2: DateTime (timestamp) 3: EnterTime (timestamp) 4: Value (double) 5: stringvalue (string) 6: rang (integer) 7: expr (long) + Statistics: 0: Node Output Rows: 798906 1: Node Next Batch Process Time: 350 2: Node Cumulative Next Batch Process Time: 6824 3: Node Cumulative Process Time: 24096 4: Node Next Batch Calls: 1950 5: Node Blocks: 391 + Cost Estimates:Estimated Node Cardinality: 58892.992 + Child 0: UnionAllNode + Relational Node ID:4 + Output Columns: 0: PatientID (integer) 1: VariableID (integer) 2: DateTime (timestamp) 3: EnterTime (timestamp) 4: Value (double) 5: stringvalue (string) 6: rang (integer) + Statistics: 0: Node Output Rows: 798906 1: Node Next Batch Process Time: 7 2: Node Cumulative Next Batch Process Time: 6474 3: Node Cumulative Process Time: 24096 4: Node Next Batch Calls: 1950 5: Node Blocks: 391 + Cost Estimates:Estimated Node Cardinality: 58892.992 + Child 0: ProjectNode + Relational Node ID:5 + Output Columns: 0: PatientID (integer) 1: VariableID (integer) 2: DateTime (timestamp) 3: EnterTime (timestamp) 4: Value (double) 5: stringvalue (string) 6: rang (integer) + Statistics: 0: Node Output Rows: 2551 1: Node Next Batch Process Time: 0 2: Node Cumulative Next Batch Process Time: 13 3: Node Cumulative Process Time: 47 4: Node Next Batch Calls: 5 5: Node Blocks: 2 + Cost Estimates:Estimated Node Cardinality: 492.5751 + Child 0: WindowFunctionProjectNode + Relational Node ID:6 + Output Columns: 0: expr (integer) 1: PatientID (integer) 2: VariableID (integer) 3: DateTime (timestamp) 4: EnterTime (timestamp) 5: Value (double) 6: expr (string) + Statistics: 0: Node Output Rows: 2551 1: Node Next Batch Process Time: 8 2: Node Cumulative Next Batch Process Time: 13 3: Node Cumulative Process Time: 47 4: Node Next Batch Calls: 5 5: Node Blocks: 2 + Child 0: SelectNode + Relational Node ID:7 + Output Columns: 0: PatientID (integer) 1: VariableID (integer) 2: DateTime (timestamp) 3: EnterTime (timestamp) 4: Value (double) 5: expr (string) + Statistics: 0: Node Output Rows: 2551 1: Node Next Batch Process Time: 4 2: Node Cumulative Next Batch Process Time: 5 3: Node Cumulative Process Time: 37 4: Node Next Batch Calls: 5 5: Node Blocks: 2 + Cost Estimates:Estimated Node Cardinality: 492.5751 + Child 0: AccessNode + Relational Node ID:8 + Output Columns: 0: Status (short) 1: PatientID (integer) 2: VariableID (integer) 3: DateTime (timestamp) 4: EnterTime (timestamp) 5: Value (double) 6: expr (string) + Statistics: 0: Node Output Rows: 2555 1: Node Next Batch Process Time: 1 2: Node Cumulative Next Batch Process Time: 1 3: Node Cumulative Process Time: 37 4: Node Next Batch Calls: 5 5: Node Blocks: 2 + Cost Estimates:Estimated Node Cardinality: 17741.879 + Query:SELECT g_1.Status, g_1.PatientID, g_1.VariableID, g_1.DateTime, g_1.EnterTime, g_1."Value", CASE WHEN g_1.StringValue IS NULL THEN g_2.StringValue ELSE g_1.StringValue END FROM (izisprod.P_GeneralData AS g_0 INNER JOIN izisprod.P_ObservRec AS g_1 ON g_0.PatientID = g_1.PatientID) LEFT OUTER JOIN izisprod.S_OrdinalRef AS g_2 ON convert(g_2.Code, double) = g_1."Value" AND g_2.VariableID = g_1.VariableID WHERE ((g_0.Status = 1) OR ((g_0.Status >= 4) AND (g_0.Status <> 5))) AND (g_1.VariableID = 15001866) + Model Name:izisprod + Criteria:(bitand(convert(obr__1.Status, integer), 2) <> 2) AND (bitand(convert(obr__1.Status, integer), 8) = 8) + Window Functions:(PARTITION BY obr__1.PatientID, obr__1.VariableID, obr__1.DateTime ORDER BY obr__1.EnterTime DESC) + Select Columns: 0: obr__1.PatientID 1: obr__1.VariableID 2: obr__1.DateTime 3: obr__1.EnterTime 4: obr__1."Value" 5: CASE WHEN obr__1.StringValue IS NULL THEN ordr.StringValue ELSE obr__1.StringValue END AS stringvalue 6: ROW_NUMBER() OVER (PARTITION BY obr__1.PatientID, obr__1.VariableID, obr__1.DateTime ORDER BY obr__1.EnterTime DESC) AS rang + Child 1: ProjectNode + Relational Node ID:9 + Output Columns: 0: PatientID (integer) 1: VariableID (integer) 2: DateTime (timestamp) 3: EnterTime (timestamp) 4: Value (double) 5: stringvalue (string) 6: rang (integer) + Statistics: 0: Node Output Rows: 796355 1: Node Next Batch Process Time: 231 2: Node Cumulative Next Batch Process Time: 6454 3: Node Cumulative Process Time: 24096 4: Node Next Batch Calls: 1947 5: Node Blocks: 391 + Cost Estimates:Estimated Node Cardinality: 117421.44 + Child 0: WindowFunctionProjectNode + Relational Node ID:10 + Output Columns: 0: expr (integer) 1: PatientID (integer) 2: VariableID (integer) 3: DateTime (timestamp) 4: EnterTime (timestamp) 5: Value (double) 6: StringValue (string) 7: StringValue (string) + Statistics: 0: Node Output Rows: 796355 1: Node Next Batch Process Time: 4977 2: Node Cumulative Next Batch Process Time: 6223 3: Node Cumulative Process Time: 24095 4: Node Next Batch Calls: 1947 5: Node Blocks: 391 + Child 0: JoinNode + Relational Node ID:11 + Output Columns: 0: PatientID (integer) 1: VariableID (integer) 2: DateTime (timestamp) 3: EnterTime (timestamp) 4: Value (double) 5: StringValue (string) 6: StringValue (string) + Statistics: 0: Node Output Rows: 796355 1: Node Next Batch Process Time: 216 2: Node Cumulative Next Batch Process Time: 1246 3: Node Cumulative Process Time: 18517 4: Node Next Batch Calls: 1947 5: Node Blocks: 391 + Cost Estimates:Estimated Node Cardinality: 117421.44 + Child 0: SelectNode + Relational Node ID:12 + Output Columns: 0: Value (double) 1: PatientID (integer) 2: VariableID (integer) 3: DateTime (timestamp) 4: EnterTime (timestamp) 5: StringValue (string) + Statistics: 0: Node Output Rows: 796355 1: Node Next Batch Process Time: 1001 2: Node Cumulative Next Batch Process Time: 1030 3: Node Cumulative Process Time: 18517 4: Node Next Batch Calls: 1560 5: Node Blocks: 782 + Cost Estimates:Estimated Node Cardinality: 22991.773 + Child 0: AccessNode + Relational Node ID:13 + Output Columns: 0: Status (short) 1: Value (double) 2: PatientID (integer) 3: VariableID (integer) 4: DateTime (timestamp) 5: EnterTime (timestamp) 6: StringValue (string) + Statistics: 0: Node Output Rows: 796620 1: Node Next Batch Process Time: 29 2: Node Cumulative Next Batch Process Time: 29 3: Node Cumulative Process Time: 18516 4: Node Next Batch Calls: 1560 5: Node Blocks: 782 + Cost Estimates:Estimated Node Cardinality: 1347397.9 + Query:SELECT g_1.Status, g_1."Value", g_1.PatientID, g_1.VariableID, g_1.DateTime, g_1.EnterTime, g_1.StringValue FROM iziswh.P_GeneralData AS g_0, iziswh.P_ObservRec AS g_1 WHERE (g_0.PatientID = g_1.PatientID) AND (g_1.VariableID = 15001866) + Model Name:iziswh + Criteria:(bitand(convert(obr__2.Status, integer), 2) <> 2) AND (bitand(convert(obr__2.Status, integer), 8) = 8) + Child 1: ProjectNode + Relational Node ID:14 + Output Columns: 0: Code (integer) 1: StringValue (string) 2: expr (double) + Statistics: 0: Node Output Rows: 0 1: Node Next Batch Process Time: 0 2: Node Cumulative Next Batch Process Time: 0 3: Node Cumulative Process Time: 0 4: Node Next Batch Calls: 1 5: Node Blocks: 0 + Cost Estimates:Estimated Node Cardinality: 131.15259 + Child 0: AccessNode + Relational Node ID:15 + Output Columns: 0: Code (integer) 1: StringValue (string) + Statistics: 0: Node Output Rows: 0 1: Node Next Batch Process Time: 0 2: Node Cumulative Next Batch Process Time: 0 3: Node Cumulative Process Time: 0 4: Node Next Batch Calls: 1 5: Node Blocks: 0 + Cost Estimates:Estimated Node Cardinality: 131.15259 + Query:SELECT #MAT_IZISVIEWS.TV_S_ORDINALREF.Code, #MAT_IZISVIEWS.TV_S_ORDINALREF.StringValue FROM #MAT_IZISVIEWS.TV_S_ORDINALREF WHERE #MAT_IZISVIEWS.TV_S_ORDINALREF.VariableID = 15001866 + Model Name:__TEMP__ + Select Columns: 0: Code 1: StringValue 2: convert(Code, double) + Join Strategy:ENHANCED SORT JOIN (SORT/SORT) + Join Type:LEFT OUTER JOIN + Join Criteria:obr__2."Value"=convert(Code, double) + Window Functions:(PARTITION BY obr__2.PatientID, obr__2.VariableID, obr__2.DateTime ORDER BY obr__2.EnterTime DESC) + Select Columns: 0: obr__2.PatientID 1: obr__2.VariableID 2: obr__2.DateTime 3: obr__2.EnterTime 4: obr__2."Value" 5: CASE WHEN obr__2.StringValue IS NULL THEN StringValue ELSE obr__2.StringValue END AS stringvalue 6: ROW_NUMBER() OVER (PARTITION BY obr__2.PatientID, obr__2.VariableID, obr__2.DateTime ORDER BY obr__2.EnterTime DESC) AS rang + Select Columns: 0: v.PatientID 1: v.VariableID 2: v.DateTime 3: v.EnterTime 4: v."Value" 5: v.stringvalue 6: v.rang 7: convert(PatientID, long) + Criteria:v.rang = 1 + Child 1: DependentAccessNode + Relational Node ID:16 + Output Columns: 0: PatientID (long) 1: ICUSessionID (long) + Statistics: 0: Node Output Rows: 13632 1: Node Next Batch Process Time: 8 2: Node Cumulative Next Batch Process Time: 8 3: Node Cumulative Process Time: 1068 4: Node Next Batch Calls: 9 5: Node Blocks: 2 + Cost Estimates:Estimated Node Cardinality: 6.8281264 + Query:SELECT g_0.PatientID AS c_0, g_1.ICUSessionID AS c_1 FROM kd_matric.ExtrPatICUAdmissions AS g_0, kd_matric.PatICUAdmissions AS g_1 WHERE (g_1.ICUSessionID = g_0.ICUSessionID) AND (g_1.BatchID < 1152) AND (g_0.PatientID IN ()) ORDER BY c_0 + Model Name:kd_matric + Dependent Join:true + Join Strategy:MERGE JOIN (SORT_DISTINCT/ALREADY_SORTED) + Join Type:INNER JOIN + Join Criteria:convert(PatientID, long)=epa.PatientID + Select Columns: 0: pa.ICUSessionID 1: 11074 2: DateTime 3: "Value" AS varvalue 4: TRUE 5: 15001866 + Data Bytes Sent:6010304 + Planning Time:106