ProjectNode + Relational Node ID:0 + Output Columns: 0: WardAbbr (string) 1: PatientID (integer) 2: Givenat (date) 3: MVGtype (string) 4: PharmaID (integer) + 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: 1 + Cost Estimates:Estimated Node Cardinality: 100.0 + Child 0: LimitNode + Relational Node ID:1 + Output Columns: 0: WardAbbr (string) 1: PatientID (integer) 2: Givenat (date) 3: MVGtype (string) 4: PharmaID (integer) + 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: 1 + Cost Estimates:Estimated Node Cardinality: 100.0 + Child 0: JoinNode + Relational Node ID:2 + Output Columns: 0: WardAbbr (string) 1: PatientID (integer) 2: Givenat (date) 3: MVGtype (string) 4: PharmaID (integer) + 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: 1 + Cost Estimates:Estimated Node Cardinality: -1.0 + Child 0: JoinNode + Relational Node ID:3 + Output Columns: 0: PatientID (integer) 1: Givenat (date) 2: MVGtype (string) 3: PharmaID (integer) + Statistics: 0: Node Output Rows: 9 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: 5.5 + Child 0: AccessNode + Relational Node ID:4 + Output Columns: 0: Aantal (double) 1: PatientID (integer) 2: Givenat (date) 3: MVGtype (string) 4: PharmaID (integer) + Statistics: 0: Node Output Rows: 3 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: 3.0 + Query:SELECT #medcontinf.Aantal, #medcontinf.PatientID, #medcontinf.Givenat, #medcontinf.MVGtype, #medcontinf.PharmaID FROM #medcontinf + Model Name:__TEMP__ + Child 1: SortNode + Relational Node ID:6 + Output Columns:nr (integer) + Statistics: 0: Node Output Rows: 10 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: 5.5 + Child 0: UnionAllNode + Relational Node ID:5 + Output Columns:nr (integer) + Statistics: 0: Node Output Rows: 10 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: 10 5: Node Blocks: 0 + Child 0: ProjectNode + Relational Node ID:15 + Output Columns:nr (integer) + Statistics: 0: Node Output Rows: 1 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: 1.0 + Select Columns:0 AS nr + Child 1: ProjectNode + Relational Node ID:16 + Output Columns:expr1 (integer) + Statistics: 0: Node Output Rows: 1 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: 1.0 + Select Columns:1 + Child 2: ProjectNode + Relational Node ID:17 + Output Columns:expr1 (integer) + Statistics: 0: Node Output Rows: 1 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: 1.0 + Select Columns:2 + Child 3: ProjectNode + Relational Node ID:18 + Output Columns:expr1 (integer) + Statistics: 0: Node Output Rows: 1 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: 1.0 + Select Columns:3 + Child 4: ProjectNode + Relational Node ID:19 + Output Columns:expr1 (integer) + Statistics: 0: Node Output Rows: 1 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: 1.0 + Select Columns:4 + Child 5: ProjectNode + Relational Node ID:20 + Output Columns:expr1 (integer) + Statistics: 0: Node Output Rows: 1 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: 1.0 + Select Columns:5 + Child 6: ProjectNode + Relational Node ID:21 + Output Columns:expr1 (integer) + Statistics: 0: Node Output Rows: 1 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: 1.0 + Select Columns:6 + Child 7: ProjectNode + Relational Node ID:22 + Output Columns:expr1 (integer) + Statistics: 0: Node Output Rows: 1 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: 1.0 + Select Columns:7 + Child 8: ProjectNode + Relational Node ID:23 + Output Columns:expr1 (integer) + Statistics: 0: Node Output Rows: 1 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: 1.0 + Select Columns:8 + Child 9: ProjectNode + Relational Node ID:24 + Output Columns:expr1 (integer) + Statistics: 0: Node Output Rows: 1 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: 1.0 + Select Columns:9 + Sort Mode:DUP_REMOVE_SORT + Join Strategy:NESTED LOOP JOIN + Join Type:INNER JOIN + Join Criteria:convert(tv1.nr, double) <= inf.Aantal + Child 1: DependentAccessNode + Relational Node ID:25 + Output Columns: 0: PatientID (integer) 1: Start1 (timestamp) 2: End1 (timestamp) 3: WardAbbr (string) + Statistics: 0: Node Output Rows: 41 1: Node Next Batch Process Time: 1 2: Node Cumulative Next Batch Process Time: 1 3: Node Cumulative Process Time: 3 4: Node Next Batch Calls: 3 5: Node Blocks: 2 + Cost Estimates:Estimated Node Cardinality: -1.0 + Query:SELECT g_0.PatientID AS c_0, g_0.Start1 AS c_1, g_0.End1 AS c_2, g_0.WardAbbr AS c_3 FROM MVGPatientLocations AS g_0 WHERE g_0.PatientID IN () ORDER BY c_0 + Model Name:tmptables + Dependent Join:true + Join Strategy:ENHANCED SORT JOIN RAN AS REPEATED SORT MERGE (SORT/ALREADY_SORTED) + Join Type:INNER JOIN + Join Criteria: 0: inf.PatientID=loc.PatientID 1: convert(inf.Givenat, timestamp) >= loc.Start1 2: convert(inf.Givenat, timestamp) <= loc.End1 + Row Offset:null + Row Limit:100 + Select Columns: 0: loc.WardAbbr 1: inf.PatientID 2: inf.Givenat 3: inf.MVGtype 4: inf.PharmaID + Data Bytes Sent:0 + Planning Time:2