SAP Knowledge Base Article - Preview

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


  • 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 




SAP HANA Database


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


poor performance; Does not exist in the database; Create database index; ERCH; ISU_COLOGRP_MIGRATION; , 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 ONE Support launchpad (Login required).

Search for additional results

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