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 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
- Step-by-Step: 4 Methods to Create RDS in AWS & Build Schemas
- From Laptop to Cloud: Deploy Your First Production DB Using Amazon RDS
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