I have a very simple query that happens to traverse 5 tables.
These tables exist in the same Oracle database instance but in two different schemas.
When I look at the native SQL of the report (in Report Studio) I see two seperate SQL statements implying full outer join.
However when I look the Cognos SQL there are no outer joins at all.
Why would this happen
NKT
When there are separate sql statements in native sql, it doesnot imply a full outer join. What RN does is it fires the two sql separetly to the database and combines the dataset using the cognos sql. This helps in performance, as less load ( no joining b/w the two sql) is on the database.
U r getting two sqls because the tables comes from different schemas.
Srik