A report contains multiple queries that are joined to form the report, resulting in poor performance. The company's policy prohibits the use of user-defined SQL statements within reports.
What should be done to improve report performance?
A report contains multiple queries that are joined to form the report, resulting in poor performance. The company's policy prohibits the use of user-defined SQL statements within reports.
What should be done to improve report performance?
To improve the performance of a report containing multiple queries joined together, the best approach is to move the appropriate filters to the underlying queries. This reduces the amount of data processed and transferred between queries, leading to more efficient overall report execution. By filtering data earlier in the process, unnecessary data is eliminated before the join operation, which optimizes performance.
D) is correct https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_cra.doc/c_queryexecution.html
B is correct
your answers are incorrect, please provide a supporting link or valid reason.