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...
Continue reading...