How to use EXPLAIN in COBOL program

The following statement sets the CURRENT EXPLAIN MODE special register, so that Explain information will be captured for any subsequent eligible dynamic SQL statements and the statement will not be executed.

   SET CURRENT EXPLAIN MODE = EXPLAIN

Recent Posts

Srini

Data Engineer with deep AI and Generative AI expertise, crafting high-performance data pipelines in PySpark, Databricks, and SQL. Skilled in Python, AWS, and Linux—building scalable, cloud-native solutions for smart applications.

One response

How to analyze SQL Query, the best way – Srinimf

September 22, 2016 at 11:29 am

[…] The data stored in SYIBM.SYSQUERY catalog table helps you find information about each SQL Query. This is the beginning step to validate before you are going to do EXPLAIN_PLAN on PLAN_TABLE (read more info here) […]

LikeLike