EXPLAIN has output with MATCHCOLS = 0. What does it mean?
Answers were Sorted based on User's Feedback
Answer / andank
When MATCHCOLS is 0, the access method is called a Non-
Matching Index Scan.
In the Non-Matching Index Scan, all the index keys and
their RIDs are read. Basically DB2 reads the full index
for that query.
Is This Answer Correct ? | 3 Yes | 0 No |
how to resolve -811 error. give clear explination
What is the use of db2 optimizer?
What is reorg in DB2
How to access db2 tables in mainframe?
What is cobol db2?
What do you mean by rollback?
Give a brief description of db2 isolation levels?
How to define the data items to receive the fetch items for the SQL?
how to u check the query is executing or not ?where will u check for sqlcode ?
what is the use of cursors?
How can record locking be achieved in those DB2 versions which do not support it?
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.