EXPLAIN has output with MATCHCOLS = 0. What does it mean?
Answer Posted / s
Non-matching index scan
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How to find the number of rows in db2 tables?
What is database alias db2?
What is catalog database in db2?
What are host variables in db2?
Name the various locking levels available?
Which component is used to execute the sql statements?
What is runstats utility in db2?
What is the role of the data page in the db2 database?
What is the clustering index in the db2 database?
is it compulsory commitment control in journal?
What is table space in db2?
What is node in db2?
What is a trigger in the db2 database?
How and when does the db2 enforces the unique key?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?