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
- AI Agents for Beginners: Everything You Need to Know
- Quick SQL Interview Questions for Data Engineers (Little Tricky)
- AWS Glue Crawler Issue with Dynamic S3 Folder Paths? Here’s the Complete Fix
- How to Create a Generic Stored Procedure for KPI Calculation (SQL + AWS Lambda)
- Unlocking the Power of Databricks Genie: A Comprehensive Guide
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