[
https://issues.apache.org/jira/browse/TRAFODION-1562?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15651870#comment-15651870
]
ASF GitHub Bot commented on TRAFODION-1562:
-------------------------------------------
GitHub user sandhyasun opened a pull request:
https://github.com/apache/incubator-trafodion/pull/826
{TRAFODION-1562] Index maintenence performance improvements
Changes to transform an upsert plan into an efficient plan when indexes are
present and allow for rowset type operations. The plan makes use of existing
operators to eliminate duplicates at the source so we don't need to perform a
row at a time check and put operation. The code is currently turned off with a
CD traf_upsert_to_eff_tree.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/sandhyasun/incubator-trafodion
xform_traf_work2
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/826.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 #826
----
commit 851733596b226fd16aa8175573559c24fd2908bb
Author: Sandhya Sundaresan <[email protected]>
Date: 2016-11-09T19:27:49Z
Changes to transform an upsert plan into an efficient plan when indexes are
present and allow for rowset type operations. The plan makes use of existing
operators to eliminate duplicates at the source so we don't need to perform a
row at a time check and put operation. The code is currently turned off with a
CD traf_upsert_to_eff_tree.
----
> Changes in query tree when the upsert command is transformed into merge
> -----------------------------------------------------------------------
>
> Key: TRAFODION-1562
> URL: https://issues.apache.org/jira/browse/TRAFODION-1562
> Project: Apache Trafodion
> Issue Type: Sub-task
> Components: sql-cmp
> Reporter: Selvaganesan Govindarajan
> Assignee: Sandhya Sundaresan
> Attachments: BatchUpsertTransformation.pdf
>
>
> to improve the performance as explained in the main JIRA
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
