I said poor performance not only depends on the structure of the query but also on many other factors when running a report in BO or any other tool. We have to first find the root cause or bottleneck and then decide whether to modify the query or any other parameters within the reporting tool.