You can view the query optimizer's execution plan for a SQL statement in the Plan Viewer window in Interactive SQL.
For SQL Anywhere databases, only graphical plans appear in the Plan Viewer. For UltraLite databases only text plans are supported in the Plan Viewer. See Viewing an UltraLite execution plan.
To create a graphical plan
Type your query in the SQL Statements pane.
Choose Tools » Plan Viewer or press Shift+F5.
The Plan Viewer appears in a separate window. Your specified query appear in the SQL pane.
Click Get Plan to generate a plan for the specified query.
To open a graphical plan
Choose Tools » Plan Viewer.
Select a plan file (.saplan), and then click Open.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|