Sunday, July 15, 2018

Viewing an execution plan for SQL Anywhere 11

I recently needed to investigate what part of a query to an SQL Anywhere 11 database was taking so long. The database software comes with a program called DBISQL, or "Interactive SQL." Today I discovered that it has a section for doing exactly what I needed: Tools | Plan Viewer. Paste/type the query in the top box and press Get Plan, then information will appear below. The most helpful part - the tree - is in a tiny left pane by default and probably not visible, so that will probably need to be expanded. Nodes in the tree can be clicked for more information, like the table being accessed.

No comments:

Post a Comment