The following query was run:
SELECT SYSTEM$EXPLAIN_PLAN_JSON( 'SELECT Z1.ID, Z2.ID FROM Z1, Z2 WHERE Z2.ID = Z1.ID' ) AS explain_plan;
Which information will the results provide?
SYSTEM$EXPLAIN_PLAN_JSON produces a JSON execution plan that includes partition statistics. Its global and table-scan statistics include partitionsAssigned, which identifies the partitions selected for scanning; the documented example for this SQL reports two assigned partitions.
SYSTEM$EXPLAIN_PLAN_JSON
partitionsAssigned
Community Discussion