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.