[
https://issues.apache.org/jira/browse/TRAFODION-27?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Suresh Subbiah reassigned TRAFODION-27:
---------------------------------------
Assignee: Selvaganesan Govindarajan
> Time consuming compilation for queries of BLOB with JOINs
> ----------------------------------------------------------
>
> Key: TRAFODION-27
> URL: https://issues.apache.org/jira/browse/TRAFODION-27
> Project: Apache Trafodion
> Issue Type: Bug
> Environment: Trafodion 1.2, HDP 2.2, CentOS 6
> Reporter: Haifeng Li
> Assignee: Selvaganesan Govindarajan
> Priority: Minor
> Attachments: trafodion27_qry.sql, trafodion27_setup.sql
>
>
> It takes 3 ~ 5 seconds to compile a query that returns a BLOB field by
> joining two tables. If a query is cached and subsequent queries are 'similar'
> to
> the initial query, those subsequence compilation times will usually be
> much faster. However, sometimes we observe that subsequent queries with
> literal difference still take long time in sqlci.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
