3633370 - How to check via HAC if an index is applied on a database table and its attributes - SAP Commerce Cloud

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

In SAP Commerce Cloud there might be necessity to create and add an index for a database table and its attributes to improve performance of query execution. This may be performed either on customer's side via defining the index in items.xml and running platform update afterwards or the index can be added by the database team by running a DML script directly on the database.

There is possibility to verify if index has been applied on the database team's side by issuing a support case. It is also possible to check applied indexes via Hybris Administration Console (HAC).

SAP Commerce Cloud

index, indexes, MSSQL , KBA , CEC-SCC-CLA-ENV-EMG , Environment Management , CEC-HCS-CCAZ-CO-DBA , DB , How To