S
slacroixak
Guest
the "<>" ("not equal to" or "different than") operator does not help the ABL to pick up the most appropriate index concerned by a field of your where clause. As George said, using WHERE employee# > "" would help to make it pick up the employee# unique index. Besides, when I wonder about that, I prefer to ask the ABL itself rather than searching in a large doc or in a large set of KBase articles. Two options for that: a) For a simple FOR EACH loop, do a COMPILE XREF and pay attention to SEARCH entries b) for a QUERY object, you can look at its hQuery:INDEX-INFORMATION attribute. HTH /S
Continue reading...
Continue reading...