[
https://issues.apache.org/jira/browse/TRAFODION-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Selvaganesan Govindarajan reassigned TRAFODION-1546:
----------------------------------------------------
Assignee: Selvaganesan Govindarajan
> 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
> 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.4#6332)
