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 cursor with hold option in db2?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is the purpose of rollback and commit?
What is check constraint. Explain with example.
Which component is responsible for processing sql statements and selecting access paths?
How to view db2 table structure?
What is cobol db2?
Define db2.
How to compare data between two tables in db2?
How do I change the column size in db2?
Which are the db2 tools to protect integrity of the database?
What are catalog tables in db2?
What is the difference between oracle and db2?
What is drop table?
What is the difference between dbm cfg and db cfg file in db2 ?