============================================================================ USER COMMAND: SELECT DISTINCT channel.dbo.account.bic_status FROM channel.dbo.account ---------------------------------------------------------------------------- OPTIMIZE: SELECT DISTINCT channel.dbo.account.bic_status FROM channel.dbo.account ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT DISTINCT channel.dbo.account.bic_status FROM channel.dbo.account CANONICAL PLAN: DupRemoval(groups=[]) Project(groups=[channel.dbo.account], props={PROJECT_COLS=[channel.dbo.account.bic_status]}) Source(groups=[channel.dbo.account]) ============================================================================ EXECUTING PlaceAccess AFTER: DupRemoval(groups=[]) Project(groups=[channel.dbo.account], props={PROJECT_COLS=[channel.dbo.account.bic_status]}) Access(groups=[channel.dbo.account], props={SOURCE_HINT=null, MODEL_ID=Schema name=channel, nameInSource=null, uuid=tid:cafba140f5cf-2c0b7d03-00000000, IS_MULTI_SOURCE=true}) Source(groups=[channel.dbo.account]) ============================================================================ EXECUTING RaiseAccess LOW [Relational Planner] not all columns are comparable at the source channel - cannot push dupremove DupRemoval(groups=[] AFTER: DupRemoval(groups=[]) Access(groups=[channel.dbo.account], props={SOURCE_HINT=null, MODEL_ID=Schema name=channel, nameInSource=null, uuid=tid:cafba140f5cf-2c0b7d03-00000000, IS_MULTI_SOURCE=true}) Project(groups=[channel.dbo.account], props={PROJECT_COLS=[channel.dbo.account.bic_status]}) Source(groups=[channel.dbo.account]) ============================================================================ EXECUTING AssignOutputElements AFTER: DupRemoval(groups=[], props={OUTPUT_COLS=[channel.dbo.account.bic_status]}) Access(groups=[channel.dbo.account], props={SOURCE_HINT=null, MODEL_ID=Schema name=channel, nameInSource=null, uuid=tid:cafba140f5cf-2c0b7d03-00000000, IS_MULTI_SOURCE=true, OUTPUT_COLS=[channel.dbo.account.bic_status]}) Project(groups=[channel.dbo.account], props={PROJECT_COLS=[channel.dbo.account.bic_status], OUTPUT_COLS=[channel.dbo.account.bic_status]}) Source(groups=[channel.dbo.account], props={OUTPUT_COLS=[channel.dbo.account.bic_status]}) ============================================================================ EXECUTING CalculateCost AFTER: DupRemoval(groups=[], props={OUTPUT_COLS=[channel.dbo.account.bic_status], EST_CARDINALITY=101732.75, EST_COL_STATS={channel.dbo.account.bic_status=[637.0, 101732.75, -1.0]}}) Access(groups=[channel.dbo.account], props={SOURCE_HINT=null, MODEL_ID=Schema name=channel, nameInSource=null, uuid=tid:cafba140f5cf-2c0b7d03-00000000, IS_MULTI_SOURCE=true, OUTPUT_COLS=[channel.dbo.account.bic_status], EST_CARDINALITY=405657.0, EST_COL_STATS={channel.dbo.account.bic_status=[637.0, 202828.5, -1.0]}}) Project(groups=[channel.dbo.account], props={PROJECT_COLS=[channel.dbo.account.bic_status], OUTPUT_COLS=[channel.dbo.account.bic_status], EST_CARDINALITY=405657.0, EST_COL_STATS={channel.dbo.account.bic_status=[637.0, 202828.5, -1.0]}}) Source(groups=[channel.dbo.account], props={OUTPUT_COLS=[channel.dbo.account.bic_status], EST_COL_STATS={channel.dbo.account.bic_status=[637.0, 202828.5, -1.0]}, EST_CARDINALITY=405657.0}) ============================================================================ EXECUTING PlanSorts AFTER: DupRemoval(groups=[]) Access(groups=[channel.dbo.account]) Project(groups=[channel.dbo.account]) Source(groups=[channel.dbo.account]) ============================================================================ EXECUTING CollapseSource AFTER: DupRemoval(groups=[]) Access(groups=[channel.dbo.account], props={SOURCE_HINT=null, MODEL_ID=Schema name=channel, nameInSource=null, uuid=tid:cafba140f5cf-2c0b7d03-00000000, IS_MULTI_SOURCE=true, OUTPUT_COLS=[channel.dbo.account.bic_status], EST_CARDINALITY=405657.0, EST_COL_STATS={channel.dbo.account.bic_status=[637.0, 202828.5, -1.0]}, ATOMIC_REQUEST=SELECT channel.dbo.account.bic_status FROM channel.dbo.account}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = DupRemoveNode(0) output=[channel.dbo.account.bic_status] AccessNode(1) output=[channel.dbo.account.bic_status] SELECT g_0.bic_status FROM channel.dbo.account AS g_0 ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: DupRemoveNode(0) output=[channel.dbo.account.bic_status] AccessNode(1) output=[channel.dbo.account.bic_status] SELECT g_0.bic_status FROM channel.dbo.account AS g_0 ============================================================================