Hi gurus!
I have a PDF burst to all employees; it contains a lot of data throughout the database so requires approx 30 queries full outer join. This takes approximately 5-10 minutes per employee, so bursting to all employees will most likely fail.
Is there anything I can check to try to improve the report performance?
Hi, I'm not a guru but I used to work with a guy whose name was that.
Read up on ETL. Hideous messes such as full outer joins and reports with 30 queries strongly suggest that the design of the data warehouse that you are using (assuming that) is somewhat lacking.
It would be better if as much of whatever you are doing is done in the ETL so that there's views etc. in your data warehouse, which have had the bulk of the processing which you are needing already done.
In addition, since it would be in the data base and not hidden away in a report, it would be available in other reports, which is another aspect of the single version of truth stuff people go on about.