SAP Knowledge Base Article - Preview

3307111 - Degraded UPSERT performance due to INVERTED INDIVIDUAL index

Symptom

Performance of UPSERT statements is worse then expected. Relevant call stacks of involved worker threads typically look like this:

...
TRexAPI::UdivLookupQuery::doSearch
TRexAPI::UdivLookupQuery::execute
TRexAPI::Dml::UdivUpdateWithoutConcat::runLookup
TRexAPI::Dml::UdivUpdate::execute
TRexAPI::Dml::UdivUpdate::executeImpl
TRexAPI::Dml::PlanOperation::execute
TRexAPI::Dml::SequentialPlan::executePlanOps
TRexAPI::Dml::Plan::execute
TRexAPI::Dml::SequentialPlan::executePlanOps
TRexAPI::Dml::Plan::execute
TRexAPI::Dml::SequentialPlan::executePlanOps
...


Read more...

Environment

SAP HANA, platform edition 2.0

Product

SAP HANA, platform edition 2.0

Keywords

KBA , HAN-DB-PERF , SAP HANA Database Performance , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.