jeff thank you very much for your time, I tell you, they are the same queries with the same parameters, I take 3 minutes for example, but I execute it and it takes me seconds, that's why I suspect it is the shared buffer The server had 16 GB and we increased it to 24, but I really do not know if it should continue to increase since they are not our own resources, we have to ask for them and justify them
If that is the only query that you have trouble with, it might be easiest just to set up a cron job to run it periodically just to keep that data set in cache. Not very elegant, but it can be effective.
