View Single Post
  #1  
Old 24th November 2005, 20:26
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
Experience with ANSI_OUTER_JOIN parameter

Greetings,

We are working towards migrating from Oracle 7.3.4.2 to Oracle 9.2.0.5 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.

Regards,
Suresh
Reply With Quote