Ansicht
Dokumentation

05121 - Creating indexes to improve performance...

05121 - Creating indexes to improve performance...

ABAP Short Reference   Addresses (Business Address Services)  
This documentation is copyright by SAP AG.
SAP E-Book

Creating indexes to improve performance...

Hi, guys.

I have seen several messages regarding the creation of an index to improve
runtime. The example was improving runtime from 30 minutes to 10 seconds by
creating an index.

I approached our ABAP programmers with this info and their reaction was
that they are hesitant to create indexes because of other performance
problems that they might be creating. For example, they could create an
index on the billing table(s) to improve runtime on queries done there, but
that, by doing so, they may increase the runtime on the actual billing
process (system having to update in more places). Is this the case? Can
anyone enlighten me here please?

Thanks.

Des Olwage
Snr. Systems Administrator
Goodyear South Africa
Tel. +27 41 5055441
Cell. +27 82 824 6900



Durban Tours - Südafrika Safari

Fill RESBD Structure from EBP Component Structure   General Data in Customer Master  
This documentation is copyright by SAP AG.

Length: 1234 Date: 20240328 Time: 152335     sap01-206 ( 3 ms )