SAP Knowledge Base Article - Preview

3384080 - Expensive select statement on M_CS_PARTITIONS

Symptom

Performance issues are caused on the system by the following statement:

Statement hash: c8f682aa3be41b442f4aa42395c5a099
SQL: SELECT MIN( RANGE ) FROM SYS.M_CS_PARTITIONS WHERE TABLE_NAME = 'MAI_UDM_STORE' AND RANGE > '20000101'


Read more...

Environment

FRUN 4 FP1

Product

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

Keywords

KBA , HAN-DB-PERF , SAP HANA Database Performance , SV-FRN-INF-MAI , FRUN: Monitoring and Application Infrastructure (MAI) , 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.