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.
