The number of index columns used for matching (MATCHCOLS=n)

If MATCHCOLS is 0, the access method is called a nonmatching index scan and all the index keys and their RIDs are read. If MATCHCOLS is greater than 0, the access method is called a matching index scan and the query uses predicates that match the index columns.

Introductory concepts

Begin program-specific programming interface information. In general, the matching predicates on the leading index columns are equal or IN predicates. The predicate that matches the final index column can be an equal, IN, NOT NULL, or range predicate (<, <=, >, >=, LIKE, or BETWEEN).

The following example illustrates matching predicates:

SELECT * FROM EMP
  WHERE JOBCODE = '5' AND SALARY > 60000 AND LOCATION = 'CA';
 
INDEX XEMP5 on (JOBCODE, LOCATION, SALARY, AGE);

The index XEMP5 is the chosen access path for this query, with MATCHCOLS = 3. Two equal predicates are on the first two columns and a range predicate is on the third column. Though the index has four columns in the index, only three of them can be considered matching columns. End program-specific programming interface information.