“Disjoint qualifications” message

The “disjoint qualifications” message often indicates a user error in specifying the search clauses. For example, this query searches for a range where there could be no values that match both of the clauses:

    where advance > 10000
    and advance < 1000

The selectivity for such a set of clauses is always 0.0, meaning that no rows match these qualifications, as shown in this output:

Estimated selectivity for advance,
   disjoint qualifications, selectivity is 0.0.