Interested to Buy Any Domain ? << Click Here >> for more details...
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
- 2 Answers
- 11306 Views
- I also Faced
- E-Mail Answers
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 |
What is the syntax for seeing the columns and data types of a table in the db2 database?
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
What is the role of the data page in the db2 database?
Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?
What is dclgen in db2?
What are host variables in db2?
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
What is meant by dclgen?
What is the meaning concurrency in the db2 database?
if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?
COBOL 
