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.
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.