Thread: Experience with ANSI_OUTER_JOIN parameter
View Single Post
  #5  
Old 28th November 2005, 17:17
skapoor73 skapoor73 is offline
Junior Member
  
Join Date: Nov 2004
Location: Hercules, CA
Posts: 23
skapoor73 is on a distinguished road
Baan: BaaN IVc2, Baan 5.0c - DB: Oracle 7.3.4.2, Oracle 9.2.0.5 - OS: Unix 11.0, AIX 5.2
Performance is not optimal in some sessions without the ANSI parameter
Hi Dick,

I have not implemented and tried this parameter yet as my consultants pointed out that there are some known issues on metalink where the results of some queries may change. These seem to have been addressed in later versions of Oracle. At this point, I want to know if the incorrect query results issue applies to BaaN and Oracle 9.2.05 and if anyone else has got good results with this parameter(especially since it is recommended by SSA).

The performance in some sessions is not upto the mark on some sessions and that is without the ANSI_OUTER_JOIN parameter.

Thanks,
Suresh
Reply With Quote