Ansicht
Dokumentation

05121 - Creating indexes to improve performance...

05121 - Creating indexes to improve performance...

ROGBILLS - Synchronize billing plans   ROGBILLS - Synchronize billing plans  
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

CPI1466 during Backup   General Data in Customer Master  
This documentation is copyright by SAP AG.

Length: 1234 Date: 20240221 Time: 185328     sap01-206 ( 2 ms )