- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
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 ACCESSTYPE and INDEXONLY column of a PLAN table in DB2?
The PLAN_TABLE in DB2 contains details of the access paths used by the optimizer from the EXPLAIN statement. This table gives much information about the PLAN having DB2 SQL statements.
ACCESSTYPE is one of the columns of PLAN_TABLE which gives details regarding the access type. The values which can be present in this column and its interpretation is given below.
Column value | Interpretation |
I | Indexed access |
R | Tablespace scan |
M | Multiple index scan |
N | Index access present in predicate |
The INDEXONLY column can take the value as ‘Y’ which indicates that the optimizer just needs to read indexspace in order to fetch the data for the query.
- Related Articles
- What is the significance of the QBLOCK_TYPE and JOIN_TYPE column of a PLAN table?
- What is the purpose of “NOT NULL WITH DEFAULT” clause used in DB2 table column?
- What is the definition and usage of alternate key in a DB2 table?
- How to store a NULL value in a particular column of a DB2 table using COBOL-DB2 program?
- How to execute a COBOL-DB2 program PROGA of plan PLANA?
- What is NULL check and insertion rule in a DB2 table?
- How to add a new column Address in the above DB2 table TAB1?
- What is the result of count function in the NULL value present in DB2 table?
- What are the limitations of using OUTER JOIN on a DB2 table?
- What is the use and syntax of SEQUENCE in DB2?
- What is the significance of Religion and caste in Hinduism?
- What is the significance of ‘^’ in PHP?
- What is the significance of the formula of a substance?
- How to get the list of all COBOL-DB2 programs using a DB2 table TAB1?
- What are COLUMN functions in DB2? Explain with the help of an example

Advertisements