[ https://issues.jboss.org/browse/TEIID-4265?page=com.atlassian.jira.plugin... ] Juraj Duráni updated TEIID-4265: -------------------------------- Attachment: plans_metadata.zip ZIP archive contains metadata for 6.2.0.GA and for 6.3.0.ER3 and query plans for GA, ER3, ER4 and ER4.1. I have used first query from "02" set. All queries from "02" set are similar. {code:sql} select s_acctbal, s_name, n_name, p_partkey, p_mfgr, s_address, s_phone, s_comment from tpch2.tpch.part, tpch1.tpch.supplier, tpch2.tpch.partsupp, tpch1.tpch.nation, tpch1.tpch.region where p_partkey = ps_partkey and s_supplierkey = ps_supplierkey and p_size = 23 and p_type like '%COPPER' and s_nationkey = n_nationkey and n_regionkey = r_regionkey and r_name = 'AMERICA' and ps_supplycost = ( select min(ps_supplycost) from tpch2.tpch.partsupp, tpch1.tpch.supplier, tpch1.tpch.nation, tpch1.tpch.region where p_partkey = ps_partkey and s_supplierkey = ps_supplierkey and s_nationkey = n_nationkey and n_regionkey = r_regionkey and r_name = 'AMERICA' ) order by s_acctbal desc, n_name, s_name, p_partkey; {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)