This 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