DBA > Job Interview Questions > DB2 INTERVIEW QUESTIONS

EXPLAIN has output with MATCHCOLS = 0. What does

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

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

a nonmatching index scan if ACCESSTYPE = I.

(Continued on next question...)

Other Job Interview Questions