Previous Topic: SQL Trace FacilityNext Topic: Online Debugger


EXPLAIN Statement

You can use the EXPLAIN statement to analyze the optimized access strategy for an SQL statement. An aspect of database definition or the formulation of the SQL statement can result in a relatively inefficient strategy for a given SQL statement. The information produced by the EXPLAIN statement can suggest corrective measures.

Note: For more information about the EXPLAIN statement and its use, see the CA IDMS SQL Reference Guide.