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.
LONG VARCHAR
SQL/2003 Vendor extension.
The following statement passes a SELECT statement as a string parameter and returns the plan for executing the query.
SELECT SHORT_PLAN( '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.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |