This video provides an introduction and a demo to the Server-Side Joins functionality available with OpenEdge 12.0.

Sample Program


output to report.txt.
for each customer no-lock, 
    each order no-lock
         where order.custnum = customer.custnum,
    each orderline no-lock
         where orderline.ordernum = order.ordernum:
    put customer.custnum format ">>>>>9" skip.
output close.

display etime.


  • Server-Side Joins is enabled by default.
  • Join is resolved on the server-side and the performance is improved by reducing the number of records sent over the network.
  • The USE-INDEX option can be used to ensure that the desired index is used to resolve the joins.