If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Report level join - performance issue -its urgent

Started by Sunita, 20 Jul 2010 04:25:57 PM

Previous topic - Next topic

Sunita

Hi
I have a report in which i am taking data from 5 different tables. I have to Queries in my report 1 query has most of query item and second query has only two query item. I am performing a report level join on these two queries and then displaying data in list report.

If i remove this join from my report, performace improves (after join it is taking around 10-12 mins to fetch 10 records and around 20 mins to fetch 1000 records ie in any cases it at least takes 10-12 mins). Is there a way that i can avoid this report level join and still get the same results.

Thanks

Alp

I do not think that the information you have provided is sufficient for any advice regarding the report design.

Very generic low hanging fruit is try to gather statistics in the database, sometimes it makes real difference.

If you would like to dig deeper, you can try to write a SQL statement to get the same information from the database and run it in via any SQL client. This way you could see what you can get.

blom0344

What is the performance of the individual queries? You mention performance improvement when you omit the report level join.
The number of query items fetched will hardly matter. What matters is the execution path of the query. With stale statistics this could indeed be an issue (or by performing unneeded sorts or filtering on non indexed fields etc)

Sunita


Before adding new query (then performing the join on report) my report was taking round 3-4 mins and after this change my report is taking 10-15 mins.

Now y i have used report level join is because these tables have one to many join.
I will check for the indexes in database

Thanks,
Sunita