You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:16:03 UTC
[jira] [Created] (TRAFODION-443) LP Bug: 1342141 - Performance:
OLTP plans not used, many esps created.
Alice Chen created TRAFODION-443:
------------------------------------
Summary: LP Bug: 1342141 - Performance: OLTP plans not used, many esps created.
Key: TRAFODION-443
URL: https://issues.apache.org/jira/browse/TRAFODION-443
Project: Apache Trafodion
Issue Type: Bug
Components: sql-cmp
Reporter: Guy Groulx
Assignee: Qifan Chen
Priority: Blocker
Starting with the file trafodion-20140709_0830.tar.gz bundle, simple queries that should be using OLTP optimization now use parallel plans that create lots of esps.
SQL>prepare cmd from select PRIM_VALUE, INTEGER_FACT from trafodion.javabench.ed_table_25 where PRIM_KEY = ?;
SQL>explain options 'f' cmd;
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
2 . 3 root 1.00E+000
1 . 2 esp_exchange 1:10(range) 1.00E+000
. . 1 trafodion_scan ED_TABLE_25 1.00E+000
--- SQL operation complete.
Should simply be:
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
1 . 2 root o 1.00E+000
. . 1 trafodion_scan ED_TABLE_25 1.00E+000
--- SQL operation complete.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)