first key value from the logical index and b is a second key value from a second logical index of the second partitioned table, and wherein the first predicate and the second predicate and the compound predicate are equality predicates or inequality predicates;