[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Query/Index Usage Question

  • Thread starter Thread starter David Abdala
  • Start date Start date
Status
Not open for further replies.
D

David Abdala

Guest
Because ABL does not have anything like "previous function evaluation". The result of the function is unknown to ABL up to the evaluation, so it has to be evaluated for each customer. (can-find is a function). Doing: if can-find() then name = "Jazz". else name = "Joe" find first customer where customer.name = name no-lock no-error. Should give you a different index usage.

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