ASA SQL User's Guide
Query Optimization and Execution
Reading access plans
Accessing the plan
You can access the plan using SQL functions, and retrieve the output in XML format.
To access the short plan, see the EXPLANATION function [Miscellaneous].
To access the long plan, see the PLAN function [Miscellaneous].
To access the graphical plan, see the GRAPHICAL_PLAN function [Miscellaneous].
To access the UltraLite plan, see the GRAPHICAL_ULPLAN function [Miscellaneous], SHORT_ULPLAN function [Miscellaneous], or LONG_ULPLAN function [Miscellaneous].