[ https://issues.jboss.org/browse/TEIID-3580?page=com.atlassian.jira.plugin... ] Vijay Bhaskar Chintalapati commented on TEIID-3580: --------------------------------------------------- Yes its the same data source used both by web app and Teiid together. The query is 'select * from HDP.sample_07'. HDP here is the Source Model I am exposing in the VDB. So there is no difference in query plan. Below is part of the server log: EXECUTING CalculateCost AFTER: Access(groups=[HDP1.sample_07], props={SOURCE_HINT=null, MODEL_ID=Schema name=HDP1, nameInSource=null, uuid=mmuuid:004c32d9-8675-49cb-88ab-9d3635e08885, OUTPUT_COLS=[HDP1.sample_07.code, HDP1.sample_07.description, HDP1.sample_07.total_emp, HDP1.sample_07.salary], EST_CARDINALITY=-1.0}) Project(groups=[HDP1.sample_07], props={PROJECT_COLS=[HDP1.sample_07.code, HDP1.sample_07.description, HDP1.sample_07.total_emp, HDP1.sample_07.salary], OUTPUT_COLS=[HDP1.sample_07.code, HDP1.sample_07.description, HDP1.sample_07.total_emp, HDP1.sample_07.salary], EST_CARDINALITY=-1.0}) Source(groups=[HDP1.sample_07], props={OUTPUT_COLS=[HDP1.sample_07.code, HDP1.sample_07.description, HDP1.sample_07.total_emp, HDP1.sample_07.salary], EST_COL_STATS={HDP1.sample_07.code=[-1.0, -1.0], HDP1.sample_07.description=[-1.0, -1.0], HDP1.sample_07.total_emp=[-1.0, -1.0], HDP1.sample_07.salary=[-1.0, -1.0]}, EST_CARDINALITY=-1.0}) ============================================================================ EXECUTING PlanSorts AFTER: Access(groups=[HDP1.sample_07]) Project(groups=[HDP1.sample_07]) Source(groups=[HDP1.sample_07]) ============================================================================ EXECUTING CollapseSource AFTER: Access(groups=[HDP1.sample_07], props={SOURCE_HINT=null, MODEL_ID=Schema name=HDP1, nameInSource=null, uuid=mmuuid:004c32d9-8675-49cb-88ab-9d3635e08885, OUTPUT_COLS=[HDP1.sample_07.code, HDP1.sample_07.description, HDP1.sample_07.total_emp, HDP1.sample_07.salary], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=SELECT HDP1.sample_07.code, HDP1.sample_07.description, HDP1.sample_07.total_emp, HDP1.sample_07.salary FROM HDP1.sample_07}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = AccessNode(0) output=[HDP1.sample_07.code, HDP1.sample_07.description, HDP1.sample_07.total_emp, HDP1.sample_07.salary] SELECT g_0.code, g_0.description, g_0.total_emp, g_0.salary FROM HDP1.sample_07 AS g_0 ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: AccessNode(0) output=[HDP1.sample_07.code, HDP1.sample_07.description, HDP1.sample_07.total_emp, HDP1.sample_07.salary] SELECT g_0.code, g_0.description, g_0.total_emp, g_0.salary FROM HDP1.sample_07 AS g_0 ============================================================================ -- This message was sent by Atlassian JIRA (v6.3.15#6346)