Interested to Buy Any Domain ? << Click Here >> for more details...
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
- 2 Answers
- 11107 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is commit in db2?
What is null indicator in cobol db2?
What is deadlock in db2?
What is dbrm library?
How do I delete a table in database?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is cursor in dbms?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is node in db2?
What is bufferpool in db2?
How to fetch the last row from the table in SQL (db2)?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
Which is faster delete or truncate?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
what is the sqlcode -501
