Description of the illustration
This image illustrates a table called CHECKS that has been range partitioned on CHKDATE. A local non-prefixed index on ACCTNO has been created. This index contains the following values:
-
ACCTNO31 and ACCTNO82 in CHKDATE 1/97
-
ACCTNO54 and ACCTNO82 in CHKDATE 2/97
-
ACCTNO15 and ACCTNO35 in CHKDATE 12/97