[progress Communities] [progress Openedge Abl] Forum Post: Re: How To Increase The...

[Brian K. Maher]

I think you asked the same question yesterday, however, my first comment would be to compile the code using the listing and xref options then see what indexes are being used and whether those are the best ones. When I see things like this the first thing I think of is (as someone else said) you have more data. The second thing I think of is that someone added or changed indexes in the database and the code was recompiled and now it is using different indexes . So, basically, you need to go do the basic set of analysis.

Continue reading...