Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Returns the long plan optimization strategy of a SQL statement, as a string.
PLAN( string-expression, [ cursor-type [ update-status ] ] )
The SQL statement, which is commonly a SELECT statement but which may also be an UPDATE, MERGE, or DELETE statement.
A string. cursor-type can be asensitive (default), insensitive, sensitive, or keyset-driven.
A string parameter accepting one of the following values indicating how the optimizer should treat the given cursor:
The following statement passes a SELECT statement as a string parameter and returns the plan for executing the query.
'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.
The following statement returns a string containing the text plan for an INSENSITIVE cursor over the query SELECT * FROM Departments WHERE DepartmentID > 100;.
SELECT * FROM Departments WHERE DepartmentID > 100;
'SELECT * FROM Departments WHERE DepartmentID > 100',