OpenEdge Release 11.7.3 Service Pack includes the following improvement to the OpenEdge DataServer for MS SQL Server:
Performance Improvement for two level single-shot join query
Starting in this release, two level single-shot join queries are evaluated as join-by-server on the server side. Single-shot refers to the use of either FIRST or LAST criteria as part of join query. This could result in significant performance improvements for the two-level single-shot join queries.
An example of single-shot ABL is shown below:
FOR EACH customer, FIRST [or LAST] order OF customer
WHERE state = “MA”:
DISPLAY Name.
END
