EXPLANATION( string-expression )  

LONG VARCHAR

The statement's access plan is returned as a string. For information about interpreting the result, see Advanced: Query execution plans.

The GRAPHICAL_PLAN function offers significantly greater information about access plans, including system properties that may have affected how the statement was optimized.

This information can help you decide which indexes to add or how to structure your database for better performance.

• Execution plans in UltraLite

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' );