Which is faster: n sql queries or n subqueries in IBM Cognos Report Studio?

Question

Oracle

Greetings.
There was such a question, because the summary report is taking a long time. The request itself is simple, but I would like to speed it up. Check in practice, too, as if not quickly for several reasons. There is no way to add indexes yet.
at the moment done through method 2.