How to Use Secondary Index in ABAP CDS

[former_member188589]

Hi Expert,

I have a created a CDS view to get the list if Functional Locations from ECC. I have only one condition on the Structure Indicator used in the Where condition. When we do a Performance testing in Q system we found the system takes a bit longer to execute the CDS ans send a response back to UI. We thought of creating a Secondary index and that we will use in the CDS view. Now the real question is -

1. How to use the secondary index in ABAP CDS.

2. Without the Secondary index can the CDS performance will be improved?

Regards,

Nitin

[p244500]

Hi,

you don't need to used secondary index in CDS , but if you need you can create search index with Annotation .

Index

Performance Optimization for ABAP CDS view

https://answers.sap.com/questions/641407/how-to-use-secondary-index-in-a-abap-hana-programm.html

Regards,

Nawa.