Q
Problem solve Get help with specific problems with your technologies, process and projects.

The pros and cons of Indexing

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.

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.


This was last published in January 2002

Dig Deeper on SAP workflow development

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close