Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Query and modify data » Queries » Advanced: Query execution plans » Graphical plans


Viewing graphical plans

Use either Interactive SQL or the GRAPHICAL_PLAN function to view graphical plans. The GRAPHICAL_PLAN function displays a graphical plan in XML format, as a string.

 View a graphical plan (Interactive SQL)
  1. Start Interactive SQL and connect to the SQL Anywhere database.

  2. Click Tools » Plan Viewer (or press Shift+F5).

  3. Type a statement in the SQL pane.

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

  5. Click Get Plan.

 View a graphical plan (SQL)
  1. Connect to a database as a user with DBA authority.

  2. Execute the GRAPHICAL_PLAN function.

 See also

Customized graphical plans