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

EXPLANATION function [Miscellaneous]

Returns the plan optimization strategy of a SQL statement.

EXPLANATION( string-expression )

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

The optimization is returned as a string.

This information can help you decide which 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 Plan tab in the Results pane.

• Query access plans in UltraLite

• SQL/2003    Vendor extension.

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

SELECT EXPLANATION( 'SELECT * FROM Departments WHERE DepartmentID > 100' );