EXPLAN has output with MATCHCOLS ...

More DBA job interview questions and answers at http://dba.fyicenter.com/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 Job Interview Questions

• When can an insert of a new primary key value threaten referential integrity ?
• Where are plans stored ?
• Under what circumstances will DB2 allow an SQL satement ...
• How do you retrieve the data from a nullable column?
• How is the SUBSTR keyword used in SQL?
• MAX number of columns in a DB2 table
• What is the difference between group by and order by ?
• What is a SELECT statement ?
• How does the processing of a correlated subquery differ from a non correlated subquery ?
• What does the RUNSTATS Utility do?
• More...