[
https://issues.apache.org/jira/browse/TRAFODION-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sandhya Sundaresan resolved TRAFODION-1546.
-------------------------------------------
Resolution: Fixed
> 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: Sandhya Sundaresan
> Attachments: query.out, 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)
