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 2015/10/20 23:08:27 UTC

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

Selvaganesan Govindarajan created TRAFODION-1546:
----------------------------------------------------

             Summary: 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


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.4#6332)