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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Functions » Alphabetical list of functions

GETDATE function [Date and time] Next Page

GRAPHICAL_PLAN function [Miscellaneous]

Returns the plan optimization strategy of a SQL statement in XML format, as a string.


[, statistics-level
[, cursor-type
[, update-status ] ] ] )


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

statistics-level    An integer. Statistics-level can be one of the following values:

Value Description
0 Optimizer estimates only (default).
2 Detailed statistics including node statistics.
3 Detailed statistics.

cursor-type    A cursor type, expressed as a string. Possible values are: asensitive, insensitive, sensitive, or keyset-driven. If cursor-type is not specified, asensitive is used by default.

update-status    A string parameter accepting one of the following values indicating how the optimizer should treat the given cursor:

Value Description
READ-ONLY The cursor is read-only.
READ-WRITE (default) The cursor can be read or written to.
FOR UPDATE The cursor can be read or written to. This is exactly the same as READ-WRITE.
See also
Standards and compatibility

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 * FROM Departments WHERE DepartmentID > 100' );

The following statement returns a string containing the graphical plan for a keyset-driven, updatable cursor over the query SELECT * FROM Departments WHERE DepartmentID > 100. It also causes the server to annotate the plan with actual execution statistics, in addition to the estimated statistics that were used by the optimizer.

   'SELECT * FROM Departments WHERE DepartmentID > 100',
   'keyset-driven', 'for update' );

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