We are trying to run some exports to excel created in crystal report
and we have tried to optimize the process using indexes, materialized views and hints to avoid crossing during the query.
After the changes we do not get an improvement yet and we believe that is due to the volume of data.
How can we optimize the reports to get an acceptable answer?
In case that optimization was not possible.......
Which technical solution should we apply in order to get the excel (asynchronous executions, ....)
Thank you very much