ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

LONG_ULPLAN function [Miscellaneous]

Function 

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

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

Syntax 

LONG_ULPLAN ( string-expression )

Parameters 

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

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not supported by Adaptive Server Enterprise.

See also 

PLAN function [Miscellaneous]

EXPLANATION function [Miscellaneous]

GRAPHICAL_PLAN function [Miscellaneous]

GRAPHICAL_ULPLAN function [Miscellaneous]

SHORT_ULPLAN function [Miscellaneous]

Example 

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

SELECT LONG_ULPLAN(
   'select * from department where dept_id > 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 UltraLite Plan tab in the Results pane.