OpenEdge Release 12.0 is enhanced to perform server-side joins. Certain queries that join multiple tables are now resolved in the database server rather than the client. As a result, fewer records may be returned to the client leading to faster performance. Server-side join is turned on by default in a multi-threaded database server and only for certain FOR statements containing up to 10 tables in the same logical database. Server-side join cannot be activated in a non-threaded database server.

For 12.0 server-side join is limited to FOR statements that use NO-LOCK.

For more information on server-side join for the current version of OpenEdge, see Server-side join processing.