SAP Knowledge Base Article - Preview

2429439 - Slow SELECT on table on HANA due to missing or corrupt primary index

Symptom

  • In one HANA system the SELECT on the table is fine but in another system where the table definition, partitioning and number of records are the same the performance is poor
  • From st12 trace for ABAP program or transaction you can see that all or most of the time is Database time 

 


Read more...

Environment

SAP HANA Database

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

poor performance; Does not exist in the database; Create database index; ERCH; ISU_COLOGRP_MIGRATION; PCA_SECURITY_RAW; PCA_SECURITY_RAW-001 , KBA , HAN-DB-PERF , SAP HANA Database Performance , SV-PERF , Performance Problems , 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.