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. To access text plans, see Reading text plans.
Start Interactive SQL and connect to the SQL Anywhere database.
Choose 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. See GRAPHICAL_PLAN function [Miscellaneous].
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |