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
- Ingesting Data from AWS S3 into Databricks with Auto Loader: Building a Medallion Architecture
- Building Scalable Data Pipelines with dlt-meta: A Metadata-Driven Approach on Databricks
- Exploring Databricks Unity Catalog – System Tables and Information _Schema: Use Cases
- PySpark Functions Real Use Cases
- Unity Catalog in Databricks – Key Multiple-Choice Questions
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