You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@trafodion.apache.org by "Selvaganesan Govindarajan (JIRA)" <ji...@apache.org> on 2017/02/14 02:09:41 UTC

[jira] [Commented] (TRAFODION-1546) upsert into table with indexes performs slower than insert

    [ https://issues.apache.org/jira/browse/TRAFODION-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15864883#comment-15864883 ] 

Selvaganesan Govindarajan commented on TRAFODION-1546:
------------------------------------------------------

Added two scripts to test upsert/update with/without indexes

> upsert into table with indexes performs slower than insert
> ----------------------------------------------------------
>
>                 Key: TRAFODION-1546
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-1546
>             Project: Apache Trafodion
>          Issue Type: Bug
>            Reporter: Selvaganesan Govindarajan
>            Assignee: Selvaganesan Govindarajan
>         Attachments: query.sql, setup.sql
>
>   Original Estimate: 1m
>  Remaining Estimate: 1m
>
> The plan for upsert and insert are different, but both plans have vsbb operations enabled for index maintenance. But, it is observed that vsbb feature kicks in for insert while the upsert command inserts one row at a time in the index. Hence upsert command performs slower than the insert command.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)