ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

GRAPHICAL_ULPLAN function [Miscellaneous]

Function 

Returns the UltraLite plan optimization strategy of a SQL statement in XML format, as a string. The UltraLite plan does not include statistics.

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

Syntax 

GRAPHICAL_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]

LONG_ULPLAN function [Miscellaneous]

SHORT_ULPLAN function [Miscellaneous]

Example 

The following Interactive SQL example passes a SELECT statement as a string parameter and returns the plan for executing the query. It saves the plan in the file plan.xml.

SELECT GRAPHICAL_ULPLAN(
   'select * from department where dept_id > 100' );
OUTPUT TO ulplan.xml
FORMAT FIXED

To display the plan, open the ulplan.xml file in Interactive SQL.

As an alternative, you can view the plan for any SQL statement on the UltraLite Plan tab in Interactive SQL, choose File > Save, and change the file type to xml. To change the type of plan that is displayed, choose Tools > Options and open the Plan tab.