IBM DB2 Question:

Download Job Interview Questions and Answers PDF

EXPLAIN has output with MATCHCOLS = 0. What does it mean? ?

IBM DB2 Interview Question
IBM DB2 Interview Question

Answer:

a nonmatching index scan if ACCESSTYPE = I

Download IBM DB2 Interview Questions And Answers PDF

Previous QuestionNext Question
When DB2 connection fails, will online program work or give
errors?
What is DCLGEN ?