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.
Start Interactive SQL and connect to the SQL Anywhere database.
Click Tools » Plan Viewer (or press Shift+F5).
Type a statement in the SQL pane.
Select a Statistics level, a Cursor type and an Update status.
Click Get Plan.
Connect to a database as a user with DBA authority.
Execute the GRAPHICAL_PLAN function.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|