Outer Join problem in reportnet

[msnaidu]

hi,
i have created a start schema in which one of the table is out joined with the fact.
when i am creating a query subject and adding the query item from the out-join table my query is getting slow.

can anyone pls tell me is this is due to the out-join that i created ,if so can you pls let me know the solutionalso.

Regards
Meera

 

[griffindm]

The primary reason an outer-join slows down a report is if there are a lot of data rows and the tables have no join on the column. If you can add an index on the column you should be able to speed up the report.

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[msnaidu]

we have index on the column.
well when i am creating the Datasource Query Item and setting SQL Setting-->SQL Type as Native in Framawork Manager,my query is working well but when i am creating the query item from the Model its taking tooo much time.

Meera