Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
What is the significance of the QBLOCK_TYPE and JOIN_TYPE column of a PLAN table?
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 |
Updated on: 30-Nov-2020
97 Views
Advertisements