Skip to Content
0
Former Member
Jun 24, 2009 at 07:46 PM

Need to restrict database index use to a single program

16 Views

I have created a secondary index on the FMIOI table that consists of the following fields:

mandt

grant_nbr

hkont

objnrz

refbn

Before adding mandt to the index, another program used the index w/o mandt. Because the 2nd progam used the new index, it ran for an excessively long time. Once I added mandt to the index the 2nd program no longer used the index. I would like to know if there is a way I can insure that other programs do not use the index above.