SHORT_PLAN( string-expression )

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

LONG VARCHAR

• EXPLANATION function [Miscellaneous]

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

SELECT SHORT_PLAN(
   'SELECT * FROM GROUPO.Departments WHERE DepartmentID > 100' );