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

  • Thread starter Thread starter jquerijero
  • Start date Start date
Status
Not open for further replies.
J

jquerijero

Guest
[quote user="Torben"] If there is an index on active then my small test show: Best: table.active Equal: table.active = YES; table.active = NO (~ 10%) Worst: NOT table.active (> 200%) If there is not an index on active then: Best: table.active; NOT table.active Worst: table.active = YES; table.active = NO (~ 10%) [/quote] If this is true and since checking for negative is rare, it sounds like direct inspection of the field is better.

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