I'm an ABAP programmer. Recently I requested that an index be created on table PA0002 for the field AEDTM. A program I developed uses this field to read data from the parameter selected by the user. This is the only field searched in addition to ENDDA = '99991231'. Without the index the entire table is searched every time (33,000 record).
The index was refused because this program would be run in background and creating this index would do more harm than good since indexes are 'taxing to the system'. There are presently 3 indexes to this table which were packaged by SAP.
I think this concept of indexes is exaggerated and maybe even antiquated. In the case of the program mentioned above, when the user wishes to run this job with a small date range in foreground she will not be able to do so.
Your opinion would be greatly appreciated.
Well I am not sure that this question is really related to Workflow but as a developer myself I couldn't help but comment. I have fought many a fights with BASIS guys about adding Indexes. While it is true that adding an index does increase the overhead on maintaining that table (ie. Every time you update the table, the index also needs to be updated) this needs to be offset in the gain of search speed on the table. I suppose that if the program runs in the background and performance is not important then I guess an Index is not necessary. However if the user does run the job in the foreground then the 'wait time' may be unacceptable and I think you are well within your right to request and have the index. Also, tell your BASIS guys that the table PA0002 is not updated very frequently so the overhead of adding the index would not be a huge issue.
Dig Deeper on SAP workflow development
Related Q&A from Alon Raskin
Find out how to configure clients so that the same version of an SAP workflow item is used when the workflow is triggered in separate clients. Continue Reading
An SAP user has created a user decision step in an SAP workflow item and wants to know how an end user can send an attachment to other users. Continue Reading
A SearchSAP.com reader wants to know how to hide the forward button in an SAP Business Workplace toolbar. Continue Reading