Report Studio-How to Improve performance time

[Prajam]

Hi Friends,

This is prajam...
I have been stuck in some case... here it is...

Here is a very simple list report which pulls data from 2 tables. Report is running fine in dev. However it is taking around 40 mins to run in prod. It has all the joins, indexes and other stuff implemented.

If we use the parallel processing in the native sql, the query is running fast in TOAD. I have added similar parallel processing at Query level in report but output time is not as in TOAD.

So Please help me to solve it...
Thanks in advance

[CognosPaul]

Need more information.

Is this DMR or a standard model? What format are you running it in? How many rows? How many columns? Are you doing any complex calculations? Is there any local processing? Are the tables from the same schema? Do you have any filters?

Click on view generated SQL. Is it building the SQL correctly? Is the Cognos SQL drastically different than the native SQL? If Cognos is throwing multiple queries to the database, the parallel processing won't help much.