============================================================================ 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, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts 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) LEFT OUTER JOIN cosara2.cos2_lab_sample AS ls ON ls.inserttime = cl.sampleinsertts AND ls.specimennumber = cl.specimennumber) LEFT OUTER JOIN cosara2.cos2_antibiogramresistences AS abr ON abr.specimennumber = cl.specimennumber AND abr.culturenumber = cl.culturenumber AND abr.sampleinsertts = cl.sampleinsertts ORDER BY l.infectionid, lc.linkcultureid ---------------------------------------------------------------------------- OPTIMIZE: SELECT l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts 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) LEFT OUTER JOIN cosara2.cos2_lab_sample AS ls ON ls.inserttime = cl.sampleinsertts AND ls.specimennumber = cl.specimennumber) LEFT OUTER JOIN cosara2.cos2_antibiogramresistences AS abr ON abr.specimennumber = cl.specimennumber AND abr.culturenumber = cl.culturenumber AND abr.sampleinsertts = cl.sampleinsertts ORDER BY l.infectionid, lc.linkcultureid ---------------------------------------------------------------------------- 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, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts 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) LEFT OUTER JOIN cosara2.cos2_lab_sample AS ls ON ls.inserttime = cl.sampleinsertts AND ls.specimennumber = cl.specimennumber) LEFT OUTER JOIN cosara2.cos2_antibiogramresistences AS abr ON abr.specimennumber = cl.specimennumber AND abr.culturenumber = cl.culturenumber AND abr.sampleinsertts = cl.sampleinsertts ORDER BY l.infectionid, lc.linkcultureid CANONICAL PLAN: Sort(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l], props={SORT_ORDER=ORDER BY l.infectionid, lc.linkcultureid}) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, 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, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber]}) 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]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING PlaceAccess AFTER: Sort(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l], props={SORT_ORDER=ORDER BY l.infectionid, lc.linkcultureid}) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, 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, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber]}) 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]) Access(groups=[cosara2.cos2_lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896}) Source(groups=[cosara2.cos2_lab_sample AS ls]) Access(groups=[cosara2.cos2_antibiogramresistences AS abr], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896}) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING AssignOutputElements AFTER: Sort(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l], props={SORT_ORDER=ORDER BY l.infectionid, lc.linkcultureid, OUTPUT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], UNRELATED_SORT=false}) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, 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, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], OUTPUT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], OUTPUT_COLS=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], OUTPUT_COLS=[cl.specimennumber, cl.culturenumber, cl.sampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.culturename, cl.quotation, ls.material, ls.sampletime, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) 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=[cl.sampleinsertts, cl.specimennumber, cl.culturenumber, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) 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]}) Access(groups=[cosara2.cos2_lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[ls.inserttime, ls.specimennumber, ls.material, ls.sampletime]}) Source(groups=[cosara2.cos2_lab_sample AS ls], props={OUTPUT_COLS=[ls.inserttime, ls.specimennumber, ls.material, ls.sampletime]}) Access(groups=[cosara2.cos2_antibiogramresistences AS abr], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[abr.specimennumber, abr.culturenumber, abr.sampleinsertts, abr.antibiogrampart, abr.resisttype]}) Source(groups=[cosara2.cos2_antibiogramresistences AS abr], props={OUTPUT_COLS=[abr.specimennumber, abr.culturenumber, abr.sampleinsertts, abr.antibiogrampart, abr.resisttype]}) ============================================================================ EXECUTING RemoveOptionalJoins AFTER: Sort(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, 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, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], OUTPUT_COLS=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], OUTPUT_COLS=[cl.specimennumber, cl.culturenumber, cl.sampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.culturename, cl.quotation, ls.material, ls.sampletime, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) 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=[cl.sampleinsertts, cl.specimennumber, cl.culturenumber, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) 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]) Access(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Access(groups=[cosara2.cos2_antibiogramresistences AS abr]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING PushNonJoinCriteria AFTER: Sort(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, 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, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], OUTPUT_COLS=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], OUTPUT_COLS=[cl.specimennumber, cl.culturenumber, cl.sampleinsertts, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.culturename, cl.quotation, ls.material, ls.sampletime, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) 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=[cl.sampleinsertts, cl.specimennumber, cl.culturenumber, l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.culturename, cl.quotation, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) 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]) Access(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Access(groups=[cosara2.cos2_antibiogramresistences AS abr]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING CleanCriteria AFTER: Sort(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l], props={SORT_ORDER=ORDER BY l.infectionid, lc.linkcultureid, OUTPUT_COLS=null, UNRELATED_SORT=false}) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, 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, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], 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, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], 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, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], 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}) Access(groups=[cosara2.cos2_lab_sample AS ls], 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_sample AS ls], props={OUTPUT_COLS=null}) Access(groups=[cosara2.cos2_antibiogramresistences AS abr], 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_antibiogramresistences AS abr], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING RaiseAccess AFTER: Sort(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, 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, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], 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, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], 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]) 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]) Access(groups=[cosara2.cos2_lab_sample AS ls], 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_sample AS ls]) Access(groups=[cosara2.cos2_antibiogramresistences AS abr], 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_antibiogramresistences AS abr]) ============================================================================ EXECUTING CopyCriteria AFTER: Sort(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, 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, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], OUTPUT_COLS=null, IS_COPIED=true}) 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]) Access(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Access(groups=[cosara2.cos2_antibiogramresistences AS abr]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING CleanCriteria AFTER: Sort(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l], props={SORT_ORDER=ORDER BY l.infectionid, lc.linkcultureid, OUTPUT_COLS=null, UNRELATED_SORT=false}) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, 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, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], 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, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], OUTPUT_COLS=null, IS_COPIED=true}) 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}) Access(groups=[cosara2.cos2_lab_sample AS ls], 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_sample AS ls], props={OUTPUT_COLS=null}) Access(groups=[cosara2.cos2_antibiogramresistences AS abr], 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_antibiogramresistences AS abr], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING PlanJoins AFTER: Sort(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, 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, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], OUTPUT_COLS=null, IS_COPIED=true}) 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]) Access(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Access(groups=[cosara2.cos2_antibiogramresistences AS abr]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING PushSelectCriteria AFTER: Sort(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, 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, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls]) 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]) Access(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Access(groups=[cosara2.cos2_antibiogramresistences AS abr]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING RaiseAccess AFTER: Sort(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, 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, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], OUTPUT_COLS=null, IS_COPIED=true}) 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]) Access(groups=[cosara2.cos2_lab_sample AS ls], 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_sample AS ls]) Access(groups=[cosara2.cos2_antibiogramresistences AS abr], 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_antibiogramresistences AS abr]) ============================================================================ EXECUTING PlanOuterJoins AFTER: Sort(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, 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, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], 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, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], 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=[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, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null, CONFORMED_SOURCES=null}) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896}) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_lab_sample AS ls], props={OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_antibiogramresistences AS abr], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING ChooseJoinStrategy AFTER: Sort(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, 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, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], 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, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING ChooseDependent AFTER: Sort(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, 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, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], 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, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], 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=301224.2, 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], ...}}) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=301224.2, 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], ...}}) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=259235.25, 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}) Source(groups=[cosara2.cos2_lab_sample AS ls], props={OUTPUT_COLS=null, EST_COL_STATS={ls.inserttime=[-1.0, -1.0], ls.labordernumber=[-1.0, -1.0], ls.material=[-1.0, -1.0], ls.mnemonic=[-1.0, -1.0], ...}, EST_CARDINALITY=210000.0}) Source(groups=[cosara2.cos2_antibiogramresistences AS abr], props={OUTPUT_COLS=null, EST_COL_STATS={abr.specimennumber=[-1.0, -1.0], abr.culturenumber=[-1.0, -1.0], abr.antibiogrampart=[-1.0, -1.0], abr.resisttype=[-1.0, -1.0], ...}, EST_CARDINALITY=350000.0}) ============================================================================ EXECUTING AssignOutputElements AFTER: Sort(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l], props={SORT_ORDER=ORDER BY l.infectionid, lc.linkcultureid, OUTPUT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], UNRELATED_SORT=false}) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, 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, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], OUTPUT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], LEFT_EXPRESSIONS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], RIGHT_EXPRESSIONS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null, OUTPUT_COLS=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) 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, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], 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, ls.material, ls.sampletime, abr.culturenumber, abr.antibiogrampart, abr.resisttype], CONFORMED_SOURCES=null, EST_CARDINALITY=301224.2, 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], ...}}) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=301224.2, 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], ...}, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber, abr.antibiogrampart, abr.resisttype]}) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=259235.25, 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], ...}, OUTPUT_COLS=[cl.specimennumber, cl.culturenumber, cl.sampleinsertts, cl.culturename, cl.quotation, ls.material, ls.sampletime]}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=[cl.sampleinsertts, cl.specimennumber, cl.culturenumber, 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}) Source(groups=[cosara2.cos2_lab_sample AS ls], props={OUTPUT_COLS=[ls.inserttime, ls.specimennumber, ls.material, ls.sampletime], EST_COL_STATS={ls.inserttime=[-1.0, -1.0], ls.labordernumber=[-1.0, -1.0], ls.material=[-1.0, -1.0], ls.mnemonic=[-1.0, -1.0], ...}, EST_CARDINALITY=210000.0}) Source(groups=[cosara2.cos2_antibiogramresistences AS abr], props={OUTPUT_COLS=[abr.specimennumber, abr.culturenumber, abr.sampleinsertts, abr.antibiogrampart, abr.resisttype], EST_COL_STATS={abr.specimennumber=[-1.0, -1.0], abr.culturenumber=[-1.0, -1.0], abr.antibiogrampart=[-1.0, -1.0], abr.resisttype=[-1.0, -1.0], ...}, EST_CARDINALITY=350000.0}) ============================================================================ EXECUTING CalculateCost AFTER: Sort(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l], props={SORT_ORDER=ORDER BY l.infectionid, lc.linkcultureid, OUTPUT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], UNRELATED_SORT=false, EST_CARDINALITY=53185.15, 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], ...}}) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, 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, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], OUTPUT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], EST_CARDINALITY=53185.15, 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, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], LEFT_EXPRESSIONS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], RIGHT_EXPRESSIONS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=53185.15, OUTPUT_COLS=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], 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, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], 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, ls.material, ls.sampletime, abr.culturenumber, abr.antibiogrampart, abr.resisttype], CONFORMED_SOURCES=null, EST_CARDINALITY=301224.2, 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], ...}}) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=301224.2, 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], ...}, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber, abr.antibiogrampart, abr.resisttype]}) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=259235.25, 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], ...}, OUTPUT_COLS=[cl.specimennumber, cl.culturenumber, cl.sampleinsertts, cl.culturename, cl.quotation, ls.material, ls.sampletime]}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=[cl.sampleinsertts, cl.specimennumber, cl.culturenumber, 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}) Source(groups=[cosara2.cos2_lab_sample AS ls], props={OUTPUT_COLS=[ls.inserttime, ls.specimennumber, ls.material, ls.sampletime], EST_COL_STATS={ls.inserttime=[-1.0, -1.0], ls.labordernumber=[-1.0, -1.0], ls.material=[-1.0, -1.0], ls.mnemonic=[-1.0, -1.0], ...}, EST_CARDINALITY=210000.0}) Source(groups=[cosara2.cos2_antibiogramresistences AS abr], props={OUTPUT_COLS=[abr.specimennumber, abr.culturenumber, abr.sampleinsertts, abr.antibiogrampart, abr.resisttype], EST_COL_STATS={abr.specimennumber=[-1.0, -1.0], abr.culturenumber=[-1.0, -1.0], abr.antibiogrampart=[-1.0, -1.0], abr.resisttype=[-1.0, -1.0], ...}, EST_CARDINALITY=350000.0}) ============================================================================ EXECUTING ImplementJoinStrategy AFTER: Sort(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, 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, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], LEFT_EXPRESSIONS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], RIGHT_EXPRESSIONS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=53185.15, OUTPUT_COLS=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], 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}) 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, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], 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, ls.material, ls.sampletime, abr.culturenumber, abr.antibiogrampart, abr.resisttype], CONFORMED_SOURCES=null, EST_CARDINALITY=301224.2, 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.culturenumber, cl.specimennumber, cl.sampleinsertts, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber, abr.antibiogrampart, abr.resisttype]}) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=301224.2, 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], ...}, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber, abr.antibiogrampart, abr.resisttype]}) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=259235.25, 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], ...}, OUTPUT_COLS=[cl.specimennumber, cl.culturenumber, cl.sampleinsertts, cl.culturename, cl.quotation, ls.material, ls.sampletime]}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=[cl.sampleinsertts, cl.specimennumber, cl.culturenumber, 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}) Source(groups=[cosara2.cos2_lab_sample AS ls], props={OUTPUT_COLS=[ls.inserttime, ls.specimennumber, ls.material, ls.sampletime], EST_COL_STATS={ls.inserttime=[-1.0, -1.0], ls.labordernumber=[-1.0, -1.0], ls.material=[-1.0, -1.0], ls.mnemonic=[-1.0, -1.0], ...}, EST_CARDINALITY=210000.0}) Source(groups=[cosara2.cos2_antibiogramresistences AS abr], props={OUTPUT_COLS=[abr.specimennumber, abr.culturenumber, abr.sampleinsertts, abr.antibiogrampart, abr.resisttype], EST_COL_STATS={abr.specimennumber=[-1.0, -1.0], abr.culturenumber=[-1.0, -1.0], abr.antibiogrampart=[-1.0, -1.0], abr.resisttype=[-1.0, -1.0], ...}, EST_CARDINALITY=350000.0}) ============================================================================ EXECUTING MergeCriteria AFTER: Sort(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, 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, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) 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, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Sort(groups=[]) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING PlanSorts AFTER: Sort(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l], props={SORT_ORDER=ORDER BY l.infectionid, lc.linkcultureid, OUTPUT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], UNRELATED_SORT=false, EST_CARDINALITY=53185.15, 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], ...}}) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, 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, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], LEFT_EXPRESSIONS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], RIGHT_EXPRESSIONS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=53185.15, OUTPUT_COLS=[l.infectionid, l.id, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], 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}) 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, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Sort(groups=[]) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING CollapseSource AFTER: Sort(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, 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, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], OUTPUT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts], EST_CARDINALITY=53185.15, 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, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) 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, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], 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, ls.material, ls.sampletime, abr.culturenumber, abr.antibiogrampart, abr.resisttype], CONFORMED_SOURCES=null, EST_CARDINALITY=301224.2, 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, ls.material, ls.sampletime, abr.culturenumber, abr.antibiogrampart, abr.resisttype FROM (cosara2.cos2_lab_culture AS cl LEFT OUTER JOIN cosara2.cos2_lab_sample AS ls ON ls.inserttime = cl.sampleinsertts AND ls.specimennumber = cl.specimennumber) LEFT OUTER JOIN cosara2.cos2_antibiogramresistences AS abr ON abr.specimennumber = cl.specimennumber AND abr.culturenumber = cl.culturenumber AND abr.sampleinsertts = cl.sampleinsertts ORDER BY cl.culturenumber, cl.specimennumber, cl.sampleinsertts}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = SortNode(0) output=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts] [SORT] [l.infectionid, lc.linkcultureid] ProjectNode(1) output=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts] [l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts] JoinNode(2) [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, ls.material, ls.sampletime, abr.culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts] JoinNode(3) [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(4) output=[adm.patientid, convert(adm.patientid, string)] [adm.patientid, convert(adm.patientid, string)] AccessNode(5) output=[adm.patientid] SELECT #tmp_admissions.patientid FROM #tmp_admissions AccessNode(6) 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(7) output=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber, abr.antibiogrampart, abr.resisttype] 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, g_1.material AS c_5, g_1.sampletime AS c_6, g_2.culturenumber AS c_7, g_2.antibiogrampart AS c_8, g_2.resisttype AS c_9 FROM (cosara2.cos2_lab_culture AS g_0 LEFT OUTER JOIN cosara2.cos2_lab_sample AS g_1 ON g_1.inserttime = g_0.sampleinsertts AND g_1.specimennumber = g_0.specimennumber) LEFT OUTER JOIN cosara2.cos2_antibiogramresistences AS g_2 ON g_2.specimennumber = g_0.specimennumber AND g_2.culturenumber = g_0.culturenumber AND g_2.sampleinsertts = g_0.sampleinsertts ORDER BY c_0, c_1, c_2 ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: SortNode(0) output=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts] [SORT] [l.infectionid, lc.linkcultureid] ProjectNode(1) output=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts] [l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts] JoinNode(2) [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, ls.material, ls.sampletime, abr.culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts] JoinNode(3) [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(4) output=[adm.patientid, convert(adm.patientid, string)] [adm.patientid, convert(adm.patientid, string)] AccessNode(5) output=[adm.patientid] SELECT #tmp_admissions.patientid FROM #tmp_admissions AccessNode(6) 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(7) output=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber, abr.antibiogrampart, abr.resisttype] 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, g_1.material AS c_5, g_1.sampletime AS c_6, g_2.culturenumber AS c_7, g_2.antibiogrampart AS c_8, g_2.resisttype AS c_9 FROM (cosara2.cos2_lab_culture AS g_0 LEFT OUTER JOIN cosara2.cos2_lab_sample AS g_1 ON g_1.inserttime = g_0.sampleinsertts AND g_1.specimennumber = g_0.specimennumber) LEFT OUTER JOIN cosara2.cos2_antibiogramresistences AS g_2 ON g_2.specimennumber = g_0.specimennumber AND g_2.culturenumber = g_0.culturenumber AND g_2.sampleinsertts = g_0.sampleinsertts ORDER BY c_0, c_1, c_2 ============================================================================