Query 1: PLAN_TEXT ------------------ ProjectNode + Relational Node ID:0 + Output Columns: 0: infectionid (long) 1: linkid (long) 2: linkcultureid (integer) 3: responsibleculture (byte) 4: culturealternative (string) 5: sampleinsertts (timestamp) 6: specimennumber (string) 7: culturenumber (integer) 8: culturename (string) 9: quotation (string) 10: antibiogramculturenr (integer) 11: antibiogramspecimennr (string) 12: antibiogramsampleinsertts (timestamp) 13: culturenr (integer) 14: culturespecimennr (string) 15: culturesampleinsertts (timestamp) + Statistics: 0: Node Output Rows: 256 1: Node Next Batch Process Time: 0 2: Node Cumulative Next Batch Process Time: 31 3: Node Cumulative Process Time: 0 4: Node Next Batch Calls: 39 5: Node Blocks: 38 + Cost Estimates:Estimated Node Cardinality: 27410.879 + Child 0: JoinNode + Relational Node ID:1 + Output Columns: 0: infectionid (long) 1: id (long) 2: linkcultureid (integer) 3: responsibleculture (byte) 4: culturealternative (string) 5: sampleinsertts (timestamp) 6: specimennumber (string) 7: culturenumber (integer) 8: culturename (string) 9: quotation (string) 10: antibiogramculturenr (integer) 11: antibiogramspecimennr (string) 12: antibiogramsampleinsertts (timestamp) 13: culturenr (integer) 14: culturespecimennr (string) 15: culturesampleinsertts (timestamp) + Statistics: 0: Node Output Rows: 256 1: Node Next Batch Process Time: 0 2: Node Cumulative Next Batch Process Time: 31 3: Node Cumulative Process Time: 0 4: Node Next Batch Calls: 39 5: Node Blocks: 38 + Cost Estimates:Estimated Node Cardinality: 27410.879 + Child 0: JoinNode + Relational Node ID:2 + Output Columns: 0: culturenr (integer) 1: culturespecimennr (string) 2: culturesampleinsertts (timestamp) 3: infectionid (long) 4: id (long) 5: linkcultureid (integer) 6: responsibleculture (byte) 7: culturealternative (string) 8: antibiogramculturenr (integer) 9: antibiogramspecimennr (string) 10: antibiogramsampleinsertts (timestamp) + Statistics: 0: Node Output Rows: 12791 1: Node Next Batch Process Time: 13 2: Node Cumulative Next Batch Process Time: 18 3: Node Cumulative Process Time: 243 4: Node Next Batch Calls: 47 5: Node Blocks: 22 + Cost Estimates:Estimated Node Cardinality: 9388.227 + Child 0: ProjectNode + Relational Node ID:3 + Output Columns: 0: patientid (integer) 1: expr (string) + Statistics: 0: Node Output Rows: 8047 1: Node Next Batch Process Time: 4 2: Node Cumulative Next Batch Process Time: 5 3: Node Cumulative Process Time: 131 4: Node Next Batch Calls: 8 5: Node Blocks: 0 + Child 0: AccessNode + Relational Node ID:4 + Output Columns:patientid (integer) + Statistics: 0: Node Output Rows: 8047 1: Node Next Batch Process Time: 1 2: Node Cumulative Next Batch Process Time: 1 3: Node Cumulative Process Time: 129 4: Node Next Batch Calls: 4 5: Node Blocks: 0 + Cost Estimates:Estimated Node Cardinality: 8047.0 + Query:SELECT #tmp_admissions.patientid FROM #tmp_admissions + Model Name:__TEMP__ + Select Columns: 0: adm.patientid 1: convert(adm.patientid, string) + Child 1: AccessNode + Relational Node ID:5 + Output Columns: 0: admissionid (string) 1: culturenr (integer) 2: culturespecimennr (string) 3: culturesampleinsertts (timestamp) 4: infectionid (long) 5: id (long) 6: linkcultureid (integer) 7: responsibleculture (byte) 8: culturealternative (string) 9: antibiogramculturenr (integer) 10: antibiogramspecimennr (string) 11: antibiogramsampleinsertts (timestamp) + Statistics: 0: Node Output Rows: 14080 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: 78 5: Node Blocks: 23 + Cost Estimates:Estimated Node Cardinality: 10953.902 + Query:SELECT g_0.admissionid AS c_0, g_1.culturenr AS c_1, g_1.culturespecimennr AS c_2, g_1.culturesampleinsertts AS c_3, g_0.infectionid AS c_4, g_0.id AS c_5, g_1.linkcultureid AS c_6, g_1.responsibleculture AS c_7, g_1.culturealternative AS c_8, g_1.antibiogramculturenr AS c_9, g_1.antibiogramspecimennr AS c_10, g_1.antibiogramsampleinsertts AS c_11 FROM cosara2.cos2_links AS g_0, cosara2.cos2_link_culture AS g_1 WHERE g_1.linkid = g_0.id ORDER BY c_0 + Model Name:cosara2 + Join Strategy:ENHANCED SORT JOIN RAN AS SORT MERGE (SORT/ALREADY_SORTED) + Join Type:INNER JOIN + Join Criteria:convert(adm.patientid, string)=l.admissionid + Child 1: AccessNode + Relational Node ID:6 + Output Columns: 0: culturenumber (integer) 1: specimennumber (string) 2: sampleinsertts (timestamp) 3: culturename (string) 4: quotation (string) + Statistics: 0: Node Output Rows: 13312 1: Node Next Batch Process Time: 0 2: Node Cumulative Next Batch Process Time: 2 3: Node Cumulative Process Time: 0 4: Node Next Batch Calls: 68 5: Node Blocks: 42 + Cost Estimates:Estimated Node Cardinality: 80000.0 + Query:SELECT g_0.culturenumber AS c_0, g_0.specimennumber AS c_1, g_0.sampleinsertts AS c_2, g_0.culturename AS c_3, g_0.quotation AS c_4 FROM cosara2.cos2_lab_culture AS g_0 ORDER BY c_1, c_0, c_2 + Model Name:cosara2 + Join Strategy:ENHANCED SORT JOIN RAN AS SORT MERGE (SORT/ALREADY_SORTED) + Join Type:LEFT OUTER JOIN + Join Criteria: 0: lc.culturespecimennr=cl.specimennumber 1: lc.culturenr=cl.culturenumber 2: lc.culturesampleinsertts=cl.sampleinsertts + Select Columns: 0: l.infectionid 1: l.id AS linkid 2: lc.linkcultureid 3: lc.responsibleculture 4: lc.culturealternative 5: cl.sampleinsertts 6: cl.specimennumber 7: cl.culturenumber 8: cl.culturename 9: cl.quotation 10: lc.antibiogramculturenr 11: lc.antibiogramspecimennr 12: lc.antibiogramsampleinsertts 13: lc.culturenr 14: lc.culturespecimennr 15: lc.culturesampleinsertts + Data Bytes Sent:7301 + Planning Time:10 Query 1: DEBUG_LOG ------------------ ============================================================================ USER COMMAND: SELECT l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts FROM ((#tmp_admissions AS adm INNER JOIN cosara2.cos2_links AS l ON l.admissionid = convert(adm.patientid, string)) INNER JOIN cosara2.cos2_link_culture AS lc ON lc.linkid = l.id) LEFT OUTER JOIN cosara2.cos2_lab_culture AS cl ON cl.culturenumber = lc.culturenr AND cl.specimennumber = lc.culturespecimennr AND cl.sampleinsertts = lc.culturesampleinsertts ---------------------------------------------------------------------------- OPTIMIZE: SELECT l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts FROM ((#tmp_admissions AS adm INNER JOIN cosara2.cos2_links AS l ON l.admissionid = convert(adm.patientid, string)) INNER JOIN cosara2.cos2_link_culture AS lc ON lc.linkid = l.id) LEFT OUTER JOIN cosara2.cos2_lab_culture AS cl ON cl.culturenumber = lc.culturenr AND cl.specimennumber = lc.culturespecimennr AND cl.sampleinsertts = lc.culturesampleinsertts ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts FROM ((#tmp_admissions AS adm INNER JOIN cosara2.cos2_links AS l ON l.admissionid = convert(adm.patientid, string)) INNER JOIN cosara2.cos2_link_culture AS lc ON lc.linkid = l.id) LEFT OUTER JOIN cosara2.cos2_lab_culture AS cl ON cl.culturenumber = lc.culturenr AND cl.specimennumber = lc.culturespecimennr AND cl.sampleinsertts = lc.culturesampleinsertts CANONICAL PLAN: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l], props={PROJECT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)]}) Source(groups=[#tmp_admissions AS adm]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Source(groups=[cosara2.cos2_lab_culture AS cl]) ============================================================================ EXECUTING PlaceAccess AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l], props={PROJECT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)]}) Access(groups=[#tmp_admissions AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__}) Source(groups=[#tmp_admissions AS adm]) Access(groups=[cosara2.cos2_links AS l], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896}) Source(groups=[cosara2.cos2_links AS l]) Access(groups=[cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896}) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896}) Source(groups=[cosara2.cos2_lab_culture AS cl]) ============================================================================ EXECUTING AssignOutputElements AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l], props={PROJECT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], OUTPUT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], OUTPUT_COLS=[l.id, l.infectionid]}) Access(groups=[#tmp_admissions AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[adm.patientid]}) Source(groups=[#tmp_admissions AS adm], props={OUTPUT_COLS=[adm.patientid]}) Access(groups=[cosara2.cos2_links AS l], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[l.admissionid, l.id, l.infectionid]}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=[l.admissionid, l.id, l.infectionid]}) Access(groups=[cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[lc.linkid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=[lc.linkid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation]}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation]}) ============================================================================ EXECUTING RemoveOptionalJoins AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], OUTPUT_COLS=[l.id, l.infectionid]}) Access(groups=[#tmp_admissions AS adm]) Source(groups=[#tmp_admissions AS adm]) Access(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Access(groups=[cosara2.cos2_link_culture AS lc]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_culture AS cl]) ============================================================================ EXECUTING PushNonJoinCriteria AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], OUTPUT_COLS=[l.id, l.infectionid]}) Access(groups=[#tmp_admissions AS adm]) Source(groups=[#tmp_admissions AS adm]) Access(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Access(groups=[cosara2.cos2_link_culture AS lc]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_culture AS cl]) ============================================================================ EXECUTING CleanCriteria AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l], props={PROJECT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], OUTPUT_COLS=null}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=null}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], OUTPUT_COLS=null}) Access(groups=[#tmp_admissions AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null}) Source(groups=[#tmp_admissions AS adm], props={OUTPUT_COLS=null}) Access(groups=[cosara2.cos2_links AS l], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=null}) Access(groups=[cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=null}) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING RaiseAccess AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=null}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], OUTPUT_COLS=null}) Access(groups=[#tmp_admissions AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null}) Source(groups=[#tmp_admissions AS adm]) Access(groups=[cosara2.cos2_links AS l], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_links AS l]) Access(groups=[cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_lab_culture AS cl]) ============================================================================ EXECUTING CopyCriteria AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[#tmp_admissions AS adm]) Source(groups=[#tmp_admissions AS adm]) Access(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Access(groups=[cosara2.cos2_link_culture AS lc]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_culture AS cl]) ============================================================================ EXECUTING CleanCriteria AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l], props={PROJECT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], OUTPUT_COLS=null}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[#tmp_admissions AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null}) Source(groups=[#tmp_admissions AS adm], props={OUTPUT_COLS=null}) Access(groups=[cosara2.cos2_links AS l], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=null}) Access(groups=[cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=null}) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING PlanJoins AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null, IS_COPIED=true}) Select(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l], props={SELECT_CRITERIA=l.admissionid = convert(adm.patientid, string), EST_SELECTIVITY=0.037}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP}) Access(groups=[#tmp_admissions AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null, EST_CARDINALITY=8047.0, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}}) Source(groups=[#tmp_admissions AS adm], props={OUTPUT_COLS=null, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, EST_CARDINALITY=8047.0}) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}}) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=null, EST_COL_STATS={l.id=[-1.0, -1.0], l.admissionid=[-1.0, -1.0], l.edittime=[-1.0, -1.0], l.infectionid=[-1.0, -1.0], ...}, EST_CARDINALITY=12000.0}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=null, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, EST_CARDINALITY=10000.0}) Access(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_culture AS cl]) ============================================================================ EXECUTING PushSelectCriteria AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)]}) Access(groups=[#tmp_admissions AS adm]) Source(groups=[#tmp_admissions AS adm]) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc]) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_culture AS cl]) ============================================================================ EXECUTING RaiseAccess AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)]}) Access(groups=[#tmp_admissions AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null, EST_CARDINALITY=8047.0, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}}) Source(groups=[#tmp_admissions AS adm]) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}}) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_lab_culture AS cl]) ============================================================================ EXECUTING PlanOuterJoins AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)]}) Access(groups=[#tmp_admissions AS adm]) Source(groups=[#tmp_admissions AS adm]) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc]) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_culture AS cl]) ============================================================================ EXECUTING ChooseJoinStrategy AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null, IS_COPIED=true, LEFT_EXPRESSIONS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], RIGHT_EXPRESSIONS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], NON_EQUI_JOIN_CRITERIA=[]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], LEFT_EXPRESSIONS=[convert(adm.patientid, string)], RIGHT_EXPRESSIONS=[l.admissionid], NON_EQUI_JOIN_CRITERIA=[]}) Access(groups=[#tmp_admissions AS adm]) Source(groups=[#tmp_admissions AS adm]) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc]) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_culture AS cl]) ============================================================================ EXECUTING ChooseDependent AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null, IS_COPIED=true, LEFT_EXPRESSIONS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], RIGHT_EXPRESSIONS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], LEFT_EXPRESSIONS=[convert(adm.patientid, string)], RIGHT_EXPRESSIONS=[l.admissionid], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=9388.227, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}}) Access(groups=[#tmp_admissions AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null, EST_CARDINALITY=8047.0, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}}) Source(groups=[#tmp_admissions AS adm], props={OUTPUT_COLS=null, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, EST_CARDINALITY=8047.0}) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}}) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=null, EST_COL_STATS={l.id=[-1.0, -1.0], l.admissionid=[-1.0, -1.0], l.edittime=[-1.0, -1.0], l.infectionid=[-1.0, -1.0], ...}, EST_CARDINALITY=12000.0}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=null, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, EST_CARDINALITY=10000.0}) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null, EST_CARDINALITY=80000.0, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=null, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}, EST_CARDINALITY=80000.0}) ============================================================================ EXECUTING AssignOutputElements AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l], props={PROJECT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], OUTPUT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], IS_COPIED=true, LEFT_EXPRESSIONS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], RIGHT_EXPRESSIONS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], LEFT_EXPRESSIONS=[convert(adm.patientid, string)], RIGHT_EXPRESSIONS=[l.admissionid], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=9388.227, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, OUTPUT_COLS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Access(groups=[#tmp_admissions AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[adm.patientid], EST_CARDINALITY=8047.0, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}}) Source(groups=[#tmp_admissions AS adm], props={OUTPUT_COLS=[adm.patientid], EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, EST_CARDINALITY=8047.0}) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], CONFORMED_SOURCES=null, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}}) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, OUTPUT_COLS=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=[l.id, l.admissionid, l.infectionid], EST_COL_STATS={l.id=[-1.0, -1.0], l.admissionid=[-1.0, -1.0], l.edittime=[-1.0, -1.0], l.infectionid=[-1.0, -1.0], ...}, EST_CARDINALITY=12000.0}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=[lc.linkid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, EST_CARDINALITY=10000.0}) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation], EST_CARDINALITY=80000.0, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation], EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}, EST_CARDINALITY=80000.0}) ============================================================================ EXECUTING CalculateCost AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l], props={PROJECT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], OUTPUT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], EST_CARDINALITY=27410.879, EST_COL_STATS={l.infectionid=[-1.0, -1.0], l.id AS linkid=[-1.0, -1.0], lc.linkcultureid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], IS_COPIED=true, LEFT_EXPRESSIONS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], RIGHT_EXPRESSIONS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=27410.879, EST_COL_STATS={l.infectionid=[-1.0, -1.0], l.id=[-1.0, -1.0], lc.linkcultureid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], LEFT_EXPRESSIONS=[convert(adm.patientid, string)], RIGHT_EXPRESSIONS=[l.admissionid], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=9388.227, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, OUTPUT_COLS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Access(groups=[#tmp_admissions AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[adm.patientid], EST_CARDINALITY=8047.0, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}}) Source(groups=[#tmp_admissions AS adm], props={OUTPUT_COLS=[adm.patientid], EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, EST_CARDINALITY=8047.0}) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], CONFORMED_SOURCES=null, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}}) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, OUTPUT_COLS=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=[l.id, l.admissionid, l.infectionid], EST_COL_STATS={l.id=[-1.0, -1.0], l.admissionid=[-1.0, -1.0], l.edittime=[-1.0, -1.0], l.infectionid=[-1.0, -1.0], ...}, EST_CARDINALITY=12000.0}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=[lc.linkid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, EST_CARDINALITY=10000.0}) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation], EST_CARDINALITY=80000.0, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation], EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}, EST_CARDINALITY=80000.0}) ============================================================================ EXECUTING ImplementJoinStrategy AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], IS_COPIED=true, LEFT_EXPRESSIONS=[lc.culturespecimennr, lc.culturenr, lc.culturesampleinsertts], RIGHT_EXPRESSIONS=[cl.specimennumber, cl.culturenumber, cl.sampleinsertts], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=27410.879, EST_COL_STATS={l.infectionid=[-1.0, -1.0], l.id=[-1.0, -1.0], lc.linkcultureid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, SORT_LEFT=SORT, IS_RIGHT_DISTINCT=true}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], LEFT_EXPRESSIONS=[convert(adm.patientid, string)], RIGHT_EXPRESSIONS=[l.admissionid], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=9388.227, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, OUTPUT_COLS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], SORT_LEFT=SORT}) Project(groups=[], props={PROJECT_COLS=[adm.patientid, convert(adm.patientid, string)], OUTPUT_COLS=[adm.patientid, convert(adm.patientid, string)]}) Access(groups=[#tmp_admissions AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[adm.patientid], EST_CARDINALITY=8047.0, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}}) Source(groups=[#tmp_admissions AS adm], props={OUTPUT_COLS=[adm.patientid], EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, EST_CARDINALITY=8047.0}) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], CONFORMED_SOURCES=null, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}}) Sort(groups=[], props={SORT_ORDER=ORDER BY l.admissionid, OUTPUT_COLS=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, OUTPUT_COLS=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=[l.id, l.admissionid, l.infectionid], EST_COL_STATS={l.id=[-1.0, -1.0], l.admissionid=[-1.0, -1.0], l.edittime=[-1.0, -1.0], l.infectionid=[-1.0, -1.0], ...}, EST_CARDINALITY=12000.0}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=[lc.linkid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, EST_CARDINALITY=10000.0}) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation], EST_CARDINALITY=80000.0, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}}) Sort(groups=[], props={SORT_ORDER=ORDER BY cl.specimennumber, cl.culturenumber, cl.sampleinsertts, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation]}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation], EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}, EST_CARDINALITY=80000.0}) ============================================================================ EXECUTING MergeCriteria AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc]) Project(groups=[]) Access(groups=[#tmp_admissions AS adm]) Source(groups=[#tmp_admissions AS adm]) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc]) Sort(groups=[]) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl]) Sort(groups=[]) Source(groups=[cosara2.cos2_lab_culture AS cl]) ============================================================================ EXECUTING PlanSorts AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], IS_COPIED=true, LEFT_EXPRESSIONS=[lc.culturespecimennr, lc.culturenr, lc.culturesampleinsertts], RIGHT_EXPRESSIONS=[cl.specimennumber, cl.culturenumber, cl.sampleinsertts], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=27410.879, EST_COL_STATS={l.infectionid=[-1.0, -1.0], l.id=[-1.0, -1.0], lc.linkcultureid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, SORT_LEFT=SORT, IS_RIGHT_DISTINCT=true}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], LEFT_EXPRESSIONS=[convert(adm.patientid, string)], RIGHT_EXPRESSIONS=[l.admissionid], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=9388.227, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, OUTPUT_COLS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], SORT_LEFT=SORT}) Project(groups=[]) Access(groups=[#tmp_admissions AS adm]) Source(groups=[#tmp_admissions AS adm]) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc]) Sort(groups=[]) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl]) Sort(groups=[]) Source(groups=[cosara2.cos2_lab_culture AS cl]) ============================================================================ EXECUTING CollapseSource AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l], props={PROJECT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], OUTPUT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], EST_CARDINALITY=27410.879, EST_COL_STATS={l.infectionid=[-1.0, -1.0], l.id AS linkid=[-1.0, -1.0], lc.linkcultureid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc]) Project(groups=[], props={PROJECT_COLS=[adm.patientid, convert(adm.patientid, string)], OUTPUT_COLS=[adm.patientid, convert(adm.patientid, string)]}) Access(groups=[#tmp_admissions AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[adm.patientid], EST_CARDINALITY=8047.0, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, ATOMIC_REQUEST=SELECT adm.patientid FROM #tmp_admissions AS adm}) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], CONFORMED_SOURCES=null, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, ATOMIC_REQUEST=SELECT l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts FROM cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc WHERE lc.linkid = l.id ORDER BY l.admissionid}) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation], EST_CARDINALITY=80000.0, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}, ATOMIC_REQUEST=SELECT cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation FROM cosara2.cos2_lab_culture AS cl ORDER BY cl.specimennumber, cl.culturenumber, cl.sampleinsertts}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = ProjectNode(0) output=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts] [l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts] JoinNode(1) [ENHANCED SORT JOIN (SORT/ALREADY_SORTED)] [LEFT OUTER JOIN] criteria=[lc.culturespecimennr=cl.specimennumber, lc.culturenr=cl.culturenumber, lc.culturesampleinsertts=cl.sampleinsertts] output=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts] JoinNode(2) [ENHANCED SORT JOIN (SORT/ALREADY_SORTED)] [INNER JOIN] criteria=[convert(adm.patientid, string)=l.admissionid] output=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts] ProjectNode(3) output=[adm.patientid, convert(adm.patientid, string)] [adm.patientid, convert(adm.patientid, string)] AccessNode(4) output=[adm.patientid] SELECT #tmp_admissions.patientid FROM #tmp_admissions AccessNode(5) output=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts] SELECT g_0.admissionid AS c_0, g_1.culturenr AS c_1, g_1.culturespecimennr AS c_2, g_1.culturesampleinsertts AS c_3, g_0.infectionid AS c_4, g_0.id AS c_5, g_1.linkcultureid AS c_6, g_1.responsibleculture AS c_7, g_1.culturealternative AS c_8, g_1.antibiogramculturenr AS c_9, g_1.antibiogramspecimennr AS c_10, g_1.antibiogramsampleinsertts AS c_11 FROM cosara2.cos2_links AS g_0, cosara2.cos2_link_culture AS g_1 WHERE g_1.linkid = g_0.id ORDER BY c_0 AccessNode(6) output=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation] SELECT g_0.culturenumber AS c_0, g_0.specimennumber AS c_1, g_0.sampleinsertts AS c_2, g_0.culturename AS c_3, g_0.quotation AS c_4 FROM cosara2.cos2_lab_culture AS g_0 ORDER BY c_1, c_0, c_2 ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: ProjectNode(0) output=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts] [l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts] JoinNode(1) [ENHANCED SORT JOIN (SORT/ALREADY_SORTED)] [LEFT OUTER JOIN] criteria=[lc.culturespecimennr=cl.specimennumber, lc.culturenr=cl.culturenumber, lc.culturesampleinsertts=cl.sampleinsertts] output=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts] JoinNode(2) [ENHANCED SORT JOIN (SORT/ALREADY_SORTED)] [INNER JOIN] criteria=[convert(adm.patientid, string)=l.admissionid] output=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts] ProjectNode(3) output=[adm.patientid, convert(adm.patientid, string)] [adm.patientid, convert(adm.patientid, string)] AccessNode(4) output=[adm.patientid] SELECT #tmp_admissions.patientid FROM #tmp_admissions AccessNode(5) output=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts] SELECT g_0.admissionid AS c_0, g_1.culturenr AS c_1, g_1.culturespecimennr AS c_2, g_1.culturesampleinsertts AS c_3, g_0.infectionid AS c_4, g_0.id AS c_5, g_1.linkcultureid AS c_6, g_1.responsibleculture AS c_7, g_1.culturealternative AS c_8, g_1.antibiogramculturenr AS c_9, g_1.antibiogramspecimennr AS c_10, g_1.antibiogramsampleinsertts AS c_11 FROM cosara2.cos2_links AS g_0, cosara2.cos2_link_culture AS g_1 WHERE g_1.linkid = g_0.id ORDER BY c_0 AccessNode(6) output=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation] SELECT g_0.culturenumber AS c_0, g_0.specimennumber AS c_1, g_0.sampleinsertts AS c_2, g_0.culturename AS c_3, g_0.quotation AS c_4 FROM cosara2.cos2_lab_culture AS g_0 ORDER BY c_1, c_0, c_2 ============================================================================ Query 2: PLAN_TEXT ------------------ ProjectNode + Relational Node ID:0 + Output Columns: 0: infectionid (long) 1: linkid (long) 2: linkcultureid (integer) 3: responsibleculture (byte) 4: culturealternative (string) 5: sampleinsertts (timestamp) 6: specimennumber (string) 7: culturenumber (integer) 8: culturename (string) 9: quotation (string) 10: antibiogramculturenr (integer) 11: antibiogramspecimennr (string) 12: antibiogramsampleinsertts (timestamp) 13: culturenr (integer) 14: culturespecimennr (string) 15: culturesampleinsertts (timestamp) + Statistics: 0: Node Output Rows: 4 1: Node Next Batch Process Time: 0 2: Node Cumulative Next Batch Process Time: 1 3: Node Cumulative Process Time: 5 4: Node Next Batch Calls: 3 5: Node Blocks: 2 + Cost Estimates:Estimated Node Cardinality: 51.66935 + Child 0: JoinNode + Relational Node ID:1 + Output Columns: 0: infectionid (long) 1: id (long) 2: linkcultureid (integer) 3: responsibleculture (byte) 4: culturealternative (string) 5: sampleinsertts (timestamp) 6: specimennumber (string) 7: culturenumber (integer) 8: culturename (string) 9: quotation (string) 10: antibiogramculturenr (integer) 11: antibiogramspecimennr (string) 12: antibiogramsampleinsertts (timestamp) 13: culturenr (integer) 14: culturespecimennr (string) 15: culturesampleinsertts (timestamp) + Statistics: 0: Node Output Rows: 4 1: Node Next Batch Process Time: 0 2: Node Cumulative Next Batch Process Time: 1 3: Node Cumulative Process Time: 5 4: Node Next Batch Calls: 3 5: Node Blocks: 2 + Cost Estimates:Estimated Node Cardinality: 51.66935 + Child 0: JoinNode + Relational Node ID:2 + Output Columns: 0: culturenr (integer) 1: culturespecimennr (string) 2: culturesampleinsertts (timestamp) 3: infectionid (long) 4: id (long) 5: linkcultureid (integer) 6: responsibleculture (byte) 7: culturealternative (string) 8: antibiogramculturenr (integer) 9: antibiogramspecimennr (string) 10: antibiogramsampleinsertts (timestamp) + Statistics: 0: Node Output Rows: 4 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: 2 5: Node Blocks: 1 + Cost Estimates:Estimated Node Cardinality: 51.66935 + Child 0: ProjectNode + Relational Node ID:3 + Output Columns: 0: patientid (integer) 1: expr (string) + 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 + Child 0: AccessNode + Relational Node ID:4 + Output Columns:patientid (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 + Query:SELECT #tmp_adm2.patientid FROM #tmp_adm2 + Model Name:__TEMP__ + Select Columns: 0: adm.patientid 1: convert(adm.patientid, string) + Child 1: DependentAccessNode + Relational Node ID:5 + Output Columns: 0: admissionid (string) 1: culturenr (integer) 2: culturespecimennr (string) 3: culturesampleinsertts (timestamp) 4: infectionid (long) 5: id (long) 6: linkcultureid (integer) 7: responsibleculture (byte) 8: culturealternative (string) 9: antibiogramculturenr (integer) 10: antibiogramspecimennr (string) 11: antibiogramsampleinsertts (timestamp) + Statistics: 0: Node Output Rows: 4 1: Node Next Batch Process Time: 0 2: Node Cumulative Next Batch Process Time: 0 3: Node Cumulative Process Time: 3 4: Node Next Batch Calls: 2 5: Node Blocks: 1 + Cost Estimates:Estimated Node Cardinality: 206.6774 + Query:SELECT g_0.admissionid, g_1.culturenr, g_1.culturespecimennr, g_1.culturesampleinsertts, g_0.infectionid, g_0.id, g_1.linkcultureid, g_1.responsibleculture, g_1.culturealternative, g_1.antibiogramculturenr, g_1.antibiogramspecimennr, g_1.antibiogramsampleinsertts FROM cosara2.cos2_links AS g_0, cosara2.cos2_link_culture AS g_1 WHERE (g_1.linkid = g_0.id) AND (g_0.admissionid IN ()) + Model Name:cosara2 + Dependent Join:true + Join Strategy:ENHANCED SORT JOIN [SEMI] (SORT/SORT) + Join Type:INNER JOIN + Join Criteria:convert(adm.patientid, string)=l.admissionid + Child 1: DependentAccessNode + Relational Node ID:6 + Output Columns: 0: culturenumber (integer) 1: specimennumber (string) 2: sampleinsertts (timestamp) 3: culturename (string) 4: quotation (string) + Statistics: 0: Node Output Rows: 4 1: Node Next Batch Process Time: 0 2: Node Cumulative Next Batch Process Time: 0 3: Node Cumulative Process Time: 2 4: Node Next Batch Calls: 3 5: Node Blocks: 2 + Cost Estimates:Estimated Node Cardinality: 1.0 + Query:SELECT g_0.culturenumber AS c_0, g_0.specimennumber AS c_1, g_0.sampleinsertts AS c_2, g_0.culturename AS c_3, g_0.quotation AS c_4 FROM cosara2.cos2_lab_culture AS g_0 WHERE (g_0.culturenumber IN ()) AND (g_0.specimennumber IN ()) AND (g_0.sampleinsertts IN ()) ORDER BY c_0, c_1, c_2 + Model Name:cosara2 + Dependent Join:true + Join Strategy:ENHANCED SORT JOIN RAN AS SORT MERGE (SORT/ALREADY_SORTED) + Join Type:LEFT OUTER JOIN + Join Criteria: 0: lc.culturenr=cl.culturenumber 1: lc.culturespecimennr=cl.specimennumber 2: lc.culturesampleinsertts=cl.sampleinsertts + Select Columns: 0: l.infectionid 1: l.id AS linkid 2: lc.linkcultureid 3: lc.responsibleculture 4: lc.culturealternative 5: cl.sampleinsertts 6: cl.specimennumber 7: cl.culturenumber 8: cl.culturename 9: cl.quotation 10: lc.antibiogramculturenr 11: lc.antibiogramspecimennr 12: lc.antibiogramsampleinsertts 13: lc.culturenr 14: lc.culturespecimennr 15: lc.culturesampleinsertts + Data Bytes Sent:396 + Planning Time:12 Query 2: DEBUG_LOG ------------------ ============================================================================ USER COMMAND: SELECT l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts FROM ((#tmp_adm2 AS adm INNER JOIN cosara2.cos2_links AS l ON l.admissionid = convert(adm.patientid, string)) INNER JOIN cosara2.cos2_link_culture AS lc ON lc.linkid = l.id) LEFT OUTER JOIN cosara2.cos2_lab_culture AS cl ON cl.culturenumber = lc.culturenr AND cl.specimennumber = lc.culturespecimennr AND cl.sampleinsertts = lc.culturesampleinsertts ---------------------------------------------------------------------------- OPTIMIZE: SELECT l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts FROM ((#tmp_adm2 AS adm INNER JOIN cosara2.cos2_links AS l ON l.admissionid = convert(adm.patientid, string)) INNER JOIN cosara2.cos2_link_culture AS lc ON lc.linkid = l.id) LEFT OUTER JOIN cosara2.cos2_lab_culture AS cl ON cl.culturenumber = lc.culturenr AND cl.specimennumber = lc.culturespecimennr AND cl.sampleinsertts = lc.culturesampleinsertts ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts FROM ((#tmp_adm2 AS adm INNER JOIN cosara2.cos2_links AS l ON l.admissionid = convert(adm.patientid, string)) INNER JOIN cosara2.cos2_link_culture AS lc ON lc.linkid = l.id) LEFT OUTER JOIN cosara2.cos2_lab_culture AS cl ON cl.culturenumber = lc.culturenr AND cl.specimennumber = lc.culturespecimennr AND cl.sampleinsertts = lc.culturesampleinsertts CANONICAL PLAN: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l], props={PROJECT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts]}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts]}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id]}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)]}) Source(groups=[#tmp_adm2 AS adm]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Source(groups=[cosara2.cos2_lab_culture AS cl]) ============================================================================ EXECUTING PlaceAccess AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l], props={PROJECT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts]}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts]}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id]}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)]}) Access(groups=[#tmp_adm2 AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__}) Source(groups=[#tmp_adm2 AS adm]) Access(groups=[cosara2.cos2_links AS l], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896}) Source(groups=[cosara2.cos2_links AS l]) Access(groups=[cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896}) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896}) Source(groups=[cosara2.cos2_lab_culture AS cl]) ============================================================================ EXECUTING AssignOutputElements AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l], props={PROJECT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], OUTPUT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts]}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts]}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], OUTPUT_COLS=[l.id, l.infectionid]}) Access(groups=[#tmp_adm2 AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[adm.patientid]}) Source(groups=[#tmp_adm2 AS adm], props={OUTPUT_COLS=[adm.patientid]}) Access(groups=[cosara2.cos2_links AS l], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[l.admissionid, l.id, l.infectionid]}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=[l.admissionid, l.id, l.infectionid]}) Access(groups=[cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[lc.linkid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=[lc.linkid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation]}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation]}) ============================================================================ EXECUTING RemoveOptionalJoins AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts]}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], OUTPUT_COLS=[l.id, l.infectionid]}) Access(groups=[#tmp_adm2 AS adm]) Source(groups=[#tmp_adm2 AS adm]) Access(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Access(groups=[cosara2.cos2_link_culture AS lc]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_culture AS cl]) ============================================================================ EXECUTING PushNonJoinCriteria AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts]}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], OUTPUT_COLS=[l.id, l.infectionid]}) Access(groups=[#tmp_adm2 AS adm]) Source(groups=[#tmp_adm2 AS adm]) Access(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Access(groups=[cosara2.cos2_link_culture AS lc]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_culture AS cl]) ============================================================================ EXECUTING CleanCriteria AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l], props={PROJECT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], OUTPUT_COLS=null}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=null}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], OUTPUT_COLS=null}) Access(groups=[#tmp_adm2 AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null}) Source(groups=[#tmp_adm2 AS adm], props={OUTPUT_COLS=null}) Access(groups=[cosara2.cos2_links AS l], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=null}) Access(groups=[cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=null}) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING RaiseAccess AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=null}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], OUTPUT_COLS=null}) Access(groups=[#tmp_adm2 AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null}) Source(groups=[#tmp_adm2 AS adm]) Access(groups=[cosara2.cos2_links AS l], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_links AS l]) Access(groups=[cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_lab_culture AS cl]) ============================================================================ EXECUTING CopyCriteria AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[#tmp_adm2 AS adm]) Source(groups=[#tmp_adm2 AS adm]) Access(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Access(groups=[cosara2.cos2_link_culture AS lc]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_culture AS cl]) ============================================================================ EXECUTING CleanCriteria AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l], props={PROJECT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], OUTPUT_COLS=null}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[#tmp_adm2 AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null}) Source(groups=[#tmp_adm2 AS adm], props={OUTPUT_COLS=null}) Access(groups=[cosara2.cos2_links AS l], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=null}) Access(groups=[cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=null}) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING PlanJoins AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null, IS_COPIED=true}) Select(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l], props={SELECT_CRITERIA=l.admissionid = convert(adm.patientid, string), EST_SELECTIVITY=0.12577777}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP}) Access(groups=[#tmp_adm2 AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null, EST_CARDINALITY=1.0, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}}) Source(groups=[#tmp_adm2 AS adm], props={OUTPUT_COLS=null, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, EST_CARDINALITY=1.0}) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}}) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=null, EST_COL_STATS={l.id=[-1.0, -1.0], l.admissionid=[-1.0, -1.0], l.edittime=[-1.0, -1.0], l.infectionid=[-1.0, -1.0], ...}, EST_CARDINALITY=12000.0}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=null, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, EST_CARDINALITY=10000.0}) Access(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_culture AS cl]) ============================================================================ EXECUTING PushSelectCriteria AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)]}) Access(groups=[#tmp_adm2 AS adm]) Source(groups=[#tmp_adm2 AS adm]) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc]) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_culture AS cl]) ============================================================================ EXECUTING RaiseAccess AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)]}) Access(groups=[#tmp_adm2 AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null, EST_CARDINALITY=1.0, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}}) Source(groups=[#tmp_adm2 AS adm]) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}}) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_lab_culture AS cl]) ============================================================================ EXECUTING PlanOuterJoins AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)]}) Access(groups=[#tmp_adm2 AS adm]) Source(groups=[#tmp_adm2 AS adm]) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc]) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_culture AS cl]) ============================================================================ EXECUTING ChooseJoinStrategy AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null, IS_COPIED=true, LEFT_EXPRESSIONS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], RIGHT_EXPRESSIONS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], NON_EQUI_JOIN_CRITERIA=[]}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], LEFT_EXPRESSIONS=[convert(adm.patientid, string)], RIGHT_EXPRESSIONS=[l.admissionid], NON_EQUI_JOIN_CRITERIA=[]}) Access(groups=[#tmp_adm2 AS adm]) Source(groups=[#tmp_adm2 AS adm]) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc]) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_culture AS cl]) ============================================================================ EXECUTING ChooseDependent AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null, IS_COPIED=true, LEFT_EXPRESSIONS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], RIGHT_EXPRESSIONS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null, DEPENDENT_VALUE_SOURCE=$dsc/id3328}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], LEFT_EXPRESSIONS=[convert(adm.patientid, string)], RIGHT_EXPRESSIONS=[l.admissionid], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=405.70007, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, DEPENDENT_VALUE_SOURCE=$dsc/id3329}) Access(groups=[#tmp_adm2 AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null, EST_CARDINALITY=1.0, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}}) Source(groups=[#tmp_adm2 AS adm], props={OUTPUT_COLS=null, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, EST_CARDINALITY=1.0}) Select(groups=[cosara2.cos2_links AS l], props={SELECT_CRITERIA=l.admissionid IN (), IS_DEPENDENT_SET=true}) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}}) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=null, EST_COL_STATS={l.id=[-1.0, -1.0], l.admissionid=[-1.0, -1.0], l.edittime=[-1.0, -1.0], l.infectionid=[-1.0, -1.0], ...}, EST_CARDINALITY=12000.0}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=null, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, EST_CARDINALITY=10000.0}) Select(groups=[cosara2.cos2_lab_culture AS cl], props={SELECT_CRITERIA=(cl.culturenumber, cl.specimennumber, cl.sampleinsertts) IN (), IS_DEPENDENT_SET=true}) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null, EST_CARDINALITY=80000.0, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=null, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}, EST_CARDINALITY=80000.0}) ============================================================================ EXECUTING PushSelectCriteria AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null, IS_COPIED=true, LEFT_EXPRESSIONS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], RIGHT_EXPRESSIONS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null, DEPENDENT_VALUE_SOURCE=$dsc/id3328}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], LEFT_EXPRESSIONS=[convert(adm.patientid, string)], RIGHT_EXPRESSIONS=[l.admissionid], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=405.70007, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, DEPENDENT_VALUE_SOURCE=$dsc/id3329}) Access(groups=[#tmp_adm2 AS adm]) Source(groups=[#tmp_adm2 AS adm]) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Select(groups=[cosara2.cos2_links AS l], props={SELECT_CRITERIA=l.admissionid IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true}) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}}) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null, EST_CARDINALITY=80000.0, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Select(groups=[cosara2.cos2_lab_culture AS cl], props={SELECT_CRITERIA=(cl.culturenumber IN ()) AND (cl.specimennumber IN ()) AND (cl.sampleinsertts IN ()), IS_DEPENDENT_SET=true, IS_PUSHED=true}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=null, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}, EST_CARDINALITY=80000.0}) ============================================================================ EXECUTING CleanCriteria AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l], props={PROJECT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], OUTPUT_COLS=null}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null, IS_COPIED=true, LEFT_EXPRESSIONS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], RIGHT_EXPRESSIONS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null, DEPENDENT_VALUE_SOURCE=$dsc/id3328}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], LEFT_EXPRESSIONS=[convert(adm.patientid, string)], RIGHT_EXPRESSIONS=[l.admissionid], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=405.70007, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, DEPENDENT_VALUE_SOURCE=$dsc/id3329, OUTPUT_COLS=null}) Access(groups=[#tmp_adm2 AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null, EST_CARDINALITY=1.0, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}}) Source(groups=[#tmp_adm2 AS adm], props={OUTPUT_COLS=null, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, EST_CARDINALITY=1.0}) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Select(groups=[cosara2.cos2_links AS l], props={SELECT_CRITERIA=l.admissionid IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=null}) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=null, EST_COL_STATS={l.id=[-1.0, -1.0], l.admissionid=[-1.0, -1.0], l.edittime=[-1.0, -1.0], l.infectionid=[-1.0, -1.0], ...}, EST_CARDINALITY=12000.0}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=null, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, EST_CARDINALITY=10000.0}) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null, EST_CARDINALITY=80000.0, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Select(groups=[cosara2.cos2_lab_culture AS cl], props={SELECT_CRITERIA=(cl.culturenumber IN ()) AND (cl.specimennumber IN ()) AND (cl.sampleinsertts IN ()), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=null, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}, EST_CARDINALITY=80000.0}) ============================================================================ EXECUTING AssignOutputElements AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l], props={PROJECT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], OUTPUT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts]}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], IS_COPIED=true, LEFT_EXPRESSIONS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], RIGHT_EXPRESSIONS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null, DEPENDENT_VALUE_SOURCE=$dsc/id3328}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], LEFT_EXPRESSIONS=[convert(adm.patientid, string)], RIGHT_EXPRESSIONS=[l.admissionid], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=405.70007, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, DEPENDENT_VALUE_SOURCE=$dsc/id3329, OUTPUT_COLS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Access(groups=[#tmp_adm2 AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[adm.patientid], EST_CARDINALITY=1.0, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}}) Source(groups=[#tmp_adm2 AS adm], props={OUTPUT_COLS=[adm.patientid], EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, EST_CARDINALITY=1.0}) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], CONFORMED_SOURCES=null, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Select(groups=[cosara2.cos2_links AS l], props={SELECT_CRITERIA=l.admissionid IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, OUTPUT_COLS=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=[l.id, l.admissionid, l.infectionid], EST_COL_STATS={l.id=[-1.0, -1.0], l.admissionid=[-1.0, -1.0], l.edittime=[-1.0, -1.0], l.infectionid=[-1.0, -1.0], ...}, EST_CARDINALITY=12000.0}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=[lc.linkid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, EST_CARDINALITY=10000.0}) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation], EST_CARDINALITY=80000.0, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Select(groups=[cosara2.cos2_lab_culture AS cl], props={SELECT_CRITERIA=(cl.culturenumber IN ()) AND (cl.specimennumber IN ()) AND (cl.sampleinsertts IN ()), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation]}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation], EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}, EST_CARDINALITY=80000.0}) ============================================================================ EXECUTING CalculateCost AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l], props={PROJECT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], OUTPUT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], EST_CARDINALITY=51.66935, EST_COL_STATS={l.infectionid=[-1.0, -1.0], l.id AS linkid=[-1.0, -1.0], lc.linkcultureid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], IS_COPIED=true, LEFT_EXPRESSIONS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], RIGHT_EXPRESSIONS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=51.66935, DEPENDENT_VALUE_SOURCE=$dsc/id3328, EST_COL_STATS={l.infectionid=[-1.0, -1.0], l.id=[-1.0, -1.0], lc.linkcultureid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], LEFT_EXPRESSIONS=[convert(adm.patientid, string)], RIGHT_EXPRESSIONS=[l.admissionid], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=51.66935, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.culturesampleinsertts=[-1.0, -1.0], l.infectionid=[-1.0, -1.0], ...}, DEPENDENT_VALUE_SOURCE=$dsc/id3329, OUTPUT_COLS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Access(groups=[#tmp_adm2 AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[adm.patientid], EST_CARDINALITY=1.0, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}}) Source(groups=[#tmp_adm2 AS adm], props={OUTPUT_COLS=[adm.patientid], EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, EST_CARDINALITY=1.0}) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], CONFORMED_SOURCES=null, EST_CARDINALITY=206.6774, EST_COL_STATS={l.admissionid=[-1.0, -1.0], lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.culturesampleinsertts=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Select(groups=[cosara2.cos2_links AS l], props={SELECT_CRITERIA=l.admissionid IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], EST_CARDINALITY=206.6774, EST_COL_STATS={l.admissionid=[-1.0, -1.0], lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.culturesampleinsertts=[-1.0, -1.0], ...}}) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, OUTPUT_COLS=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=[l.id, l.admissionid, l.infectionid], EST_COL_STATS={l.id=[-1.0, -1.0], l.admissionid=[-1.0, -1.0], l.edittime=[-1.0, -1.0], l.infectionid=[-1.0, -1.0], ...}, EST_CARDINALITY=12000.0}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=[lc.linkid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, EST_CARDINALITY=10000.0}) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation], EST_CARDINALITY=1.0, EST_COL_STATS={cl.culturenumber=[-1.0, -1.0], cl.specimennumber=[-1.0, -1.0], cl.sampleinsertts=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Select(groups=[cosara2.cos2_lab_culture AS cl], props={SELECT_CRITERIA=(cl.culturenumber IN ()) AND (cl.specimennumber IN ()) AND (cl.sampleinsertts IN ()), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation], EST_CARDINALITY=1.0, EST_COL_STATS={cl.culturenumber=[-1.0, -1.0], cl.specimennumber=[-1.0, -1.0], cl.sampleinsertts=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], ...}}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation], EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}, EST_CARDINALITY=80000.0}) ============================================================================ EXECUTING ImplementJoinStrategy AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], IS_COPIED=true, LEFT_EXPRESSIONS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], RIGHT_EXPRESSIONS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=51.66935, DEPENDENT_VALUE_SOURCE=$dsc/id3328, EST_COL_STATS={l.infectionid=[-1.0, -1.0], l.id=[-1.0, -1.0], lc.linkcultureid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, SORT_LEFT=SORT, IS_RIGHT_DISTINCT=true}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], LEFT_EXPRESSIONS=[convert(adm.patientid, string)], RIGHT_EXPRESSIONS=[l.admissionid], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=51.66935, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.culturesampleinsertts=[-1.0, -1.0], l.infectionid=[-1.0, -1.0], ...}, DEPENDENT_VALUE_SOURCE=$dsc/id3329, OUTPUT_COLS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], SORT_LEFT=SORT, IS_SEMI_DEP=true, SORT_RIGHT=SORT}) Project(groups=[], props={PROJECT_COLS=[adm.patientid, convert(adm.patientid, string)], OUTPUT_COLS=[adm.patientid, convert(adm.patientid, string)]}) Access(groups=[#tmp_adm2 AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[adm.patientid], EST_CARDINALITY=1.0, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}}) Source(groups=[#tmp_adm2 AS adm], props={OUTPUT_COLS=[adm.patientid], EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, EST_CARDINALITY=1.0}) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], CONFORMED_SOURCES=null, EST_CARDINALITY=206.6774, EST_COL_STATS={l.admissionid=[-1.0, -1.0], lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.culturesampleinsertts=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Select(groups=[cosara2.cos2_links AS l], props={SELECT_CRITERIA=l.admissionid IN (), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], EST_CARDINALITY=206.6774, EST_COL_STATS={l.admissionid=[-1.0, -1.0], lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.culturesampleinsertts=[-1.0, -1.0], ...}}) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, OUTPUT_COLS=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=[l.id, l.admissionid, l.infectionid], EST_COL_STATS={l.id=[-1.0, -1.0], l.admissionid=[-1.0, -1.0], l.edittime=[-1.0, -1.0], l.infectionid=[-1.0, -1.0], ...}, EST_CARDINALITY=12000.0}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=[lc.linkid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, EST_CARDINALITY=10000.0}) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation], EST_CARDINALITY=1.0, EST_COL_STATS={cl.culturenumber=[-1.0, -1.0], cl.specimennumber=[-1.0, -1.0], cl.sampleinsertts=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Sort(groups=[], props={SORT_ORDER=ORDER BY cl.culturenumber, cl.specimennumber, cl.sampleinsertts, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation]}) Select(groups=[cosara2.cos2_lab_culture AS cl], props={SELECT_CRITERIA=(cl.culturenumber IN ()) AND (cl.specimennumber IN ()) AND (cl.sampleinsertts IN ()), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation], EST_CARDINALITY=1.0, EST_COL_STATS={cl.culturenumber=[-1.0, -1.0], cl.specimennumber=[-1.0, -1.0], cl.sampleinsertts=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], ...}}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation], EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}, EST_CARDINALITY=80000.0}) ============================================================================ EXECUTING MergeCriteria AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl]) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc]) Project(groups=[]) Access(groups=[#tmp_adm2 AS adm]) Source(groups=[#tmp_adm2 AS adm]) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc]) Select(groups=[cosara2.cos2_links AS l]) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl]) Sort(groups=[]) Select(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_culture AS cl]) ============================================================================ EXECUTING PlanSorts AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l]) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], IS_COPIED=true, LEFT_EXPRESSIONS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], RIGHT_EXPRESSIONS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=51.66935, DEPENDENT_VALUE_SOURCE=$dsc/id3328, EST_COL_STATS={l.infectionid=[-1.0, -1.0], l.id=[-1.0, -1.0], lc.linkcultureid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, SORT_LEFT=SORT, IS_RIGHT_DISTINCT=true}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], LEFT_EXPRESSIONS=[convert(adm.patientid, string)], RIGHT_EXPRESSIONS=[l.admissionid], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=51.66935, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.culturesampleinsertts=[-1.0, -1.0], l.infectionid=[-1.0, -1.0], ...}, DEPENDENT_VALUE_SOURCE=$dsc/id3329, OUTPUT_COLS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], SORT_LEFT=SORT, IS_SEMI_DEP=true, SORT_RIGHT=SORT}) Project(groups=[]) Access(groups=[#tmp_adm2 AS adm]) Source(groups=[#tmp_adm2 AS adm]) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc]) Select(groups=[cosara2.cos2_links AS l]) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl]) Sort(groups=[]) Select(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_culture AS cl]) ============================================================================ EXECUTING CollapseSource AFTER: Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l], props={PROJECT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], OUTPUT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], EST_CARDINALITY=51.66935, EST_COL_STATS={l.infectionid=[-1.0, -1.0], l.id AS linkid=[-1.0, -1.0], lc.linkcultureid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}}) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl]) Join(groups=[#tmp_adm2 AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc]) Project(groups=[], props={PROJECT_COLS=[adm.patientid, convert(adm.patientid, string)], OUTPUT_COLS=[adm.patientid, convert(adm.patientid, string)]}) Access(groups=[#tmp_adm2 AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[adm.patientid], EST_CARDINALITY=1.0, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, ATOMIC_REQUEST=SELECT adm.patientid FROM #tmp_adm2 AS adm}) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], CONFORMED_SOURCES=null, EST_CARDINALITY=206.6774, EST_COL_STATS={l.admissionid=[-1.0, -1.0], lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.culturesampleinsertts=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true, ATOMIC_REQUEST=SELECT l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts FROM cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc WHERE (lc.linkid = l.id) AND (l.admissionid IN ())}) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation], EST_CARDINALITY=1.0, EST_COL_STATS={cl.culturenumber=[-1.0, -1.0], cl.specimennumber=[-1.0, -1.0], cl.sampleinsertts=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true, ATOMIC_REQUEST=SELECT cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation FROM cosara2.cos2_lab_culture AS cl WHERE (cl.culturenumber IN ()) AND (cl.specimennumber IN ()) AND (cl.sampleinsertts IN ()) ORDER BY cl.culturenumber, cl.specimennumber, cl.sampleinsertts}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = ProjectNode(0) output=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts] [l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts] JoinNode(1) [Dependent] [ENHANCED SORT JOIN (SORT/ALREADY_SORTED)] [LEFT OUTER JOIN] criteria=[lc.culturenr=cl.culturenumber, lc.culturespecimennr=cl.specimennumber, lc.culturesampleinsertts=cl.sampleinsertts] output=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts] JoinNode(2) [Dependent] [ENHANCED SORT JOIN [SEMI] (SORT/SORT)] [INNER JOIN] criteria=[convert(adm.patientid, string)=l.admissionid] output=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts] ProjectNode(3) output=[adm.patientid, convert(adm.patientid, string)] [adm.patientid, convert(adm.patientid, string)] AccessNode(4) output=[adm.patientid] SELECT #tmp_adm2.patientid FROM #tmp_adm2 DependentAccessNode(5) output=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts] SELECT g_0.admissionid, g_1.culturenr, g_1.culturespecimennr, g_1.culturesampleinsertts, g_0.infectionid, g_0.id, g_1.linkcultureid, g_1.responsibleculture, g_1.culturealternative, g_1.antibiogramculturenr, g_1.antibiogramspecimennr, g_1.antibiogramsampleinsertts FROM cosara2.cos2_links AS g_0, cosara2.cos2_link_culture AS g_1 WHERE (g_1.linkid = g_0.id) AND (g_0.admissionid IN ()) DependentAccessNode(6) output=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation] SELECT g_0.culturenumber AS c_0, g_0.specimennumber AS c_1, g_0.sampleinsertts AS c_2, g_0.culturename AS c_3, g_0.quotation AS c_4 FROM cosara2.cos2_lab_culture AS g_0 WHERE (g_0.culturenumber IN ()) AND (g_0.specimennumber IN ()) AND (g_0.sampleinsertts IN ()) ORDER BY c_0, c_1, c_2 ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: ProjectNode(0) output=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts] [l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts] JoinNode(1) [Dependent] [ENHANCED SORT JOIN (SORT/ALREADY_SORTED)] [LEFT OUTER JOIN] criteria=[lc.culturenr=cl.culturenumber, lc.culturespecimennr=cl.specimennumber, lc.culturesampleinsertts=cl.sampleinsertts] output=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts] JoinNode(2) [Dependent] [ENHANCED SORT JOIN [SEMI] (SORT/SORT)] [INNER JOIN] criteria=[convert(adm.patientid, string)=l.admissionid] output=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts] ProjectNode(3) output=[adm.patientid, convert(adm.patientid, string)] [adm.patientid, convert(adm.patientid, string)] AccessNode(4) output=[adm.patientid] SELECT #tmp_adm2.patientid FROM #tmp_adm2 DependentAccessNode(5) output=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts] SELECT g_0.admissionid, g_1.culturenr, g_1.culturespecimennr, g_1.culturesampleinsertts, g_0.infectionid, g_0.id, g_1.linkcultureid, g_1.responsibleculture, g_1.culturealternative, g_1.antibiogramculturenr, g_1.antibiogramspecimennr, g_1.antibiogramsampleinsertts FROM cosara2.cos2_links AS g_0, cosara2.cos2_link_culture AS g_1 WHERE (g_1.linkid = g_0.id) AND (g_0.admissionid IN ()) DependentAccessNode(6) output=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation] SELECT g_0.culturenumber AS c_0, g_0.specimennumber AS c_1, g_0.sampleinsertts AS c_2, g_0.culturename AS c_3, g_0.quotation AS c_4 FROM cosara2.cos2_lab_culture AS g_0 WHERE (g_0.culturenumber IN ()) AND (g_0.specimennumber IN ()) AND (g_0.sampleinsertts IN ()) ORDER BY c_0, c_1, c_2 ============================================================================