Interested to Buy Any Domain ? << Click Here >> for more details...
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
- 2 Answers
- 11171 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 is blu acceleration in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is a system catalog table in db2?
What is page size in db2?
define clustering index.
Explain db2.
Define sqlca.
How to take backup of table in db2?
What is rct?
What is null value in db2?
List down the types of triggers in the db2 database?
How to find the number of rows in db2 tables?
What is netezza database?
What is drop table?
What language is db2 written in?
