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
- Unlocking the Power of Databricks Genie: A Comprehensive Guide
- Secure S3 File Upload Using API Gateway, Lambda & PostgreSQL (Complete AWS Architecture Guide
- AI Agents in Data Engineering: Everything You Need to Know
- The End-to-End AI Stack – A Real Guide for Developers to Code, Create, and Execute
- 10 Workplace Communication Speaking Exercises to Improve Fluency at Work
Srinimf 
One response
[…] 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