Hi,
It is difficult to try to come into conclusions here, just based with these information. It would be required to review in more details. I suggest you to record a ST12 trace with your team and review it afterwards to see where the performance is happening.
Also, run the query and check the statistics, read KBA 1707239 - Analyze Query Performance with Statistics Data in RSRT and verify KBAs 1681396 - Query Performance, 1879725 - Query Memory Consumption.
Thanks,
Diego Seben
Add comment