Could be a number of reasons.
One common reason is due to the number of queries it hit on the database. For almost every outer join, it creates a SQL and produce a result table and then finally it joins all the different result tables. Creating each result table doesn’t taking much time, but it’s the number of them which increases the time.
Could look into if the joins in the report can be reduced, or can some of the joins be changed to Inner Join instead or could potentially improve it by introducing / creating some table views.
We have unrivalled expertise in successful C/ETRM and TMS implementations, and digital transformation projects, as well as defining market solutions that have become system industry standards. We have a proven track record of successful deliveries at greenfield projects and at existing clients.
Copyright 2022 KWA Analytics