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

More Questions from Technology

• How does DB2 determine what lock- size to use?
• What is RUNSTATS?
• How do you insert a record with a nullable column?
• What is REORG? When it is used?
• What is sqlcode -811?
• Name and explain the type of locks?
• What is NOTCAT2?
• How do you display last 5 records in DB2?
• Difference between Embeded SQL and Dynamic SQL?
• What is DBRM? What it contains? When it will be created?

Discussion & Comments