Progress offers SQL access to OpenEdge databases. This functionality allows you to integrate data stored in an OpenEdge database with applications written in SQL. The following content provides links to the guidelines for using SQL queries efficiently with OpenEdge databases.

Apply best practices for SQL query performance

The OpenEdge SQL engine contains a query optimizer that analyzes SQL queries and produces the best possible execution plan. The plan contains information such as which tables to access, in what order should they be accessed , and with which indexes should they be accessed. To produce a good query plan, the optimizer analyzes the query and considers many methods for each query execution step. For more information about the query optimizer, see: