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

What is the physical storage length of the data types date, time, and timestamp?

1087

How does db2 sample database connect?

1029

What is deadlock in db2?

1069

Before you give the explain statement, what are the prerogatives?

1036

What is phantom read in db2?

1158

What is cloudant database?

1096

Explain in brief how does db2 determine what lock-size to use?

1045

What is the use of with ur in db2?

1057

Is db2 free?

1094

On which levels locks can be applied?

1131

How do you select a row using indexes in db2?

1135

What is lock escalation in db2?

1031

Can we update view in db2?

1002

What is view db2?

1076

Differentiate between cs and rr isolation levels? Where do you specify them?

1069