[teiid-issues] [JBoss JIRA] (TEIID-4265) Performance issue

[Juraj Duráni (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

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}

> Performance issue
> -----------------
>
>                 Key: TEIID-4265
>                 URL: https://issues.jboss.org/browse/TEIID-4265
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>            Reporter: Juraj Duráni
>            Assignee: Steven Hawkins
>         Attachments: dv-tpch-2.zip, plans_metadata.zip
>
>
> I can see reduce of performance for some kind of queries (see attachment).



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)