A partial index is defined using a restriction so that only some of a table's rows are indexed. In the optional attribute case, the restriction specifies that only rows with not null values for the column will be indexed; in the billed and unbilled orders case, only unbilled rows are indexed.
