What is the significance of the QBLOCK_TYPE and JOIN_TYPE column of a PLAN table?

DB2DatabaseBig Data Analytics

The QBLOCK_TYPE column of the PLAN_TABLE mainly gives the information about the type of query. It can have the value as CORSUB which indicates that the query is Correlated subquery and NCOSUB indicates that the query is Non-correlated subquery.

The JOIN_TYPE column indicates the type of join used in the query. This column can take the value as per the below table.

Column value
Interpretation
BLANK
INNER JOIN/NO JOIN
F
FULL OUTER JOIN
L
LEFT OUTER JOIN
R
RIGHT OUTER JOIN
raja
Published on 30-Nov-2020 09:03:40
Advertisements