EXPLAIN has output with MATCHCOLS = 0. What does it mean?
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 |
Is the primary key a clustered index?
What is isolation level?
What are db2 objects?
What are PACKAGES ?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What are the rules for db2 programming?
what is utility for parm lib
Define data page.
What db2 400?
What is an alias and how does it differ from a synonym?
what is the name of the default db2 catalog database?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?