EXPLAIN has output with MATCHCOLS = 0. What does it mean?
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 the use of dclgen in db2?
How can you classify the locks in db2?
what is db2 restart?
What is host variable?
What is the function of logging in the db2 database?
Define db2 and its databases?
Explain packages.
What is the use of value function?
What is netezza database?
How can deadlocks be resolved?
What is the purpose of using commit?
Define buffer pool.
What is cloudant database?
What do you mean by between and in? Is between inclusive of specified range values?
What is commit in db2?