[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Clarification on logical in query

  • Thread starter Thread starter Shao.Chan
  • Start date Start date
Status
Not open for further replies.
S

Shao.Chan

Guest
If I recall correctly, Gus weighed in on this about 20 years ago. Part of it depends on whether it is a mandatory logical field. If not, the unknown value has to be taken into consideration and thus NOT means = TRUE OR = ?. I am unsure how much the function makes a difference. I understand if the logical is made mandatory, the performance gap narrows as ? cannot be a possibility (I am unsure of that though). Either way = TRUE and = FALSE are the best as they are equality matches and NOT is potentially a multi-equality match.

Continue reading...
 
Status
Not open for further replies.
Back
Top