Explaining SQL
Sometimes there is more than one way to code SQL statements to
obtain the results you want. If you connect to an SAP database using
an SAP native driver, or to a SQL Anywhere database using the ODBC
driver, you can select Explain SQL on the Design menu to help you
choose the most efficient coding method. Explain SQL displays
information about the path that PowerBuilder will use to execute the
statements in the SQL Statement Execution Plan dialog box. This is
most useful when you are retrieving or updating data in an indexed
column or using multiple tables.
DBMS-specific information
The information displayed in the SQL Statement Execution
Plan dialog box depends on your DBMS. For more about the SQL
execution plan, see your DBMS documentation.