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
|