Experience with ANSI_OUTER_JOIN parameter
We are working towards migrating from Oracle 22.214.171.124 to Oracle 126.96.36.199 alongwith other changes(much faster hardware than current). Baan version is IVc2 and the Porting Set will be 6.1c.07.08. OS will be AIX 5.2(ML4).
Baan solution 202168 talks about setting the ANSI_OUTER_JOIN to 1. Has anyone tried this and on what Oracle version? Have you seen any performance improvement with that?
We are facing some performance issues with some sessions while in some others we are not getting the desired results. Has anyone used this parameter and found any positive results on sessions like Generate Outbound, Sales Orders, etc.
Thanks in advance for your reply.