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
- 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
- Secure S3 File Upload Using API Gateway, Lambda & PostgreSQL (Complete AWS Architecture Guide
- AI Agents in Data Engineering: Everything You Need to Know
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