Use either Interactive SQL or the GRAPHICAL_PLAN function to view graphical plans. To access text plans, see Reading text plans.

Viewing graphical plans

To view a graphical plan (Interactive SQL)

1. Start Interactive SQL and connect to the SQL Anywhere database.

2. Type a statement in the SQL Statements pane.

3. Choose Tools » Plan Viewer.

4. Select a Statistics level, a Cursor type and an Update status and click Get Plan.

To view a graphical plan (SQL)

Use the GRAPHICAL_PLAN function to view a graphical plan in XML format, as a string.

1. Connect to a database as a user with DBA authority.

2. Execute the GRAPHICAL_PLAN function. See GRAPHICAL_PLAN function [Miscellaneous].

See also:

• Execution plan abbreviations