EXPLAN has output with MATCHCOLS ...

DB2 ( IBM Database 2 ) Interview Questions

(Continued from previous question...)

EXPLAN has output with MATCHCOLS ...

Q: EXPLAN has output with MATCHCOLS = 0. What does it mean ?

An:
A nonmatching index scan if ACCESSTYPE = I .

(Continued on next question...)

Other Interview Questions

• What is the picture clause of the null indicator variable?
• What is the difference between Where and Having Clause ?
• an I alter a table when other user is selecting some columns ...
• The only place of VSAM KSDS in DB2 is
• What is deadlock?
• What is isolation level?
• What are delete-connected tables ?
• What is the difference between IN subselects and EXISTS subselect?
• What is a LIKE table and how is it created?
• What is a DBRM, PLAN?
• More...