Interested to Buy Any Domain ? << Click Here >> for more details...
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
- 2 Answers
- 11150 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Explain about mirror activator disk mirroring?
How Plan is created while executing the query using SPUFI?
What DB2 Catalog column tell you when an index needs table reorganized ?
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
what is REORG? what is the use?
What is ACQUIRE/RELEASE in BIND?
Which component is used to execute the sql statements?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
How to execute stored procedure in db2 command editor?
What is a cursor in programming?
How are write I/Os from the buffer pool executed?
What is buffrpool? Where we use it ?
COBOL 
