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

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite SQL Function Reference » Alphabetical list of functions

SECONDS function [Date and time] Next Page

SHORT_PLAN function [Miscellaneous]

Returns a short description of the UltraLite plan optimization strategy of a SQL statement, as a string. The description is the same as that returned by the EXPLANATION function.


SHORT_PLAN( string-expression )


For some queries, the execution plan for UltraLite may differ from the plan selected for SQL Anywhere.


string-expression    The SQL statement, which is commonly a SELECT statement, but can also be an UPDATE or DELETE statement.

See also
Standards and compatibility

The following statement passes a SELECT statement as a string parameter and returns the plan for executing the query.

   'SELECT * FROM Departments WHERE DepartmentID > 100' );

This information can help with decisions about indexes to add or how to structure your database for better performance.

In Interactive SQL, you can view the plan for any SQL statement on the Plan tab in the Results pane.