Non-matching index scan

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

Question Posted / s

Answer Posted / s

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Which is faster delete or truncate?

1069

What is the function of logging in the db2 database?

1069

Give a brief description of db2 isolation levels?

1013

What is the use of dclgen in db2?

1011

What is a db2 table?

955

How to take backup of table in db2?

1021

What are the different types of base tables?

1027

Can you use max on a char column?

1027

What is dbrm?

1047

What is db2?

1124

What is meant by union and union all?

948

How to compare data between two tables in db2?

1032

What is ibm db2 database?

951

What is the physical storage length of time data type?

1064

How do I add a column in db2?

997