I am looking at some DB2 performance-tuning notes where I am seeing a phrase
I've not seen before. The notes speak of a test in a WHERE clause that
allows a row to be definitely exluded being a "Boolean Term". The converse
is referred to a non-Boolean term.

A quick Google tells me this terminology is not widely used outside DB2. Is
there a more widely understood term meaning the same thing?

Roy

"Roy Hann" <specially (AT) processed (DOT) almost.meat> wrote

Disjunctive predicates are those that have an 'OR' in them. They are a bit
more difficult to optimize than simple and conjunctive predicates because
whenever any term in a conjunctive predicate is false, the row is excluded,
and therefore processing need not continue; whereas for disjunctive
predicates, both sides of the 'OR' must be false in order to exclude a row.

Some other predicates are really disjunctive predicates, IN predicates, for
example. They can cause performance on some systems to bottom out because
often the conjunctive part of the query is executed many, many times--once
for each element in the IN list.

"Roy Hann" <specially (AT) processed (DOT) almost.meat> wrote

Disjunctive predicates are those that have an 'OR' in them. They are a bit
more difficult to optimize than simple and conjunctive predicates because
whenever any term in a conjunctive predicate is false, the row is excluded,
and therefore processing need not continue; whereas for disjunctive
predicates, both sides of the 'OR' must be false in order to exclude a row.

Some other predicates are really disjunctive predicates, IN predicates, for
example. They can cause performance on some systems to bottom out because
often the conjunctive part of the query is executed many, many times--once
for each element in the IN list.

"Roy Hann" <specially (AT) processed (DOT) almost.meat> wrote

Disjunctive predicates are those that have an 'OR' in them. They are a bit
more difficult to optimize than simple and conjunctive predicates because
whenever any term in a conjunctive predicate is false, the row is excluded,
and therefore processing need not continue; whereas for disjunctive
predicates, both sides of the 'OR' must be false in order to exclude a row.

Some other predicates are really disjunctive predicates, IN predicates, for
example. They can cause performance on some systems to bottom out because
often the conjunctive part of the query is executed many, many times--once
for each element in the IN list.

"Roy Hann" <specially (AT) processed (DOT) almost.meat> wrote

Disjunctive predicates are those that have an 'OR' in them. They are a bit
more difficult to optimize than simple and conjunctive predicates because
whenever any term in a conjunctive predicate is false, the row is excluded,
and therefore processing need not continue; whereas for disjunctive
predicates, both sides of the 'OR' must be false in order to exclude a row.

Some other predicates are really disjunctive predicates, IN predicates, for
example. They can cause performance on some systems to bottom out because
often the conjunctive part of the query is executed many, many times--once
for each element in the IN list.

"Roy Hann" <specially (AT) processed (DOT) almost.meat> wrote

Disjunctive predicates are those that have an 'OR' in them. They are a bit
more difficult to optimize than simple and conjunctive predicates because
whenever any term in a conjunctive predicate is false, the row is excluded,
and therefore processing need not continue; whereas for disjunctive
predicates, both sides of the 'OR' must be false in order to exclude a row.

Some other predicates are really disjunctive predicates, IN predicates, for
example. They can cause performance on some systems to bottom out because
often the conjunctive part of the query is executed many, many times--once
for each element in the IN list.

"Roy Hann" <specially (AT) processed (DOT) almost.meat> wrote

Disjunctive predicates are those that have an 'OR' in them. They are a bit
more difficult to optimize than simple and conjunctive predicates because
whenever any term in a conjunctive predicate is false, the row is excluded,
and therefore processing need not continue; whereas for disjunctive
predicates, both sides of the 'OR' must be false in order to exclude a row.

Some other predicates are really disjunctive predicates, IN predicates, for
example. They can cause performance on some systems to bottom out because
often the conjunctive part of the query is executed many, many times--once
for each element in the IN list.

"Roy Hann" <specially (AT) processed (DOT) almost.meat> wrote

Disjunctive predicates are those that have an 'OR' in them. They are a bit
more difficult to optimize than simple and conjunctive predicates because
whenever any term in a conjunctive predicate is false, the row is excluded,
and therefore processing need not continue; whereas for disjunctive
predicates, both sides of the 'OR' must be false in order to exclude a row.

Some other predicates are really disjunctive predicates, IN predicates, for
example. They can cause performance on some systems to bottom out because
often the conjunctive part of the query is executed many, many times--once
for each element in the IN list.

"Roy Hann" <specially (AT) processed (DOT) almost.meat> wrote

Disjunctive predicates are those that have an 'OR' in them. They are a bit
more difficult to optimize than simple and conjunctive predicates because
whenever any term in a conjunctive predicate is false, the row is excluded,
and therefore processing need not continue; whereas for disjunctive
predicates, both sides of the 'OR' must be false in order to exclude a row.

Some other predicates are really disjunctive predicates, IN predicates, for
example. They can cause performance on some systems to bottom out because
often the conjunctive part of the query is executed many, many times--once
for each element in the IN list.

"Brian Selzer" <brian (AT) selzer-software (DOT) com> wrote

Understood. But what I am after is whether there is a term or phrase with
the same meaning as "Boolean Term" (as used in the DB2 world) that would be
recognized by users of other products. "Conjunctive predicate" seems a
better candidate, but I can't recall it being used in a workplace setting.

This probably isn't a question for a theory group at all, but I figured this
might be one watering-hole shared by users of many different products.

Roy