| Home | Previous Lesson: Executing SQL Statement Next Lesson: Commenting Code |
To optimize a query one would like to know details such as how much I/O it needs or which indexes it uses and so on. For that select Design > Explain SQL from the menu.
Even though the query plan is seen in PowerBuilder, it is returned by the connected database. The output for the query plan varies from database to database.
| Home | Previous Lesson: Executing SQL Statement Next Lesson: Commenting Code |