[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Question about the performance of ABL queries resolved by multiple indexes

  • Thread starter Thomas Mercer-Hursh
  • Start date
Status
Not open for further replies.
T

Thomas Mercer-Hursh

Guest
I think the mistake you are making in your expectations is that the SQL queries are reading a million *records* whereas the ABL query can identify the result set by reading the *indices*. Read the first index and get a list of rowids, compare that to the second index to get a smaller set of rowids, compare to the third index and get a list of rowids in the result set and then read only the records in the result set.

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