Interview Questions   Tutorials   Discussions   Programs   

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




617
views
asked mar September 2, 2014 12:22 PM  

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


           

1 Answers



 
answered By Mswami   0  
MATCHCOLS: The number of index columns matched on an index scan. If MATCHCOLS=0 then it is called non-matching index scan. Ie., a nonmatching index scan if ACCESSTYPE = I

If it is 0 all index keys and RIDs are read.

If one of the matching predicates is a range there will be no more matching columns.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview

 Write A Tutorials
Online-Classroom Classes
www.writeabc.com


  1 person following this question

  1 person following this tag

  Question tags

Asked 2 years and 3 months ago ago
Number of Views -617
Number of Answers -1
Last updated
3 years and 3 months ago ago

Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert