Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
I
I
Ivan P2022-03-18 13:02:38
Oracle
Ivan P, 2022-03-18 13:02:38

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

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.
6234587ac8442261176481.png

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

0 answer(s)
Similar questions
V
Vladimir2019-02-08 15:54:37
Because of what, when connecting to Oracle through sqlplus, it gives out "no listener"? 3Reply
M
mosikus2022-04-11 14:38:27
Why does it throw a literal does not match format string error when adding a date? 1Reply
A
anton13ms2020-11-25 09:01:39
What causes an ORA-01219 error in Oracle DB? 1Reply
J
Jaga-jaga2014-10-04 11:08:48
How to work with a large database using DataSet C#? 1Reply
O
Oleg Aksenov2019-03-06 10:55:55
How to overwrite an entry in Golden Gate if it exists? 0Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question