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

SAP Sybase SQL Anywhere 16.0 » UltraLite - Database Management and Reference » UltraLite performance tips » Query performance tips » Execution plans in UltraLite


Viewing an execution plan

Use Interactive SQL to display an UltraLite plan that summarizes how a prepared statement is to be executed. The text plan is displayed in the Interactive SQL Plan Viewer.


There are no prerequisites for this task.

Context and remarks

In UltraLite, an execution plan is strictly a short textual summary of the plan. No other plan types are supported. However, being a short plan, it allows you to compare plans quickly, because information is summarized on a single line.

  1. Click Tools » Plan Viewer.

  2. In the SQL pane, type a query.

  3. Click Get Plan to generate a plan for the specified SQL statements.


The text plan appears in the lower pane of the Plan Viewer.


Consider the following statement:

SELECT I.inv_no,, T.quantity, T.prod_no
FROM Invoice I, Transactions T
WHERE I.inv_no = T.inv_no

This statement might produce the following plan:


The plan indicates that the join operation is completed by reading all rows from the Invoice table (following an index named primary). It then uses the index named secondary from the Transactions table to read only the row whose inv_no column matches.

 See also