Interested to Buy Any Domain ? << Click Here >> for more details...
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
- 2 Answers
- 11148 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
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is runstats utility in db2?
What is the difference between cursor and select statement?
What is the maximum number of columns in a db2 table?
Explain dclgen.
What are the benefits of using the db2 database?
Are view updateable?
What is db2 stogroup?
Why do we use cursor?
What is isolation level in db2?
What is bind in db2?
On which levels locks can be applied?
What is runstats and reorg in db2?
What is the use of reorg in db2?
Differentiate between cs and rr isolation levels? Where do you specify them?
