SAP Knowledge Base Article - Preview

3481823 - Resolving Performance Issues with UPSERT SQL Statements Using LocalUniqueConstraintTask

Symptom

  • UPSERT operations on large partitioned tables experience performance issues. 
  • The SQL statement appears as follows: UPSERT "SCHEMA"."TABLENAME" ..... WITH PRIMARY KEY.


Read more...

Environment

    SAP HANA Database

    Product

    SAP HANA, platform edition 2.0

    Keywords


    UPSERT, partition, RANGE, LocalUniqueConstraintTask, SQL performance, SAP HANA, database optimization, primary key, thread method, partition column, table configuration, query speed, database tuning, SQL query, partitioning, performance tuning , 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.