Interested to Buy Any Domain ? << Click Here >> for more details...
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
- 2 Answers
- 10963 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 parameters are used to control the free space in DB2?
How does coalesce work?
How do I add a column in db2?
What are the benefits of using the db2 database?
How to rename a table in DB2 ?
How do I connect my db2 database to ibm?
What is universal database?
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 the function of logging in the db2 database?
What is sqlca?
Explain in detail about buffer manager and its functionalities?
What is difference between isnull and coalesce?
What is cursor stability in db2?
What is the difference between dbm cfg and db cfg file in db2 ?
What is db2 command?
