[
https://issues.apache.org/jira/browse/TRAFODION-2315?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15838260#comment-15838260
]
ASF GitHub Bot commented on TRAFODION-2315:
-------------------------------------------
GitHub user zellerh opened a pull request:
https://github.com/apache/incubator-trafodion/pull/928
[TRAFODION-2315] Heuristic decision for common subexpressions
This includes various fixes in addition to the heuristic decision,
mainly an improvement on how to navigate between parent and child
common subexpressions and improvement of support for statistics.
Also, see the comment in RelMisc.h (class CommonSubExprRef) for
a definition of some terminology.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/zellerh/incubator-trafodion bug/cses_jan-17
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/928.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #928
----
commit 2d41556888367183b20dfc75c815c309d59a428c
Author: Hans Zeller <[email protected]>
Date: 2017-01-25T17:37:42Z
[TRAFODION-2315] Heuristic decision for common subexpressions
This includes various fixes in addition to the heuristic decision,
mainly an improvement on how to navigate between parent and child
common subexpressions.
----
> Heuristic decision on when to use a temp table for WITH clause
> --------------------------------------------------------------
>
> Key: TRAFODION-2315
> URL: https://issues.apache.org/jira/browse/TRAFODION-2315
> Project: Apache Trafodion
> Issue Type: Sub-task
> Components: sql-cmp
> Reporter: Hans Zeller
> Assignee: Hans Zeller
>
> This is a follow-up to TRAFODION-2127.
> The code delivered for TRAFODION-2127 puts in the infrastructure to create a
> temp table, but it does not provide heuristics to decide automatically when
> to do this transformation. CQD CSE_USE_TEMP can only be used to force the
> transformation ON or OFF.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
