How creative do you want to get with this code to solve this access plan issue? I have a crazy idea that I believe will work. My understanding is that the operating system stores these access plans in the COBOL or RPG program objects. With the SQL complexity and dynamic nature of this program, I believe that the operating system is just getting confused. How about you make duplicate copies of this program object and call a different program depending upon the SQL request. This could be done with some fairly simple CL programming. 90% of the requests could be left alone but for the big ones that repeatedly show up in Query Optimizer, have the code execute them via a duplicate of the program object. Not sure whether one duplicate will be enough but if it were my code, I'd give it a try. Let me know what you think and how it goes if you decide to try it.