============================================================================ USER COMMAND: SELECT #Cataruw.patientid, #Cataruw.ordernumber, #Cataruw.givenat, #Cataruw.givendate, #Cataruw.givendose FROM #Cataruw ---------------------------------------------------------------------------- OPTIMIZE: SELECT #Cataruw.patientid, #Cataruw.ordernumber, #Cataruw.givenat, #Cataruw.givendate, #Cataruw.givendose FROM #Cataruw ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT #Cataruw.patientid, #Cataruw.ordernumber, #Cataruw.givenat, #Cataruw.givendate, #Cataruw.givendose FROM #Cataruw CANONICAL PLAN: Project(groups=[#Cataruw], props={PROJECT_COLS=[#Cataruw.patientid, #Cataruw.ordernumber, #Cataruw.givenat, #Cataruw.givendate, #Cataruw.givendose]}) Source(groups=[#Cataruw]) ============================================================================ EXECUTING PlaceAccess AFTER: Project(groups=[#Cataruw], props={PROJECT_COLS=[#Cataruw.patientid, #Cataruw.ordernumber, #Cataruw.givenat, #Cataruw.givendate, #Cataruw.givendose]}) Access(groups=[#Cataruw], props={SOURCE_HINT=null, MODEL_ID=__TEMP__}) Source(groups=[#Cataruw]) ============================================================================ EXECUTING RaiseAccess AFTER: Access(groups=[#Cataruw], props={SOURCE_HINT=null, MODEL_ID=__TEMP__}) Project(groups=[#Cataruw], props={PROJECT_COLS=[#Cataruw.patientid, #Cataruw.ordernumber, #Cataruw.givenat, #Cataruw.givendate, #Cataruw.givendose]}) Source(groups=[#Cataruw]) ============================================================================ EXECUTING AssignOutputElements AFTER: Access(groups=[#Cataruw], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[#Cataruw.patientid, #Cataruw.ordernumber, #Cataruw.givenat, #Cataruw.givendate, #Cataruw.givendose]}) Project(groups=[#Cataruw], props={PROJECT_COLS=[#Cataruw.patientid, #Cataruw.ordernumber, #Cataruw.givenat, #Cataruw.givendate, #Cataruw.givendose], OUTPUT_COLS=[#Cataruw.patientid, #Cataruw.ordernumber, #Cataruw.givenat, #Cataruw.givendate, #Cataruw.givendose]}) Source(groups=[#Cataruw], props={OUTPUT_COLS=[#Cataruw.patientid, #Cataruw.ordernumber, #Cataruw.givenat, #Cataruw.givendate, #Cataruw.givendose]}) ============================================================================ EXECUTING CalculateCost AFTER: Access(groups=[#Cataruw], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[#Cataruw.patientid, #Cataruw.ordernumber, #Cataruw.givenat, #Cataruw.givendate, #Cataruw.givendose], EST_CARDINALITY=168351.0, EST_COL_STATS={#Cataruw.patientid=[-1.0, -1.0], #Cataruw.ordernumber=[-1.0, -1.0], #Cataruw.givenat=[-1.0, -1.0], #Cataruw.givendate=[-1.0, -1.0], ...}}) Project(groups=[#Cataruw], props={PROJECT_COLS=[#Cataruw.patientid, #Cataruw.ordernumber, #Cataruw.givenat, #Cataruw.givendate, #Cataruw.givendose], OUTPUT_COLS=[#Cataruw.patientid, #Cataruw.ordernumber, #Cataruw.givenat, #Cataruw.givendate, #Cataruw.givendose], EST_CARDINALITY=168351.0, EST_COL_STATS={#Cataruw.patientid=[-1.0, -1.0], #Cataruw.ordernumber=[-1.0, -1.0], #Cataruw.givenat=[-1.0, -1.0], #Cataruw.givendate=[-1.0, -1.0], ...}}) Source(groups=[#Cataruw], props={OUTPUT_COLS=[#Cataruw.patientid, #Cataruw.ordernumber, #Cataruw.givenat, #Cataruw.givendate, #Cataruw.givendose], EST_COL_STATS={#Cataruw.patientid=[-1.0, -1.0], #Cataruw.ordernumber=[-1.0, -1.0], #Cataruw.givenat=[-1.0, -1.0], #Cataruw.givendate=[-1.0, -1.0], ...}, EST_CARDINALITY=168351.0}) ============================================================================ EXECUTING PlanSorts AFTER: Access(groups=[#Cataruw]) Project(groups=[#Cataruw]) Source(groups=[#Cataruw]) ============================================================================ EXECUTING CollapseSource AFTER: Access(groups=[#Cataruw], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[#Cataruw.patientid, #Cataruw.ordernumber, #Cataruw.givenat, #Cataruw.givendate, #Cataruw.givendose], EST_CARDINALITY=168351.0, EST_COL_STATS={#Cataruw.patientid=[-1.0, -1.0], #Cataruw.ordernumber=[-1.0, -1.0], #Cataruw.givenat=[-1.0, -1.0], #Cataruw.givendate=[-1.0, -1.0], ...}, ATOMIC_REQUEST=SELECT #Cataruw.patientid, #Cataruw.ordernumber, #Cataruw.givenat, #Cataruw.givendate, #Cataruw.givendose FROM #Cataruw}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = AccessNode(0) output=[#Cataruw.patientid, #Cataruw.ordernumber, #Cataruw.givenat, #Cataruw.givendate, #Cataruw.givendose] SELECT #Cataruw.patientid, #Cataruw.ordernumber, #Cataruw.givenat, #Cataruw.givendate, #Cataruw.givendose FROM #Cataruw ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: AccessNode(0) output=[#Cataruw.patientid, #Cataruw.ordernumber, #Cataruw.givenat, #Cataruw.givendate, #Cataruw.givendose] SELECT #Cataruw.patientid, #Cataruw.ordernumber, #Cataruw.givenat, #Cataruw.givendate, #Cataruw.givendose FROM #Cataruw ============================================================================