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

  • Thread starter Thread starter Torben
  • Start date Start date
Status
Not open for further replies.
T

Torben

Guest
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%)

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