Regarding Query Optimizing in Cognos8

[dwsudheer]

Hi all i have a query ie how to optimizing a lenghty query in cognos8?

plz do needfull

Thanks in Advance

Sudheer

[goose]

Generally long reports mean the sql thats getting issued to the database is not optimal. Open the report in question in Report Studio, from the menu select Tools -> Validate with Options, select Information from the dropdown and click ok. This will show you the sql that will get executed when the report runs, you will now be able to identify any performance issues in the sql and rectify the solution. Normally this means remodelling in FM, things to look out for are multiple sql statements that are getting joined locally in cognos.

In complex reports often report validation fails, in this case you can a) log the native sql in CC and check th audit db for the sql or b) run a trace on database and get the sql that way.

Good luck

[dwsudheer]

Thanks for Reply


Regards

Sudheer