Hello friends,
One of programs uses DFKKOP to retrieve data. However this table is very large (>15m entries) and it takes hours before getting results back and the users are unhappy about the length of time. Now, I have two questions:
1) Is it possible to force the use of a particular index via ABAP , or, is this something automatic and we have no say in what index is being used? If possible, then how and do you have an example?
2) Failing the above, are there other tables which give the same info as DFKKOP? In other words, we'd like to replace the SELECT... FROM DFKKOP... with other SELECT statements from other tables and get the same kind of info.
Your help is much appreciated.